An Aggregate represents the summarization of measure data at a certain granularity of the dimensions (such as the specific levels and attributes of dimensions of a semantic model). Aggregates are precalculated summaries of data from leaf cells. Aggregates improve query response time by preparing the answers before the questions are asked. They can be created incrementally as users query, and the system learns.

Aggregation strategy

An aggregation strategy for a semantic model includes all the aggregates defined for a semantic model either by accepting system recommendations or defined manually.

Smart aggregation

The system can use query history, data profiles, and test process to identify and recommend an optimal set of aggregates to be built for a given semantic model design.