Select measures

Each Exploration View based on DMR or OLAP packages must contain at least one measure. Only one measure can be dragged to the measure drop zone. If you select more than one measure by placing a measure in a row or column, the measure that is in the measure drop zone becomes the default measure.

Tip: To drag more than one measure to a row or column, you can use Shift+click or Ctrl+click.

Sometimes, when you add measures to columns or rows, you may notice that other items get re-ordered. This is a query framework behavior. Unlike an OLAP data source, DMR data is not returned in a specified order. If a specified order is required, you must edit the specifications in Framework Manager.

Procedure

  1. In the source tree, select and drag a measure to the Measure drop zone.

    Unlike the Rows or Columns drop zone, the Measure drop zone is available only on the grid and not in the header area. The selected measure appears.

  2. Save your workbook.

Results

After you save your workbook, you can publish it to IBM® Cognos® Connection.