Display Only Segment Value Descriptions in Reports
The GL: Set Cube Alias to Segment Value Description Only profile option controls the display of the member alias in General Ledger balances cubes.
- Offering: Financials
- Functional Area: General Ledger
- Profile Option Code: GL_DISPLAY_SEGMENT_VALUE
This table describes the profile value settings. After you change the value, you must republish the hierarchy.
Profile Value | Description |
---|---|
No |
Default value. Displays segment value plus the segment value description, for example, 1110 Cash. You must use this setting 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: Oracle Essbase cubes display only the first 80
characters in a description, so the first 80 characters of a
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. |
Yes |
Displays only the segment value description, for example, Cash. If you set the profile value to Yes, and then
decide to rebuild the cube or to create the cube by submitting an
accounting configuration, and duplicate descriptions exist, the
cubes creation process will error. You have two options at that
point:
|