SAP Knowledge Base Article - Public

3465661 - Analytic Model design error - missing attributes of time dimension view

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

  1. Open the Analytic Model in the Data Builder
  2. 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

Product

SAP Datasphere all versions