Skip to content

OLAP Tool Bar

The tool bar on the left side of your view provides access to many OLAP operations and features.

ja toolbar

Figure 1 OLAP Tool Bar

OLAP Tool Bar Icons

Icon

Name

Description

ja toolbar zoombutton

Zoom on Drill

Toggles (that is, turns on or off) the zoom in/out hyperlinks for hierarchy members. See Drilling into a Dimension Member.

ja toolbar sortacrossbutton

Sort Across Hierarchy

Toggles between sort of and sort within hierarchy. See "Sort Options".

ja toolbar hideemptyrows

Hide Empty Rows/Columns

Hides or reveals rows or columns that do not have relevant fact data. See Row and Column Display Options.

ja toolbar swapbutton

Swap Axes

Changes the orientation of the table by switching the columns and rows.

ja toolbar swap

ja toolbar editdisplayoptionsbutton

Edit Display Options

Allows users to configure the cube options, drill-through options, and sort options. See "Editing Display Options".

ja toolbar showchartbutton

Show Chart

Displays a chart of the navigation table data.

ja toolbar showchart

ja toolbar editchartoptionsbutton

Edit Chart Options

Defines various charting options.

ja toolbar chartoptions

ja toolbar changedatacube

Change Data Cube

Changes an OLAP view and defines dimension filters.

ja toolbar showmdxbutton

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.

ja toolbar mdxeditor

ja toolbar exporttoexcelbutton

Export to Excel

Prompts you to view or save the current navigation table in Microsoft Excel format.

ja toolbar exporttoexcel

ja toolbar printtopdfbutton

Export to PDF

Prompts you to view or save the current navigation table in Adobe Acrobat PDF format.

ja toolbar printtopdf

ja toolbar editoutputbutton

Edit Output Options

Defines various output options.

ja toolbar outputoptions

ja toolbar saveviewbutton

Save View

Saves this OLAP view. Changes you have made since you opened the view are saved to the repository. If you do not have permission to save the view in its current location, the Save View As dialog prompts you to select a new location.

ja toolbar saveviewasbutton

Save View As

Saves this OLAP view under a new name and location. Changes you have 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).