Designer GL Ledger Specifics

Use the following table to enter data in the Spreadsheet Server Settings > Ledger Specifics >Designer GL panel, or to access other functions:

Field	Description
Designer General Ledger Options:
File Name	Specify the Designer GL file name. May use alphanumeric or underscore characters.
Connection Name	Click the drop-down list, and select the connection name. Right-click and select Refresh to refresh the data.
Key 1 Caption	Specify the caption for Key 1.
Key 1 Data Validation	Specify the values to be included in the Key 1 drop-down list.
Key 2 Caption	Specify the caption for Key 2.
Key 2 Data Validation	Specify the values to be included in the Key 2 drop-down list.
QuickText	Specify the button label to appear in the Spreadsheet Server Ribbon > Build a Template > General Ledger menu, to identify the ledger for building a `GXL` formula.
Tool Tip	Specify the tool tip to display for the associated QuickText item.
SAP: Secondary Database Connection	For SAP Designer GLs only, if desired, specify the name of the secondary database connection to be used for processing.
SQL TRIM Supported	If selected, the `TRIM` function used in SQL to remove a specified prefix or suffix from a string is supported.
Preload HSegments	If selected, `HSegment` values are preloaded into the cache when Spreadsheet Server is started. If not selected, the hierarchy option in the Locate Segment function is disabled, as there are no values to display.
Reset Connections on Clear Cache & Recalculate	If selected, the system closes and reopens connections when the Clear Cache & Recalculate function is processed, in an effort to improve performance. This option should only be selected in specific scenarios. Please contact insightsoftware prior to selecting this option.

Button	Description
Set Default Designer GL	Opens Windows Explorer, allowing the user to browse to, and, select or set the default Designer GL without having to enter a password.
Load Default GL Definition	Loads the default Designer GL data in the panel. This function is password protected.
Browse for GL Definition	Opens Windows Explorer, allowing the user to browse to and select a Designer GL definition. This function is password protected.
Refresh Acct Key Sec Cache	Refreshes the account segment security cache, to process any changes made to ad hoc files.
Save	Saves all changes to the Designer GL definition.

Note: These options are used to maintain Designer GL definitions. These panels are password protected. Contact insightsoftware for more information.

See Spreadsheet Server Settings for more information.

Designer GL Ledger Specifics

Was this article helpful?