Drilling Down or Up On Shared Members

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.

Here is an example outline:

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:

Proximity of the shared member to the regular member gives different results when drilling up: