Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please guide me how to handle multiple Fact date in Common Calender. In the transaction database the fields are ,
OrderID,SalesPersonID,CustomerID,OrderDate,ShipDate,ShipMode,Product.OrderQuantity,UnitPrice,ShippingCost
Anyone have any solution, then please share...
Try to implement link table in your project is better approach.
Good Luck
Vikas
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