Calculation Differences

Table 193. Calculation Differences Between Aggregate Storage and Block Storage

Calculation Functionality

Aggregate Storage

Block Storage

Database calculation

Aggregation of the database, which can be predefined by defining aggregate views

Calculation script or outline consolidation

Formulas

Allowed with 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

Support for Essbase calculation functions

Calculation scripts

Not supported

Supported

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 user using the solve order member property

Defined by the user in the outline consolidation order or in a calculation script