Use the Drill tab to define the next level of data displayed when you drill down in a CubeQuery.
Additionally, the Member Retention option group contains items that enable you to customize drilling retention characteristics.
| Drill Level | Description |
|---|---|
| (Drill Level drop-down) | Defines the next level of data displayed when you drill down from the Query menu, or when you double click a member. Any drill down selection made from the shortcut menu overrides the selection made here. For example, if you select Bottom Level, data for the lowest level of members in a dimension is retrieved. A drill-down on Year retrieves: Jan, Feb, Mar, Apr, Ma, Ju, Jul, Aug, Sep, Oct, Nov, and Dec. Valid drill down levels are:
|
| Member Retention | Description |
|---|---|
| Include Selection | Retains the selected member along with the other members retrieved as a result of a drill down. For example, if you drill down on Qtr1, the data for Jan, Feb, and Mar, as well as Qtr1, is retrieved. When this option is disabled, the data for only for Jan, Feb, and Mar, is retrieved: Qtrl is eliminated. By default this option is enabled. |
| Within Selected Group | Applies (drilling) to only the group of members in which the selection is made. By default this setting is disabled. It is meaningful only when the report contains two or more dimensions of data down a report as rows or across a report as columns. This type of report is considered asymmetric, which is characterized by groups of nested members that differ by at least one member. |
| Remove Unselected Groups | Removes all dimension groups that are not in the selected group. |