Skip to main content
Version: I2023.2.0

Excluding Specific Attributes from Aggregates

As of AtScale version 2020.2.0, there are new settings that allow the user to manually exclude specific attributes from being used as grouping keys in aggregations. These settings can be applied to both level attributes and secondary dimensional attributes.

Settings

Exclude from System-Generated Dimension-Only Aggregates
This setting prevents the attribute from being used as a group-by column in a system-generated dimension-only aggregate. This is useful if the attribute contains a large number (e.g. millions) of distinct values, such that aggregation based on this attribute will be ineffective.

Exclude from System-Generated Fact-Based Aggregates
The AtScale engine excludes this attribute from being used as a group-by column in system-generated fact-based aggregates. Setting this option may be appropriate if the attribute contains a large number (e.g. millions) of distinct values, such that aggregation based on this attribute will be ineffective.

Figure 1. The Exclude from System-Generated Dimension-Only Aggregates setting on the Create a Level Dialog.

image

Figure 2. The Exclude from System-Generated Fact-Based Aggregates setting on the Create a Secondary Attribute Dialog.

image