DB2 graphic QMF Version 8

OLAP Query Results Explorer

The OLAP Query Results Explorer opens in the Explorer window when the results of the OLAP query are returned. The OLAP Query Results Explorer displays the OLAP query results in a tree structure.

You can use the OLAP Query Results Explorer to move around, discover and easily modify the structure of the OLAP query results. You can select columns to summarize, group like information, and change the order of result columns dynamically in the active window.

The OLAP query re-runs each time you make changes to the query results using the OLAP Query Results Explorer.

Navigating the Query Results Explorer tree

The Query Results tree has the following branches:

Cube

The name of this branch is name of the cube that was selected for the OLAP query. It list the dimensions and measures that were used in the OLAP query. As you make changes to the query results in the active window, this branch remains unchanged. It serves as the source.

Layout

This branch lists the columns as they currently appear in the active window. As you make changes to the OLAP query results in the active window, the changes are reflected in this branch of the tree. There are three nodes in the Layout branch:

Working with the OLAP Query Results Explorer

There are two ways of working in the OLAP Query Results Explorer:

You can right-click on any measure listed in Layout branch to open a context menu. From the context menu you can:

Many of the commands that are available from the context menu are also available from the Results menu in the main menu bar or from the context menu that opens when you right click in the open space of the query results. Each command is discussed in detail later in this chapter.

Drag and Drop

From the OLAP Query Results Explorer tree you have the following drag and drop capabilities:

Layout Designer

Another tool that is available to change the OLAP query results in the active window is the Layout Designer. The OLAP Query Results Explorer and the Layout Designer work together. Any changes made with one are dynamically incorporated by the other.


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