Symptom
The Analytic Model builder is displayed the following error message(s):
Design errors:
Leveled Hierarchy Attribute "YEAR" of source "Calendar day" is missing
Leveled Hierarchy Attribute missing
Leveled Hierarchy Attribute "CALQUARTER" of source "Calendar day" is missing
Leveled Hierarchy Attribute missing
Leveled Hierarchy Attribute "YEAR" of source "Calendar day" is missing
Leveled Hierarchy Attribute missing
Leveled Hierarchy Attribute "YEAR" of source "Calendar day" is missing
Leveled Hierarchy Attribute missing
Environment
SAP Datasphere
Reproducing the Issue
- Open the Analytic Model in the Data Builder
- Check the Design error(s)
Resolution
Review the time related objects according to SAP Help Portal Documentation: Create Time Data and Dimensions.
If it's already created, please follow the hint:
From v2023.08, we use the ISOWEEK() function to generate ISO-standard year and week numbers (see ISOWEEK Function (Datetime) in the SAP HANA Platform documentation. To regenerate time data generated before this version, click Edit, modify your From Year or To Year, and click Save.
Keywords
KBA , DS-MD-AM , Analytic Model , How To