Linking Calendar Hierarchy and Fiscal Hierarchy Date Dimensions Using Advanced Formulas

[pooja_elangovan01]

Hello SAP Community,

I need assistance with linking two models in SAP Analytics Cloud (SAC) using advanced formulas. I am encountering an error stating "Date is using a calendar hierarchy instead of a fiscal year." Here are the details of my situation:

1. Models:

   • Finance Model[Default Model]: Uses a calendar hierarchy with year, quarter, and month.
   • OPEX Model: Uses a fiscal hierarchy with fiscal year, quarter, and period.

Date([d/Measures] = "SUM" = LINK [OPEX], [d/Measures] = "SUM", [d/Date] = [d/Date])

I need guidance on the correct approach and syntax to link these two date dimensions.

Thanks,

Pooja.

[N1kh1l]

@pooja_elangovan01 

The LINK function might not work if the date dimension in both model are of different hierarchy types. If its a user defined date dimension then in Fiscal date dimension, you can try maintaining an attribute with fiscal to calendar mapping. So maintain the calendar months against the calendar periods. Then try setting up the LINK as below

Date([d/Measures] = "SUM" = LINK [OPEX], [d/Measures] = "SUM", [d/Date] = [d/Date].[p/calendarperiod])

calendarperiod is the attribute. 

Hopefully this may work.

Nikhil