The Member Selection tab enables you to restrict access privileges to a selection of the data. The initial selection is the topmost level of the default hierarchy.
You can select members 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 from 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.
Members
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.
Conditions
Enables you to select and customize conditions for selecting dimension members. This subtab provides examples of various types of conditions. You modify the examples to create the exact condition that you want for a step in a query.
Hierarchy conditions select members based on hierarchical relationships, such as family members and levels. A sample condition is "Children of Regions of the World." Expand this folder to see the examples.
Steps
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.
Members
Identifies the members selected by the current list of enabled steps.
Condition Expression
Displays the expression syntax that defines the current selection.
Show Conditions
Click to update the expression in the Condition Expression box.
Copyright © 2003, 2007, Oracle. All rights reserved.