Drilling Down

The Drill Down feature retrieves data from the multidimensional database cube, following the hierarchy down to the granular level. When you want to learn more about an item, such as a product line, drill down into the item label. You can drill down on one or items.

For a member drill down, any Top Label or Side Label can be drilled down so that you can view the structure of the hierarchies for any particular dimension. Every time you select a specific label in a dimension row or column, show only the data for that label value. When you select the dimension tab for a level, show all the members of that dimension level.

Use one of the methods to drill down on a label:

Double-click the label.
Select the label and choose Drill Down on the shortcut menu.

Select the label and choose OLAP , then Drill Down.

Tip:	You can specify what level of data is the next level displayed when you drill down in an OLAPQuery.

Note:

You cannot set filters while in a drilled-down state on a dimension.

Note:

Essbase only. For a measure drill down, you can show how different measures consolidate. A drill down on a measure is done on a progressive basis, one level at a time on a 1 to n path (sequential rather than nested). For example, if Profit is the parent of Tax and Pre-Tax Profit, and Revenue and Expenses are children of Pre-Tax Profit, the Tax and Pre-Tax columns are drilled down first and you must double-click the Pre-Tax label to display the Revenue and Expense columns.