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: Must be valid numeric value expressions written in MDX; cannot contain the % operator—replace with expression: (value1 / value2) * 100 No support for Essbase calculation functions On dynamic hierarchy members, formulas are allowed without further 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