Viewing Qualified Member Names

You can view the qualified member names of members having non unique or identical names for better understanding and identification.

Different members or member aliases may have identical names. For example, a database may have two members named "New York," one for New York City and one for New York State. Both members can appear as "New York" in the grid, but if you want to distinguish between them, you can display their qualified names instead. Qualified names include the member name and the names of its ancestors to the level that uniquely defines the member. For example, [Market].[New York].

Following are the ways in which you can view the qualified names of identical members:

Viewing Qualified Names in Cell Information

You can view qualified names of identical members in the Cell Information dialog. For more information, see Viewing Member Cell Information.

To view the qualified names:

  1. Select a member cell in the grid.
  2. From the provider ad hoc ribbon or Essbase ribbon, in the Analysis section, select Cell Information Cell Information button.
  3. In the Member Information dialog, select the Alias tab to view the qualified name of the selected member.

Displaying Qualified Names on the Sheet

You can display the qualified names on the sheet using Smart View Options.

To display the qualified names of identical members on the sheet:

  1. In the Smart View ribbon, select Options, Options button, to launch the Options panel.
  2. In the Options panel, select the Members tab.
  3. From the Member Name Display drop-down menu, select Distinct Member Name Only.
  4. In the Smart View ribbon, click Refresh.

    The grid on the sheet is refreshed with the qualified names.