SAP Knowledge Base Article - Public

3487972 - Custom Month property refused in a DATA() statement of a Data Action - SAC

Symptom

Error message in SAC when using a custom month property : "Values defined in the property "CUSTOM_MONTH" cannot be assigned to the "Date" dimension as they have different time granularity from "CALMONTH" of "Date" dimension. Please use "CALMONTH" property."

Environment

SAP Analytics Cloud 2024.8.16

Resolution

The recommended way is to use the Time Calculation Function such as : 

DATA([d/Date]=PERIOD([d/DIMENSION].[p/CUSTOM_MONTH]))=RESULTLOOKUP()

Keywords

KBA , LOD-ANA-PL-DA , Data Actions , How To

Product

SAP Analytics Cloud 1.0