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