Pareto options menu options

When you right click on a dimension cell and choose option: pareto options, it will let you change the records that will be shown:

It's important that if you click on a vertical dimension, dimension members in the horizontal dimension will be cut to the pareto function chosen. Also the values used to calculate these functions is the one that was clicked on, so a different result will be made according to the field clicked. These menu options will always get the records with greater value.

  • All records : No pareto function is applied.
  • Top count : Brings a specified number of records.
  • Top sum: Brings all records until their sum of values are above a specified threshold.
  • Top %: Brings all record until their sum is a specified percentage of the total.

The last option accessed from this menu gets checked.

These options are a shortcut of the Pareto Tab in the Cube options dialog.