Friday, December 28, 2012

Displaying Duplicate Member Names in Oracle Hyperion Smart View, Fusion Edition Release 11.1.1


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.
Screenshot for Step

2.
Select Hyperion > Ad Hoc Analysis > View Qualified Member Name.
Screenshot for Step
The qualified member name is displayed in a dialog box.

3.
Click OK to return to your report.
Screenshot for Step


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.
Screenshot for Step
The Options dialog box is displayed.

2.
Select the Display tab.
Screenshot for Step

3.
Under Member Name Display Options, select Member Name Only.
Screenshot for Step

4.
Click OK to return to your report.
Screenshot for Step
Note: Changes to display options are not applied until you refresh your report.

5.
On the Smart View toolbar, click Refresh (Refresh).
Screenshot for Step

6.
View qualified member names in your report.
Screenshot for Step


Summary


In this tutorial, you learned how to:

 Display a single qualified member name
 Display qualified names for all duplicate members in a report