Use the Dimensions panel to specify the dimension members for which to return data.
Choose a dimension from the drop-down list in the Choose box, if the list is available.
The list of available dimensions on the Dimensions panel, if available, results from the dimensions that you selected on the Items panel.
Choose one of the dimension's hierarchies in the drop-down list in the From box. (The From box is not displayed if the dimension has no hierarchy.) If the dimension has only one hierarchy, then it is chosen automatically. If the dimension has no hierarchy, then skip this step.
All the members of the dimension, ordered according to the specified hierarchy, appear in the Available box. Select available dimension members to use in the query, using the Members, Conditions, or Saved Selections panels.
Use the shuttle buttons to copy the dimension members that you have selected from the Available box to the Selected box.
Selecting items in the OLAP QueryBuilder
Copyright © 2001, 2005, Oracle. All rights reserved.