You can drill down or drill up on a member that has a shared member defined in the Essbase outline. Essbase determines which members are eligible — the base member or the shared member, and returns drilled or stored members based on the drill path.
This is an Essbase outline:
Product
100
150 (stored member)
100-10
100-20
Brand1
150 (shared member)
The stored member 150 has children; the shared member 150 does not. Drilling up and down on 150 gives different results:
Drilling down on 150 returns nothing if it is interpreted as the shared member; or, returns 100-10 and 100-20 if it is interpreted as the regular member.
Drilling up on 150 returns Brand1 if it is interpreted as the shared member; or returns 100 if it is interpreted as the regular member.
The proximity of the shared member to the regular member gives different results when drilling down. When drilling up on a member that has a shared member, Essbase looks at the members to determine which one is being queried. For example, drilling up on 100-20 sometimes returns Diet and returns 100, depending on whether Diet or 100 is closest to the member 100-20. If 100-20 is alone, then Essbase determines that this is the regular member. If Diet is closer, then 100-20 may be interpreted as the shared member.