Rules when creating shared members:
Shared members must be in the same dimension. For example, both 100-20 members in the Sample.Basic database are in the Product dimension.
An unlimited number of shared members can have the same name.
You can create a shared member for a member with a duplicate member name. Specify the duplicate member name for which you want to create the shared member. The qualified name of the duplicate member, on which the shared member is based, is displayed in the Member Properties dialog box. See “Defining Shared Members” in the Oracle Essbase Administration Services Online Help.
If accounts properties are assigned to shared members, the values for those accounts properties are taken from the base member, even if the accounts properties on the shared member are changed.
An actual member must be located in a dimension before its shared member.
Avoid complex relationships between actual and shared members that will be part of an attribute calculation, or a calculation may return unexpected results. See Understanding Attribute Calculation and Shared Members.
Note: | You cannot create a shared member and the member on which it is based under the same parent. In a duplicate member outline, siblings must be unique. |