Please guide me how to handle multiple Fact date in Common Calender. In the transaction database the fields are ,
Anyone have any solution, then please share...
Try to implement link table in your project is better approach.
See this blog post: Why You sometimes should Load a Master Table several times
And this discussion: Tutorial - Using Common Date Dimensions and Shared Calendars
Retrieving data ...