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 |