SAP Knowledge Base Article - Public

3384171 - Calculated Attribute is non-selectable when creating Consumption Model based on Fact Business Entity


Calculated Attribute is not available for selection when creating a Consumption Model based on Fact Business Entity.
However the calculated attribute is selectable if CM is created from a Data Preview of Business Entity Fact. 


SAP Datasphere


System working as designed.

When creating a Consumption Model based on the Data Preview the following logic applies:
The definition of the calculated attributes is copied to a new calculated attribute in the Consumption Model.
This means that there is no connection between the attribute in the Fact and the attribute in the Consumption Model and changes that are done in the Fact are not applied automatically. 

For the same technical restrictions it is also not supported to use a calculated attribute in an association - e.g. changes to the calculation would lead to unpredictable side-effects and would make it hard to find the root-cause of potential issues.


For technical reasons SAP Datasphere does not support the usage of calculated attributes as Fact Source Attributes in a Consumption Model.
There are different ways to get the calculated attributes available in the Consumption Model:

  • The recommended solution is to use Dimensions to maintain attributes whenever it is possible.
    For Dimension Source Attributes Business Builder supports calculated attributes - means it is possible to take them over to the Consumption Model.
  • If it is not possible to create a Dimension to handle the attributes, use a self-reference approach.

In both cases (dimension and self-reference) ensure unique keys are used for the associations.

See Also

Creating a Consumption Model

Modeling Data in the Business Builder


be, business builder , KBA , DS-BB , Business Builder , How To


SAP Datasphere all versions