Lesson: Drilling Across Columns

You can display the results of a drill-down across columns. Drilling across columns applies only to the top-level member of a dimension (for example, Product or Scenario).

  To drill down on Scenario and retrieve its respective members into columns:

  1. Press Alt and double-click Scenario (in cell E1).

  2. Release Alt.

    Essbase displays the data in columns across the worksheet:

    Result of drilling-down on the Scenario dimension (nested columns).

  3. Keep this worksheet open, but do not save it.

    You use this worksheet again in Lesson: Drilling Up to Less Detail.

User Reference

Drilling Down to More Detail