I have 2 fact table and from 1st fact table we are getting 3 date type field.(e.g: closed date ,open date ,delivery date ) and from fact table 2 we are getting different 2 date type fiels.
We have a master calender.
How can we make a data model with this.
Any leads will be appreciated.
look at this :
You can use interval match function to match the dates and then link it with the calendar.
can you share some sample data to work upon?
Retrieving data ...