Skip to content
  • There are no suggestions because the search field is empty.

Supported Aggregation Types (Business Rule)

Applies to
Platform: Microsoft SQL Server · Snowflake · Snowflake dbt · Databricks · Databricks dbt · Fabric Lakehouse · Fabric Warehouse · Oracle
Architecture: Stage · Data Vault · Data Mart

This business rule checks that the term mappings of a model object use no aggregation where its type supports none. It raises an error, which blocks generation in the client until you fix it. The rule ID is ID-10011.

Message

The client shows an error with this text on the model object. <model object name> and <type> stand for its name and type.

Model object '<model object name>' of type '<type>' has unsupported
aggregation type for term mappings defined. Supported aggregation types
are: None.

On the model object card, point to the error icon to see this message with the rule ID: Error ID-10011. The Generate Artifacts page lists the message without the ID.

Error popup of a Mart Dimension card with Error ID-10011 and the message details

Cause

A term mapping of the model object has an Aggregation Type other than None. The rule checks Mart Dimension, Mart Hierarchy Flatten and Hierarchy Flatten, and the Stage of a Stage project that loads files on Microsoft SQL Server.

Fix

  1. Open Manage Term Mappings of the model object.
  2. For each term mapping with an aggregation, open Edit Term Mapping and set Aggregation Type to None, see Edit a Term Mapping. The error disappears when no term mapping aggregates.

Check the result

The error icon is gone from the model object, and generation is no longer blocked by it.

Example

In a Data Mart project on Microsoft SQL Server, every mapped term of the Mart Dimension common_loyaltycard_scd1 gets Aggregation Type Max. The client shows:

Model object 'common_loyaltycard_scd1' of type 'Mart Dimension' has
unsupported aggregation type for term mappings defined. Supported
aggregation types are: None.

Related articles