DB2 graphic QMF Version 8

Menu commands

You can use any of the following menu commands to format the OLAP query results.

Copy

Use the Copy option to copy data for a measure or dimension directly to the clipboard.

Font and Format

You can apply extensive formatting options to the OLAP query results. The formatting options are the same as for relational query results and the details are covered in the chapter on Query Results.

Grouping and aggregation

The Grouping and Aggregation options are not available from the Results menu, or from the context menu. Instead, the grouping and aggregation options are defined by the administrator when creating the OLAP cubes using a third-party product.

Drill down

Use the Drill Down option to view detailed data for a dimension and its corresponding measures.

Procedure
  1. Right-click on a rolled-up (summary) dimension in the OLAP query results, or the Layout Designer, or OLAP Query Results Explorer.
  2. Select Drill Down from the context menu.

    Detailed information rather than summary information is revealed for the dimension.

Drill up

Use the Drill up option to view summary data for a dimension and its corresponding measures.

Procedure
  1. Right-click on a dimension on the OLAP query results, or the Layout Designer or the OLAP Query Results Explorer that does not have summary information.
  2. Select Drill up from the submenu.

    Summary information is revealed for the dimension.

Remove from Layout

Use the Remove from Layout option to remove a column from the OLAP query results. The column is removed from the layout but not from accessible query results.

Procedure

To remove a column from the query results layout:

  1. Right-click on a column in the OLAP query results, or the Layout Designer or the OLAP Query Results Explorer.
  2. Select the Remove from Layout option from the submenu.
    Note:
    Notice that the column has been removed from the OLAP query results, the Layout Designer, and the Layout section of the Query Results Explorer.

To return the column to the layout:

  1. Select the column from the Dimensions or Measures branches of the OLAP Query Results Explorer tree.
  2. Drag the selected column to the Layout branch of the OLAP Query Results Explorer tree.

    The column is returned in the OLAP query results, the Layout Designer, and the Measures node of the Layout branch in the OLAP Query Results Explorer tree.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004