Creating Aliases for Dimensions and Members

In an outline, you can assign alternate names, or aliases, to a dimension, a member, or a shared member. For example, in the Sample Basic database outline, members of the Product dimension are identified both by product codes, such as 100, and by descriptive aliases, such as Cola.

To create aliases for a Dynamic Time Series member, see Creating Aliases for Dynamic Time Series Members.

  To create aliases for dimensions or members:

  1. Open the outline in edit mode.

  2. Right-click a dimension or member and select Edit member properties.

  3. In Member Properties, select the Information tab.

  4. Under Aliases, in the text box next to the appropriate alias table, enter the alias for the member.

    Be sure to follow proper naming rules. For naming restrictions, see the Oracle Essbase Database Administrator's Guide.

  5. If you want to view the alias you just created, make sure the appropriate alias table is set as the active table for the outline, and set the Outline Tools option to display aliases.

  6. Click OK.

Related Information