You can drill down or drill up on a member containing a shared member defined in the Essbase outline. Essbase Server determines which member you are working with, the base member or the shared member. Depending on the worksheet and which members are the closest to the member that you are drilling up or drilling down on, Essbase Server decides which member you are querying and retrieves the information accordingly.
Product 100 150 (regular member) 100-10 100-20 Test1 150 (shared member)
Note that the regular member 150 contains children; the shared member 150 does not. Drilling up and down on 150 gives different results.
The proximity of the shared member to the regular member gives different results when drilling down:
If Test1 is on the worksheet and very close to 150, Essbase Server understands that 150 is the shared member and drilling down does not result in the children, 100-10 and 100-20.
If Test1 is not on the worksheet or members are in between them, Essbase Server understands 150 to be the regular member so drilling down results in the children 100-10 and 100-20.
Proximity of the shared member to the regular member gives different results when drilling up:
When drilling up on a member containing a shared member, Essbase Server looks at the members in the worksheet to determine which one is being queried.
For example, using the Sample Basic application and database, drilling up on 100 20 sometimes returns Diet and returns 100. It depends on whether Diet or 100 is closest to the member 100-20. If 100-20 is alone, Essbase Server determines that this is the regular member. If Diet is close, 100-20 may be interpreted as the shared member.