DB2 graphic QMF Version 8

Create new OLAP queries using the OLAP Query Wizard

For database servers that support DB2 Cube Views, you request information from the server using an OLAP query. OLAP queries are multidimensional queries that can present your data in a wide variety of views. You use the OLAP Query Wizard to help you build an OLAP query. The OLAP Query Wizard has the following steps:

Open the OLAP query Wizard

Select Query--> OLAP Query to Open the OLAP Query Wizard.

Select a server

Use the OLAP Query Wizard Select a Server dialog to select the database server where the cubes that will used in the OLAP query reside.

  1. Select a server from the list.
  2. Click Next.

    The OLAP Query Wizard Sort Cube List by dialog opens.

Sort Cube List by

Cubes are stored on the database server by schema and by model. You can choose how those cubes are presented to you for selection in the next step of the OLAP Query Wizard.

  1. Select the sorting method to use.

    Select the Schema radio button to sort cubes by schema, which is the cube name or the owner of the object.

    Select the Model radio button to sort cubes by model.

  2. Click Next.

    The OLAP Query Wizard Select a Cube dialog opens.

Select a Cube

The cubes that reside on the database server are presented in a tree structure based on the sort criteria you specified in the previous step. Use the OLAP Query Wizard Select a cube dialog to select the cube to use for the OLAP query.

  1. Select the cube to use.

    If you sorted by Schema on the OLAP Query Wizard: Cube List Filters dialog box, the cube is shown in server, name, then cube order.

    If you sorted by Model on the OLAP Query Wizard: Cube List Filters dialog box, the cube is shown in server, model, then cube order.

  2. Click Finish.

    The OLAP query is run on the database server. The results are returned in the active window.


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