Duplicate Member Names
Data source types: Oracle Analytics Cloud - Essbase, Oracle Enterprise Performance Reporting Cloud
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]
.
When you first perform an ad hoc query on a database that supports duplicate member names, the default for the Member Name Display display option for members in the both grid and the POV is Member Name Only
Perform the procedure in this topic to display qualified member names in the grid and POV.
Note:
In Oracle Enterprise Performance Reporting Cloud, duplicate member names are allowed across dimensions, but they are not allowed within dimensions.To display the qualified names of duplicate members: