Dynamic
Dynamic dimensions offer the most design flexibility, but at the cost of limiting calculation and reporting performance.
Dynamic Dimensions Support
-
Any consolidation operator (+, -, *, /, ~)
-
Member formula
-
Shared members
-
Attributes and UDAs
Dynamic Dimensions Limitations
-
Slowest aggregation
This has an impact on both calculation and reporting performance. Using multiple dynamic dimensions in an application compounds this problem.
-
Shared members must appear after the base member of the share