Web Analysis Studio features these default drilling behaviors:
Drill Down includes a member's children in the display.
Drill Up includes a member's parent in the display.
Drill to Top includes the highest ancestor in the display.
You can customize drilling by setting drilling options. Drilling options are set for the current document through the data object shortcut menu (select Drill, then Drill Options). Drilling options can also be set for all subsequently created documents through Drilling preferences.
This table describes Web Analysis Studio drilling options:
Table 22. Drilling options
Drilling Option | Description |
|---|---|
Drill to Next Level | Includes the children of the drilled member in the display. |
Drill to Descendants | Includes all descendants of the drilled member in the display. |
Drill to Dim Bottom | Includes the lowest level descendants of the drilled member in the display. |
Drill to Siblings | Includes members at one level who share a parent with the drilled member. |
Drill to Same Level | Includes all members on the drilled member's level. Note: Hyperion defines levels as hierarchical layers counted up from the lowest descendant (Level 0). Other data sources define levels differently. Asymmetric hierarchies may also yield unexpected results. |
Drill to Same Generation | Includes all members on the drilled member's generation. Note: Hyperion defines generations as hierarchical layers counted down from the highest ancestor (Generation 0). Other data sources define generations differently. |
Drilling options are data-source specific. Drilling options that are not supported by the data source default to Drill to Next Level.