The Dimensions tab enables you to restrict a query to the selection of data that interests you. The initial selection is the topmost level of the default hierarchy.
You can select members for a query either individually from a list of available members or by applying one or more conditions. In the Available panel, the Members subtab enables you to select from a list of members, and the Conditions subtab enables you to apply conditions.
Your choice of dimension members is recorded in the Selected panel. The Members subtab lists the selected dimension members, and the Steps subtab lists the criteria by which these members were selected. You can view, modify, reorder or remove individual dimension members or steps to further refine your query.
Choose
Specifies the dimension for which to select members.
From
Specifies the name of the hierarchy to use for the dimension. This box is not available if the dimension has no hierarchies.
Displays a list of available members for the specified dimension and hierarchy. Select one or more individual members or a range of members, then use the shuttle buttons to move them to the Selected Members subtab.
The Available Members subtab contains the following buttons:
Collapse All
Collapses all available members to the highest hierarchical level. This button is available only when a hierarchy is specified in the From box.
Expand All
Expands all available members to the lowest hierarchical level. This button is available only when a hierarchy is specified in the From box.
Find
Displays the Find Members dialog box, which allows you to search for particular members from a complete list.
Displays the list of selected steps for a specified dimension. A check mark indicates that a step is enabled, that is, it will be used to select or eliminate dimension members.
Identifies the members selected by the current list of enabled steps.
Sort
Displays the Sort Items dialog box, which enables you to sort members using a sort criterion.
Move Up
Moves the selected member or step up one position in the list. For example, moving a step up one position in the list swaps it with the step that was before it.
Move Down
Moves the selected member or step down one position in the list. For example, moving a step down one position in the list swaps it with the step that was after it.
Copyright © 2003, 2007, Oracle. All rights reserved.