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.

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
- Open Manage Term Mappings of the model object.
- 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
- Reference: Aggregation Type (Term Mapping)
- See also: Edit a Term Mapping, Dataflow Sets Aggregation Amount (Business Rule), Aggregation with multi-version load (Business Rule), Understand warnings and errors