To drill down to lower levels of the Year dimension:
On Year in cell A2, double-click the primary mouse button.
The drill-down action retrieves data for the level below (the children of) Year: Qtr1, Qtr2, Qtr3, and Qtr4:
With Essbase, you can retrieve members into columns or rows that are grouped or nested. Row groups containing multiple levels of data are nested within single-member row groups. For example, a row group containing Qtr1, Qtr2, Qtr3, and Qtr4 may be nested within one-member row for a region, such as East. Drilling down to lower levels of database members is one way to retrieve data into nested groups.
In cell D1, double-click to drill down on Market and create nested groups of rows down the worksheet:
