Export the grid to Excel, HTML, XML as required
 

Turn hints for buttons and columns on and off

Hide rows that contain all zeros

Hide columns that contain all zeros

Row Sort type - sort by axis value, sort by measure totals, sort by focused columns
 

Column Sort type - sort by axis value, sort by measure totals, sort by focused rows
 

Edit measures, this screen allows the aggregation to be changed, for example, changing our GP, which is currently a sum to an average. It also gives access to the script tool, that allows for values to be created based on existing measures and dimensions.
 

The data marker allows the currently focused measure to change its colour based on a given value range, which is ideal for highlighting values. In the example below, we can change the colour of the revenue measure based on a given range, 0.00 - 3,000 red, 3001.00 to 8,000, then orange and 8,000 and over the green. This gives the ability to spot values and problems quickly with a large amount of data.
 

 

This allows the formatting of the selected measure to be changed, allowing the configuration of date, number format etc.

Displays a list of fields, filters and measures and allows the ability to select fields and them to the required area

Gives basic statistic information
 

CRM Security information for the OLAP form, allowing security policies to be applied
 

Open a previously saved cube - a cube contains the data the last time the cube was saved and the layout. It allows the cube to be supplied to colleagues without them having to re-run queries or have access to the original data.

Save the cube to a cube data file. The file can be supplied to a colleague for them to access the data and layout that was created with this file

Clear the grid and start over

Open a previously saved layout. This will open a scheme / layout and apply against the currently active data. The scheme needs to be based on the data being used

Save a layout for later use and apply against the same data source. This allows the creation of a layout and then use it in the future.

This will generate a simple cross tab style report based on the active OLAP desktop

This will generate a report based on the active OLAP desktop, using a report format that can be adjusted as required