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 Catalog.