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.

In the Setup and Maintenance work area, use the Manage General Ledger Profile Options task:

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 Values for GL_DISPLAY_SEGMENT_VALUE Profile Option Code

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: 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.

Profile Value

Description

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:

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.