Displaying values in other ways

This dialog tab will let you display the cube values with distinct formats and values. Sometimes you don't care about the actual value, but you want to see it's percentage with respect its total, etc.

You will use the Type listbox to select how you want the data values displayed. It's important to choose the correct Axis in this form. If you choose the vertical axis, then the resulting values will be along the vertical axis, for example, if you choose % Total along the vertical axis and the Customers dimension is in the vertical axis, the for Customers->Total will be a 100% total, for Customers->Americas will be a 40% is sales in America is 40% of the sales total, etc.

Also you can choose to calculate this formula by any one of the cube dimension members. The default value is the measures being displayed in the cube.

The available options are:

  • Values: Shows the cube values as values, nothing is done.
  • % Total: Shows the values as a percentage with respect to their dimension total. If actual value is 10 and it's parent value is 20 and it's dimension total is 100, it will display a 10%.
  • % Parent: Shows the values as a percentage with respect to their dimension member parent. If actual value is 10 and it's parent value is 20 and it's dimension total is 100, it will display a 50%.
  • Ranking: It orders the dimension members according their value and numbers them, so it assigns a one to the best record, a two to the second best and so on.
  • Best: Instead of showing a value, this option shows the dimension member with the best value. Optionally you can choose which dimension level member you can show. For example, product or product group, customer or country. By default the last dimension member is used.
  • Increment: These next formulas are best suited to compare against time periods. This one shows the current value minus the last one. The current value is any cell along a data area axis that is currently being evaluated.
  • Decrement: Shows the current value minus the next one.
  • Difference: Is the absolute value of Increment.
  • YearToDate: Shows each cell with the sum of all it's previous cells in the grid.
  • Rolling sum: Shows the value of the cell plus the last n cells.
  • Rolling average: Shows the average of a cell value together with its last n cells.

This option can be accessed right clicking on a dimension in the data area grid and choosing option cube view. See Cube view menu options for more information.