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