Building an OLAP query online

Building an OLAP query online means that you will retrieve data from your cube data source every time you make a change to an OLAP query.

About this task

You use the Outline view and the Results page to build an OLAP query online.

To dynamically build your OLAP query and see the results after each change:

Procedure

  1. Double-click a cube in your workspace or open an existing OLAP query. The OLAP Query opens in the editor.
  2. Open the Outline view. To open the Outline view, select Window > Show views > Outline.
  3. A single structure tree is displayed in the Outline view or the Layout window. The dimensions and measures that are available in the cube are displayed under a node with the cube's name. The dimensions and measures that have been selected for the OLAP query are displayed under the Layout node.
  4. To select a measure for inclusion in the OLAP query, click the measure in the cube's name node of the tree. With the mouse button pressed, drag the measure to the Measures node of the Layout node. Position the measure in the node in the same location as where you want the value to appear in the query results. Release the mouse button.
  5. To select a dimension for inclusion in the OLAP query as a top or side dimension, click the dimension in the cube's name node of the tree. With the mouse button pressed, drag the dimension to the Top Dimensions or Side Dimensions node of the Layout node. Position the dimension in the node in the same order as you want its values to appear in the query results. Release the mouse button. Only dimensions can be used as top or side groups.
  6. Each time you make a change, you will retrieve data from your cube data source and the query results are displayed in the Results page.