Lesson: Drilling Up to Less Detail

With Essbase, you can drill up to higher levels in the multidimensional database outline by collapsing the current member tree. For example, if you previously drilled down on a dimension, such as Scenario, to view data for Actual and Budget, drill up to view aggregate data for the Scenario dimension.

  To drill up on a member, use one option:

  • Select the member, then select Essbase, and then Zoom Out.

  • Select the member, and then double-click the secondary mouse button.

  • Select the member, and then click Zoom Out on the Essbase toolbar.

  To drill up on the Scenario dimension in the current worksheet:

  1. Return to the worksheet that you kept open in step 3 under Lesson: Drilling Down to More Detail.

  2. On a member of the Scenario dimension (that is, cell C2, D2, E2, F2, or G2), double-click the secondary mouse button.

    Essbase collapses the members of the Scenario dimension:

    Result of drilling up on the Scenario dimension.

  3. In cell A3, double-click the secondary mouse button to drill up on East.

    Essbase collapses East, West, South, and Central into the Market dimension and keeps the dimension in the A column:

    Result of drilling up on East.

User Reference

Drilling Up to Less Detail