Lesson: Displaying Member Names and Aliases

You can configure Essbase to display aliases and database member names in Spreadsheet Add-in.

  To display the name and alias of a member:

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

  2. In cell C2, select Colas, then select Essbase, and then Pivot.

  3. In cell C3. select Year, then select Essbase, and then Pivot.

  4. Select Essbase, and then Options.

  5. In Display, under Aliases, select Use Both Member Names and Aliases for Row Dimensions.

    Verify that Use Aliases is selected.

  6. Click OK.

  7. Select Essbase, and then Retrieve.

    Essbase displays member names and their aliases for row dimensions. Because Product is the only row dimension containing preassigned aliases, only the Product members display their aliases. Region members simply repeat the member name instead of displaying an alias.

    Result of displaying both member names and aliases.