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.
About this task
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 cube 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.
Procedure
- Open the main cube canvas.
- For fact datasets: Find the fact dataset on the main Cube Designer canvas and click the gear icon to open the Edit a Table Dataset dialog.
- For dimensions: On the main Cube Designer canvas, double-click the title bar of a dimension. On the canvas for that dimension, click the gear icon to open the Edit a Table Dataset dialog.
- Deselect the Allow Aggregates checkbox.
- Click Save.