Lesson: Displaying Aliases for Member Names

You can create reports that use database member names (which are often stock numbers or product codes), or alias names.

For example, members of Product in the Sample Basic database are defined as codes, such as 100 and 200. A descriptive alias for each member of Product, such as Colas and Root Beer, is defined in an alias table. In some cases, alias names may vary depending on the combination of other database members. For example, Product member aliases may differ for each market in which the product is sold.

  To display the alias of a member rather than its database name:

  1. In cell C2, double-click the secondary mouse button to drill up on Actual.

  2. Press Alt and drill down (double-click) on Product in cell D1.

  3. Select Essbase, and then Options.

  4. In Display, under Aliases, select Use Aliases.

  5. Under Alias, select Default .

  6. Click OK.

  7. Select Essbase, and then Retrieve.

    Essbase changes the Product codes (100, 200, and so forth) to their predefined aliases (Colas, Root Beer, Cream Soda, and so forth). In the Sample Basic database, Product is the only dimension with predefined aliases.

    Result of displaying aliases

    Notice that Essbase is still displaying the styles that you created and applied in the previous sections.

User Reference

Displaying Aliases for Members