The tool bar on left side of your view provides access to many OLAP operations and features.
Toggles (that is, turns on or off) the zoom in/out hyperlinks for hierarchy members. See Drilling into a Dimension Member|
|
|
OLAP Tool Bar |
|
Icon |
Name |
Description |
|
|
Zoom on Drill |
. |
|
|
Sort Across Hierarchy |
Toggles between sort across and sort within hierarchy. See Sort Options. |
|
|
Hide Empty Rows/Columns |
Hides or reveals rows or columns that do not have relevant fact data. See Row and Column Display Options. |
|
|
Swap Axes |
Changes the orientation of the table by switching the columns and rows.
|
|
|
Edit Display Options |
Allows users to configure the cube options, drill-through options, and sort options. Edit Display Options. |
|
|
Show Chart |
Displays a chart of the navigation table data.
|
|
|
Edit Chart Options |
Defines various charting options.
|
|
|
Change Data Cube |
|
|
|
Show MDX Query |
Changes the navigation table by editing the MDX query that generates the view. This feature is intended for advanced users familiar with MDX and the data structures underlying the view.
|
|
|
Export to Excel |
Prompts you to view or save the current navigation table in Microsoft Excel format.
|
|
|
Export to PDF |
Prompts you to view or save the current navigation table in Adobe Acrobat PDF format.
|
|
|
Edit Output Options |
Defines various output options.
|
|
|
Saves this OLAP view. Changes you’ve made since you opened the view are saved to the repository. If you don’t have permission to save the view in its current location, the Save View As dialog prompts you to select a new location. |
|
|
|
Save View As |
Saves this OLAP view under a new name and location. Changes you’ve made since opening the view are saved to the repository in the location you select. Note that you cannot use the Save View As button to overwrite an existing view (even if you have sufficient permissions). |
