Calculation Differences for ASO
Calculation of aggregate storage (ASO) cubes differs from that of block storage cubes. Aggregations can be predefined as views. Formulas, if used on the outline, are written as MDX numeric value expressions, rather than using Essbase calculation functions.
Table 36-2 Calculation Differences Between Aggregate Storage and Block Storage
Calculation Functionality | Aggregate Storage | Block Storage |
---|---|---|
Cube calculation |
Aggregation of the cube, which can be predefined by defining aggregate views |
Block storage calculation scripts written with Essbase calculation commands and functions Outline consolidation Hybrid mode is encouraged. |
Formulas |
Defined using MDX operators and functions. Note the following restrictions:
|
Defined using Essbase calculation functions |
Calculation scripts |
Aggregation scripts Custom ASO calculations, if the cube needs calculation scripts to handle special calculations and data dependencies |
Stored/procedural calculation scripts defined using Essbase calculator syntax |
Attribute calculations dimension |
Support for Sum |
Support for Sum, Count, Min, Max, and Average |
Calculation order |
Member formula calculation order can be defined by the administrator using the solve order member property |
Defined by the administrator in the outline consolidation order or in a calculation script In hybrid mode, can be customized using the solve order member property |