Cube options

With this dialog, is possible to set several options that affect the cube view as a whole and not a particular dimension.

The dialog is divided in 4 distinct sections, choose the section you would like to obtain more information:

Pareto: Pareto options to be applied to the data. For example, you want to look at only 80% of total sales.
Order: Order in which data will show in the cube.
Values: Lets you apply several formulas like % of total, ranking, etc. to view the cube data differently.
Filter: Lets you choose which values the cell must have to appear in the cube view.

Also you can choose to Rotate this options with the cube, since this options affect the cube view, rotating the cube won't modify the options unless this checkbox is set. Save as default saves on the windows registry the options that were set, so next time is executed, these options are used.

It's possible to apply these options on both cube axis. This let you order first by one axis and then by the other axis. The same occurs with filter and pareto options. Change the axis, to see options of each axis.