Selecting Items in QueryBuilder

Use the Items panel to select the measures to include in the query. With the measures, you can choose any of the measures' dimensions to use for creating a view of the data.

To select items:

  1. In the Available box, view all the measure folders that are listed with their associated measures. The dimensions that are associated with these measures and the hierarchies for the dimensions are also listed.

  2. Select the measures to include in the query. Be sure to select each measure by name. You cannot select measures by selecting folders.

  3. Determine which of the measures' dimensions and which of the dimension hierarchies that you want to use to create the data view. Any dimensions that you do not select are not available on the Dimensions tab, and only the data corresponding to the first member of the first level in the default hierarchy is returned.

    Tip: You can select a different value for a hidden dimension by using the Hidden Dimensions panel.

  4. If you want to use all of the measures' dimensions in specifying the view, then choose Automatically Add Dimensions.

  5. If you want to use some of the measures' dimensions in specifying the view, then select them by name. Do not choose Automatically Add Dimensions.

  6. Use the right arrow button to move the selected measures, dimensions, and hierarchies from the Available box to the Selected box.

  7. Use the other tabs of the QueryBuilder to further refine the selection.

Selecting Dimension Members in QueryBuilder