Displaying Aliases for Members

Aliases are alternate names for database members. You can create reports that use the database member name, which is often a stock number or product code, and display the member alias name, which can be more descriptive than the member name, in the worksheet reports. For example, in the Sample Basic database, the alias name for the Product member 100 is Colas. The Application Designer defines alias names for members using the Alias Table in Administration Services Console.

To display a member alias name, rather than its database name:

Select Essbase, and then Options.
In Essbase Options, select Display.
Under Aliases, select an option:
- Use Aliases—Uses aliases from the selected alias table.
- Use Both Member Names and Aliases for Row Dimensions—Uses member and alias names for row dimension members.

Click OK.

Note:

The order in which the members appear on one row can affect whether the alias member combination is displayed at retrieval. Alias member combinations work only when depending members are specified before the member defined in the alias combination.