Dimensionally modified aggregates

Some of the queries processed by AtScale request calculated measures as well as calculation groups. The runtime performance of such queries can be significantly improved by enabling and configuring Dimensionally Modified Aggregates (DMA). This allows you to:

Reduce outbound query complexity.
Improve aggregate hit-rate for dimensionally modified queries like "ParallelPeriod", "Lag", and "Moving Windows".

Configuring DMAs

DMAs are enabled by default. They can be further configured using the aggregates.dimensionalModifications.retentionLimit engine setting, which controls the number of active instances of DMAs retained per model.

Enabling DMAs for individual models

You can enable DMA creation for dimension levels and secondary attributes using the Dimensionally Modified Aggregates field when adding/editing them. For more information, see Edit a Level and Edit a Secondary Dimensional Attribute.