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 condition templates for the specified dimension.
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.