When you create a calculation in a cube view, the data is generated on-the-fly and not stored in the database. When you run the cube view, the calculation returns a value.
You can use calculations in a cube view to calculate:
-
Variances
-
Sums
-
Differences
-
Ratios
Calculations are useful for variance reporting, What If scenarios in cube views, and KPI calculations.
