Multiple Dates in Data Model

[nehasaxena]

Hi All,

I have 2 dates in my data model. One is customer start date and another is transaction date. There are 2 KPIs where I need these dates for calculation.  New customers - Based on Customer Start Date and No of Policies - Based on transaction date.

Now the problem is the top filter section of Year, Month and Quarter. If i will derive the filters from customer date it will give wrong result for No of Policies. How do I join these two dates and create calendar that I can use in filter section.

let me know if you need more info.

Any suggestions would be appreciated.

Best Regards,

Neha

[Anonymous]

This may help you.Master Calender with 4 date fields

You may create a link table.

[swuehl]

Have a look at

Why You sometimes should Load a Master Table several times

Tutorial - Using Common Date Dimensions and Shared Calendars