Purpose
This tutorial covers how to display duplicate member names in Smart View.
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. Smart View provides methods to display the qualified names in your reports.
Note: The procedures described in this tutorial are for Excel 2003. In Excel 2007, the Hyperion menu referenced in this tutorial is located on the Add-ins tab of the Ribbon and Smart View toolbar icons are on the Hyperion tab.
Prerequisites
Before starting this tutorial, you should:
1. |
Have access to or have Installed Smart View.
|
2. |
Have access to an Essbase database that contains duplicate names.
|
3. |
Create a Smart View report that includes duplicate names.
|
4. |
Have an active connection to your Essbase database from your Smart View report.
|
5. |
In Smart View options, ensure that your member name display is Description Only.
|
Displaying a Qualified Member Name
To display the qualified name of a single member, perform the following steps:
1.
|
Select a cell containing a member name.
|
2.
|
Select Hyperion > Ad Hoc Analysis > View Qualified Member Name.
The qualified member name is displayed in a dialog box.
|
3. |
Click OK to return to your report.
|
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 Hyperion > Options.
The Options dialog box is displayed.
|
2.
|
Select the Display tab.
|
3. |
Under Member Name Display Options, select Member Name Only.
|
4. |
Click OK to return to your report.
Note: Changes to display options are not applied until you refresh your report.
|
5. |
On the Smart View toolbar, click (Refresh).
|
6. |
View qualified member names in your report.
|
Summary
In this tutorial, you learned how to:
Display a single qualified member name | ||
Display qualified names for all duplicate members in a report |