About Alias Tables

Alias tables are database tables that store aliases, or alternate description labels, for dimensions or members. Oracle Essbase enables you to define multiple alias tables. Web Analysis user preferences enable you to specify which alias table to use. The alias table selection is saved as a Web Analysis Database user preference.

Label mode enables you to select whether dimension members are listed by ID number or description. Label mode options are data source-specific, and are set for database connections, specific documents, and specific dimensions.

Label mode indicates whether the description or ID number is used and the database alias table provides the displayed value. Set the alias table before opening documents using Web Analysis Database user preferences.

Specify which description label to use in specific dimensions, using Dimension Browser and set a default label mode after querying the data source using Data Display options on the data object right-click menu.