Working With Aggregate Partitions
You can add, rearrange, and delete system-defined aggregate partitions in the AtScale Design Center. Be sure to publish your aggregate changes.
Procedure
- In the Design Center, display the cube you want to work with.
- In the right-hand tool panel, click the System-Defined Aggregate Partitions icon, which resembles a percent sign. The System-Defined Aggregate Partitions panel opens.
- In the System-Defined Aggregate Partitions panel, click the menu icon on the right and select Create Key Partition or Create Name Partition to add a partition. The dialog to create a partition opens.
- In the dialog, click a folder name for a dimension's attributes to display and select the columns, or use Expand All and Collapse All to work with columns.
- Select one or more columns to add as a partition by clicking their names.
- Keep the Include Higher Levels checkbox selected to include the higher levels of the partition, increasing the usefulness of the partition at little cost.
- Click Create Partition. Your new partitions display as a list in the System-Defined Aggregate Partitions panel.
- Mouse over and click the four-dots grid beside any partition name to move it up or down the list.
- Click the ellipsis menu icon to the right of a partition name to remove it. You are prompted to confirm the deletion.
What to do next
Once a query containing the dimension levels that you've specified as a partition has been executed on the published cube, the AtScale engine determines whether to build a new system aggregate with the partition, based on the following:
- If the estimated number of rows per partition meets or exceeds the
threshold set in the engine setting
AGGREGATES.CREATE.PARTITION.SYSTEMDEFINEDAGGREGATE.THRESHOLD.
- If the estimated number of partitions in the aggregate table exceeds
the threshold set in
tables.create.partitions.maximumEstimatedNumberOfPartitions
the table will not be partitioned. The default value of this setting is 800.
Navigate to Aggregates > Definitions for the data warehouse to see whether the system aggregate was created as a result of your query.