Retrieve Dimensions | Refreshes the dimension values in the Catalog pane. | F9 | |
Add Side Label | Adds the selected item to the Side Labels pane. | | |
Add Top Label | Adds the selected item to the Top Labels pane. | | |
Add Fact/Measure | Adds the selected item to the Measures pane. | | * |
Add Computed Item | Opens the Computed Items dialog box. (This feature is for MS OLAP only) | | * |
Drill Down | Allows you to progressively narrow your focus on a selected item. | | * |
Drill Up | Returns the original view of data. | | * |
Drill Through | Drills through from a multi-dimensional database to a relational database. | | |
Remove Total | Removes local totals from selected dimensions. | Del | * |
Hide Items | Removes selected items from the OLAPQuery report. | | * |
Show Hidden Items | Retrieves hidden items from the selected row or column to the OLAPQuery report. | | * |
Show All Items | Retrieves all hidden items to the OLAPQuery report. | | * |
Download To Results | Downloads the OLAPQuery data set to an OLAPResults section for offline work. | | |
Show As Chart | Charts the OLAPQuery data set; automatically creates OLAPChart and OLAPResults sections. | | |
OLAP Query Options | Accesses the OLAPQuery Options dialog box, where you can set options for your OLAPQuery. | | |
Data Functions | Recalculates the surface values in the OLAPQuery data set. | | * |
Set Drill-Through | Accesses the Set Drill-Through dialog box, where you can define the options for drilling through from a multi-dimensional database to a relational database. | | |