Considerations for GL Balance Cube Dimension Values That Are Customer-Specific
In creating your cube, consider the dimensions that you, the customer define, and those that are partially or completely already predefined.
The Chart of Accounts and Scenario dimensions have customer-specific dimension values and require user procedures to populate the cube. The Accounting Period, Currency, and Ledger dimensions are customer-specific, but are automatically created in the cubes from the changes made in the applicable user interfaces. Other dimensions, such as Amount Type and Balance Amount have only predefined members.
Consider the following points when setting up and populating cubes for the Chart of Accounts and Scenario dimension members.
Create Account Hierarchies
Create account hierarchies for your chart of account dimensions on the Manage Account Hierarchies page or the Manage Trees and Trees Versions page after setting up your value sets, chart of accounts, and values. Create account hierarchies (trees) to identify managerial, legal, or geographical relationships between your value set values. Define date-effective tree versions to reflect organizational changes within each hierarchy over time.
To create account hierarchies, in the Setup and Maintenance area, go to the following:
-
Offering: Financials
-
Functional Area: Financial Reporting Structures
-
Task: Manage Account Hierarchies
Publish Account Hierarchies
After defining the tree versions, publish the account hierarchies (tree versions) to the cube. Before publishing, set the profile option called GL: Set Cube Alias to Segment Value Description. Consider the following points when setting the profile option:
-
The member alias displayed in the GL balances cubes.
-
Yes: Displays only the segment value description, for example Cash.
-
No: Displays the segment value plus the segment value description, for example 1110 Cash.
-
-
When you change the profile option setting, republish the hierarchy.
-
The default value is No. No is necessary when there are duplicate segment value descriptions in the same value set. The descriptions are stored in the alias in the cube. Aliases must be unique in a dimension in the cube. For example, if the description West existed for more than two segment values in the Cost Center value set, the entire cube creation process fails.
Note: Essbase cubes display only the first 80 characters in the description, so the first 80 characters in the description must be unique. -
If duplicate segment value descriptions exist, the cube can be created with the profile set to No. At any time the value of the profile can be changed to Yes after the duplicates are removed. At that time, the account hierarchies (tree versions) must be published or republished to the cube.
-
If you set the profile value to Yes, and then decide to rebuild a cube from a process run in Enterprise Scheduler, or create a cube by submitting an accounting configuration and duplicate descriptions exist, the cubes creation process errors. You have two options at that point:
-
Set the profile value to No and run the Create Cubes process. For a new ledger with a new chart of accounts and accounting calendar combination, submit the accounting configuration.
-
Remove the duplicates across all dimensions, not just a single segment. Then run the Create Cubes process or resubmit the accounting configuration.
-
In the Setup and Maintenance work area, go to the following:
-
Offering: Financials
-
Functional Area: Financial Reporting Structures
-
Task: Publish Account Hierarchies
Use the Publish Account Hierarchies page to search for and publish account hierarchies.
-
Select the Publish check box. This is the indicator of what to include in the balances cube by selecting the check box, or what you don't want to include in balances cube by removing the check from the check box.
-
Select the rows. Functionality allows for multiple rows to be selected.
-
Select the Publish button to update the balances cubes. A process is generated.
-
Monitor the process from the Scheduled Processes work area.
Define Scenario Dimension Members
The customer-specific Scenario dimension members are defined on the Manage Value Sets and Manage Values pages in the value set called Accounting Scenario. Any customer-specific Scenario dimension is included in all balances cubes.
Best practice is to set up the customer-specific Scenario members in this value set before you create your first ledger and run the Accounting Configuration process, which generates your balances cubes. If the cubes already existed, you can run the Create Scenario Dimension Members process to update the balances cubes for the new members.