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:
Select Query--> OLAP Query to Open the OLAP Query Wizard.
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.
The OLAP Query Wizard Sort Cube List by dialog opens.
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.
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.
The OLAP Query Wizard Select a Cube dialog opens.
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.
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.
The OLAP query is run on the database server. The results are returned in the active window.