Essbase retrieves shared members during drill-down, depending on their location in the spreadsheet. Essbase follows three rules during this type of retrieval:
Essbase retrieves referenced members (not their shared member counterparts) by default.
Essbase retrieves from the bottom of a spreadsheet first.
If the parent of a shared member is a sibling of the referenced member counterpart of one of the shared members, Essbase retrieves the referenced member.
Example of Shared Members from a Single Dimension
If you create a test dimension with all shared members based on the referenced members of the dimension East from the Sample.Basic outline, the outline would be similar to the one shown in Figure 6-1:
Figure 6-1 Shared Members from a Single Dimension
If you retrieve only the children of East, all results are from referenced members because Essbase retrieves referenced members by default.
If, however, you retrieve data with the children of test above it in the spreadsheet, Essbase retrieves the shared members:
New York Massachusetts Florida Connecticut New Hampshire test
If you move
test above its last two children, Essbase retrieves the first three children as shared members, but the last two as referenced members. Similarly, if you insert a member in the middle of the list above which was not a sibling of the shared members (for example, California inserted between Florida and Connecticut), Essbase retrieves shared members only between the nonsibling and the parent (in this case, between California and test).
Example of Retrieval with Crossed Generation Shared Members
You can modify the Sample.Basic outline to create a shared member whose referenced member counterpart is a sibling to its own parent, as shown in Figure 6-2:
Figure 6-2 Retrieval with Crossed Generation Shared Members
If you create a spreadsheet with shared members in this order, Essbase retrieves all the shared members, except it retrieves the referenced member West, not the shared member west:
West New York Massachusetts Connecticut New Hampshire test
Essbase retrieves the members in this order because
test is a parent of
west and a sibling of its referenced member counterpart,