Explanation/Reference:
The data values associated with a shared member come from another member with the same name. The shared member stores a pointer to data contained in the other member, and the data is stored only once.
To define a member as shared, an actual nonshared member of the same name must exist.
Using shared members lets you use members repeatedly throughout a dimension. Essbase stores the data value only once, but it displays in multiple locations. Storing the data value only once saves space and improves processing efficiency. (B)
Shared members must be in the same dimension. Data can be shared by multiple members.
Incorrect answers:
A: Attributes, not shared members, offers cross-tab, reporting
D. Shared member can be assigned to both dense and sparse members.