GLDACCOUNT Accounts
The GLDACCOUNT dimension organizes both local and group account structures. You can view account hierarchies and their relationships. The additional top nodes are added to reflect calculated metrics and KPIs with the KPI Account Group Mapping and the Decision Tree. The Decision Tree is used in the C-Suite dashboard (Enterprise_Perspective).
User benefits of the GLDACCOUNT dimension include:
- Clear visibility of both local and group account structures
- Mapping of local accounts to group accounts, to simplify the analysis of consolidated financial data
- Detailed account attributes for reporting and analysis
Hierarchy Details
These hierarchy details are available:
- Name: GLDACCOUNT
- Caption: Accounts
Attributes
This table shows the attributes of local and group accounts:
| Attribute Name | Description | Data Type | Value Description |
|---|---|---|---|
| ACCTYPE | Account Type | String (71) | Account or Group Account type property, such as: Assets, Liabilities, Income, Expenses, Equity or Statistical. |
| SCHEDULE | Schedule | String (71) | Account or Group Account Schedule property |
| IC | Intercompany | Boolean | Intercompany property |
| SEG1 | Segment 1 | Boolean | Segment 1 property |
| SEG2 | Segment 2 | Boolean | Segment 2 property |
| SEG3 | Segment 3 | Boolean | Segment 3 property |
| Format_String | Format String | String (252) | Format String property |
| ... | Custom properties defined in the Account business object | Various | As configured |
Use the Group Account property in the Accounts business object to map local accounts to group accounts.
The Group Account and KPI Account Group properties affect the GLDACCOUNT structures but are not published to OLAP as attributes.
The ACCTYPE attribute manages the global sign conversion. The Format_String attribute controls how the amount format is displayed. The remaining attributes provide additional information about intercompany or segment relations, but don't support business logic or user interface filtering.
Built-in elements
This table shows the built-in elements of the GLDACCOUNT dimension:
| Element ID | Parent ID | Name |
|---|---|---|
| GROUP_STRUCTURE | — | Group Structure |
| LOCAL_ACCOUNT | — | Local Accounts |
| N.A. | — | Unassigned |
| TOTAL_FOUNDATIONAL_METRIC | — | Foundational Metrics |
| TOTAL_KPI | — | KPIs by Category |
| DECISION_TREE | — | Decision Tree |