About Duplicate Member Names
When you create an Essbase cube, you can specify that duplicate (non-unique) member names and aliases are allowed in a cube outline, with some restrictions.
- From the web interface, log in as a power user, and click Create.
- Enter a unique application name and any cube name.
- In the Classic Web Interface, expand Advanced Options.
- Select Allow Duplicate Member Names.
- Click OK.
A duplicate member outline might, for example have a Market dimension and require two members named New York: one as a child member of the dimension parent member, Market, and one as a child of the member, New York. The member names are displayed as New York. The qualified member names are:
-
[Market].[New York]
-
[Market].[New York].[New York]
To add a duplicate member name, enter the duplicate member in the outline. There are no additional requirements for adding a duplicate member. See Add Members to Outlines Manually.
- If the outline is not enabled for duplicate members, then an error is returned when a duplicate member name is entered.
- Dimension names, generation names, and level names must always be unique, and sibling members under a parent member must always be unique.
- You must enable duplicate member names at the time you create the application. You cannot convert a unique member outline to a duplicate member outline.
- Duplicate member names applies to the entire outline and cannot be assigned only to a single dimension, for example.
- After you migrate a cube with a unique member outline to Essbase 21c, you cannot change the outline to allow duplicate members. If you want the cube to allow duplicate members, you must convert the unique member outline to a duplicate member outline before migrating.