Symptom
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.
Environment
SAP Datasphere
Cause
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.
Resolution
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
Keywords
be, business builder , KBA , DS-BB , Business Builder , How To