Displaying Duplicate Member Names in Smart View

Purpose

This tutorial covers displaying duplicate member names from Essbase databases in Microsoft Excel using Smart View.

Time to Complete

Approximately 20 minutes

Topics

This tutorial covers the following topics:

	Overview
	Scenario
	Prerequisites
	Displaying a Qualified Member Name
	Displaying Qualified Names for All Duplicate Members
	Summary
	Related information

Viewing Screenshots

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. You can hide an individual screenshot by clicking it.

Overview

When you enable duplicate member names in an outline, Essbase can display the same name for two or more members and, internally, store the names in a qualified format that differentiates the members. Smart View provides methods to display the qualified names of duplicate members in your reports.

Back to Topic List

Prerequisites

Before starting this tutorial, you should:

Back to Topic List

Displaying a Qualified Member Name

To display the qualified name of a single member, perform the following steps.

Back to Topic List

Displaying Qualified Names for All Duplicate Members

To display the qualified names of all duplicate members in a report, perform the following steps.

Back to Topic List

Summary

In this tutorial, you've learned how to:

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

Back to Topic List

Related Information

	To learn more about duplicate member names in Smart View, refer to the Hyperion Smart View for Office Release 9.3.1.0.0 User's Guide.
	To learn more about duplicate member names, refer to the Hyperion Essbase Release 9.3.1.0.0 Database Administrator's Guide.
	To learn more about Smart View, refer to additional OBEs on the OTN Web site

Back to Topic List

Place the cursor over this icon to hide all screenshots.