Stored

In general, stored dimensions offer the best performance for both calculation and reporting.

Stored Dimensions Support

  • Fastest aggregation

  • Shared members

  • Attributes and UDAs

Limitations

  • Members may only use the Addition (+) consolidation operator

  • No member formulas

  • Shared members must appear after the base member of the share