Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I'm facing the following problem.
I have two fact tables with two important dates which I need to combine into one master calendar. As link these fact tables I have a compound key with dimensions A+B and stored the shared dimensions into a Link Table.
Now is the question whats the best way how to develop one master calendar that can be used to analyse records from fact table A and fact table B.
Best regards,
Robert
Say for Ex : if u have OrderDate and SalesDate
Generate the mastercalendar like this
Start Date in MasterCalendar -minimum(StartDate_OrderDate,StartDate_SalesDate)
End Date in MasterCalendar -Maximum(EndDate_OrderDate,EndDate_SalesDate)
If the dates are really different (Eg. Stat and End Date) then you need 2 master calendar to manage them, otherways if dates from 2 or more tables represent an omogeneous information one calendar is enough.
If you look in the community you will find lots of calendar that starts from the min(date) up to the max date and implement values like month, year, week and so on