Skip to main content
Version: I2023.3.0

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

  1. In the Design Center, display the cube you want to work with.
  2. 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.
  3. 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.
  4. 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.
  5. Select one or more columns to add as a partition by clicking their names.
  6. Keep the Include Higher Levels checkbox selected to include the higher levels of the partition, increasing the usefulness of the partition at little cost.
  7. Click Create Partition. Your new partitions display as a list in the System-Defined Aggregate Partitions panel.
  8. Mouse over and click the four-dots grid beside any partition name to move it up or down the list.
  9. 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.