Purpose
This tutorial covers how to display duplicate member names in Spreadsheet Add-in.
Overview
When you enable duplicate member names in an outline, Essbase displays the same name for two or more members and internally stores the names in a qualified format that differentiates the members. Spreadsheet Add-in provides methods to display the qualified names in your reports.
Prerequisites
Before starting this tutorial, you should:
1. |
Have access to or have installed Spreadsheet Add-in.
|
2. |
Have access to an Essbase database that contains duplicate names.
|
3. |
Create a Spreadsheet Add-in report that includes duplicate names.
|
4. |
Have an active connection to your duplicate-names database.
|
Displaying Qualified Member Names as Comments
Excel comments are displayed when you place your cursor over a cell that contains a comment indicator. When you enable the display option, Essbase creates Excel comments that contain qualified member names. Unlike standard Excel comments, which are cell-specific, Essbase-generated comments are member-specifc and move with members during ad hoc operations such as zoom in and pivot. To display the qualified name of duplicate members as Excel comments, perform the following steps:
1.
|
Select Essbase > Options.
![]()
The Options dialog box is displayed.
|
2.
|
Under Duplicate Members, select Show Qualified Member Names as Comment.
![]() |
3. |
Click OK to return to your report.
![]()
Note: Changes to display options do not take effect until you refresh the report.
|
4. |
Select Essbase > Retrieve.
![]()
Excel comment indicators are displayed in cells that contain duplicate member names.
|
5. |
Place your cursor over a cell that contains a duplicate member name to display the qualified member name.
![]() |
Displaying Qualified Names for All Duplicate Members
To display the qualified names for all duplicate members in a report, perform the following steps:
1.
|
Select Essbase > Options.
![]()
The Options dialog box is displayed.
|
2.
|
Under Duplicate Members, select Show Qualified Member Names on Sheet.
![]()
Note: You can leave Show Qualified Member Names as Comment selected.
|
3. |
Click OK to return to your report.
![]()
Note: Changes to display options do not take effect until you refresh the report.
|
4. |
Select Essbase > Retrieve.
![]() |
5. |
View qualified member names in your report.
![]() |
Summary
In this tutorial, you learned how to:
![]() | Display qualified member names as comments | |
![]() | Display qualified names for all duplicate members in a report |