How to join FactTable's multiple Date columns with dCalendar table??

[BeepBeep]

Hi,

I have multiple date columns in the FactSales i.e. OrderDate, DeliveryDate, ShipDate etc.

Also, I have dCalendar table. Can I give a relationship between all of Date columns of FactSales to dCalendar table's Date column.

Because I already joined, It has taken without an error. But I have second thought on this.

Will that have any negative effect anywhere, anytime??

Thanks
BeepBeep

 

[Matt Allington]

You have 2 choices. You can either bring in 1 calendar table for each date column of your data table, or you can make multiple connections but only 1 will be active. If the latter, you have to "call" the inactive relationships if you want to use them by using USERELATIONSHIP inside of CALCULATE.

There re are no negatives, just differences.