In a planning worksheet, use toolbars and menus to expand (zoom in) and collapse (zoom out) dimension hierarchies and lists of measures to view data values at the level needed for analysis.
See Changing the Worksheet Layout.
Right-click a dimension member and select Zoom In.
The branch of the hierarchy directly below the selected dimension member is expanded. You can zoom in until the branch is fully expanded.
Right-click a dimension member and select Show Hierarchy Level, where Hierarchy Level is a lower level in the hierarchy.
The hierarchy expands to show that level. For example, right-clicking on a Geography dimension may show options such as Show Region and Show Territory.
Right-click a dimension member and select Zoom Out.
The hierarchy collapses so that only the parent of the selected dimension member is displayed. You can zoom out until the branch containing the selected dimension member is fully collapsed.
Right-click a dimension member and select Show Hierarchy Level, where Hierarchy Level is a higher level in the hierarchy.
The dimension hierarchy collapses to show that level. For example, if a Time dimension is fully expanded, right-clicking on the Month hierarchy level may show options such as Show Quarter and Show Year.
Right-click a dimension member and select Show Summary.
The hierarchy for that dimension collapses to the top-level view.
To return to the default view of the dimension hierarchy, click
or select Oracle, and then Reset to Default Layout.When a dimension, such as Time, is expanded horizontally in a planning worksheet, the hierarchy moves left to right from lower levels (more detailed, Months) to higher levels (more summarized, Years). The most summarized level (All Time) is at the far right. When a dimension, such as Geography, is expanded vertically in a worksheet, the hierarchy moves top to bottom from lower levels (more detailed, such as Cities) to higher levels (more summarized, such as Countries). The most summarized level (All Locations) is at the bottom. These summation directions are consistent with how Excel shows summations at the bottom of a column of numbers or at the right end of a row of numbers.
To set the behavior of the Show Hierarchy level menu:
In an Excel planning worksheet, click
or select Oracle, and then View Display Options to open Options.In the How does control level zoom navigation perform? section, select one of the following:
To navigate to level members in current member’s hierarchy only, select Show level members within member's hierarchy. For example, in Fiscal dimension, if you clickShow Month Level menu on member 2007 (year level), all months for 2007 are listed.
To navigate to all level members in a selected level, select Show all level members. For example, in Fiscal dimension, if you click Show Month Level menu on member 2007 (year level), all months for all years are listed.