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.

You can access these settings when creating and editing levels and secondary dimensional attributes. For more information, see Edit a Level and Edit a Secondary Dimensional Attribute.