Web Analysis Studio features these default drilling behaviors:
You can customize drilling by setting drilling options. Drilling options are set for the current document through the data object shortcut menu (Drill / Drill Options). Drilling options can also be set for all subsequently created documents through Drilling preferences.
Drilling Option | Description |
|---|---|
Drill to Next Level | Includes children of drilled member. |
Drill to Descendants | Includes all descendants of drilled member. |
Drill to Dim Bottom | Includes a list of members on the bottom level of hierarchy without Selected member. The member is replaced with a list of members on the bottom level. |
Drill to Siblings | Includes members at one level who share a parent with the drilled member |
Drill to Same Level | Includes all members on drilled member's level. Note: Oracle | Hyperion defines levels as hierarchical layers counted 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 drilled member's generation Note: Oracle | 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.