Working with Duplicate Members in Essbase

The table below provides details how duplicate members are referenced in an Oracle Essbase application

Table 1-13 How Duplicate members are referenced in an Essbase application

Scenario Qualified Name Syntax Example
Duplicate member names exist at generation 2 [DimensionMember].[DuplicateMember] [Year].[Jan]
Duplicate member names exist in an outline but are unique within a dimension [DimensionMember]@[DuplicateMember] [Year]@[Jan]
Duplicate member names have a unique parent [ParentMember].[DuplicateMember] [East].[New York]
Duplicate member names exist at generation 3 [DimensionMember].[ParentMember].[DuplicateMember] [Products].[Personal Electronics].[Televisions]
Duplicate member names exist at a named generation or level, and the member is unique at its generation or level DimensionMember]@[GenLevelName]|[DuplicateMember] [2006]@[Gen1]|[Jan]
In some scenarios, the differentiating ancestor method is used as a shortcut. DifferentiatingAncestor].[Ancestors...].[DuplicateMember] [2006].[Qtr1].[Jan]