Symptom
- Dashboards that previously worked have stopped functioning.
- Filtering on ranges from a date dimension in the analytic model is not possible.
- The date dimension is now seen as a text, while previously it was seen as a date.
Environment
- SAP Datasphere
Reproducing the Issue
- In SAP Datasphere, navigate to the Analytic Model.
- Apply a range filter on the date dimension.
- Notice that the date dimension is treated as text and range filtering is not available.
Cause
A change in the analytic model's semantic type mapping caused the date dimension to be treated as text instead of a date type.
Resolution
- The behavior observed is expected and working as designed. In previous releases, semantic types were incorrectly mapped and caused complications; this has been corrected in the last release.
- Change the date dimension mapping from string(10) to the appropriate date semantic type.
- Verify that date dimension range filtering works as expected.
See Also
2891554 - How to create a Support User in SAP Datasphere.
Keywords
SAP Datasphere, Analytic Model, Date Dimension, Filter, Range, Text, String, Semantic Types, Mapping. , KBA , DS-MD-AM , Analytic Model , Problem
Product
SAP Datasphere all versions
SAP Knowledge Base Article - Public