Menu: Object > Data
A special way of drilling in Objects is using Hierarchies. A Hierarchy is an organization of a Dimension into levels.
For example the Year dimension can be divided into four quarters, each again divided into 3 months. Dimension levels that can be expanded are shown with a plus (+) sign in the Object while non-expandable hierarchy members are shown by a minus (-) sign. Clicking the + or - signs expands or collapses the hierarchy. Holding the cursor over the + or - sign will show a hint giving the name of the next level.
Objects with a hierarchical dimension on the X-axis will have 'Expand level' and 'Collapse level' buttons in the Object title bar. They work the same way as the corresponding menu items, and they have an effect on all hierarchical X-axis dimension values.
The following illustration shows a hierarchical Cross tabulation Object.
The Object shows Revenue per Period. In a non-hierarchical Object, the selected Year Dimension would be the highest level of detail available for drilling. Using hierarchies, it is possible to Drill down even further. As shown above, the Drill Down has been accomplished by expanding the year 2010 into quarters and months.