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.
The Query Results tree has the following branches:
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.
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:
Lists the dimensions that you have selected to be summarized along the top of the query results.
Lists the dimensions that you have selected to be summarized along the left side of the query results.
Dynamically lists and relists the query results measures as they appear after each move that you make using the Query Results Explorer or the Layout Designer.
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.
From the OLAP Query Results Explorer tree you have the following drag and drop capabilities:
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.