How to create a new date dimension using Semantic Model Extension?

Question

In FDI out of the box, a few date dimensions are supported. For example, in CX - Sales (using Salesforce source) in the subject area "SF - Campaign Members", FDI supports proper date dimensions against 4 dates — SF Campaign Created Date, SF Campaign Start Date, SF Campaign End Date and SF Lead Created Date.

We need one more that is based on the Campaign Member Created Date.

What is the best way to achieve this using the Semantic Model Extension tool?

Shyam Patel · Answer

FDI vs BI Subject Area.xlsx

Hi Sushanta,

There are significantly fewer Subject Area FDI supports than in the BIP Subject Area. The FDI team gave our business a trial version. There is still a long way to go.

FDI - 66 Subject Area  --- No Planning, Services, Maintenance Track Subject Area.

Cloud has 587