Disabling the Creation of System-Defined Aggregates for a Dataset
For some fact datasets, you might want to disable the creation of system-defined aggregates entirely.
By default, the AtScale engine can create aggregates for every fact dataset and dimension. Disabling the creation of system-defined aggregates on a dataset means that AtScale will not define aggregates for any measures, dimensions, or attributes that are defined on the data of that dataset. You can still manually add user-defined aggregates, if necessary.
You might want to disable the creation of system-defined aggregates on a fact dataset in the following scenarios:
- The model is a multi-fact model, and one fact dataset is too large to aggregate or join to without specifying some constraints.
- The fact dataset is based on a view that executes complicated joins and ETL logic.
You can disable the creation of system-defined aggregates for datasets
using the allow_aggregates
SML property. For more information, see
the AtScale SML Object Documentation on GitHub.