About Shared Members

A shared member shares storage space with another member of the same name, preventing duplicate calculation of members that occur multiple times in a cube. Shared members are available for Entity, Account, and user-defined custom dimensions.

Sharing members allow alternate rollup structures within an application. A base member must exist before an administrator can create a shared member. Administrators can create multiple shared members for the base member. A base member must display before its shared members in position from top to bottom.

You can drill on shared members in an ad hoc grid, but an administrator must first enable a system setting called Allow drill down on shared members in ad hoc.

Shared members are displayed similarly to base members in the dimension hierarchy for member selection in Oracle Smart View for Office.