Hi All
below shows the data tables i have used in my dash boards ( See Image No1 ). it has four date types to be considered. and i need one master calendar to link all four dates. i have already been through the posts on using Cannonical date. but my concern is, in this practical scenario i have no prime key to link all four tables.
keys are as follows.
1. Key1 to Budget and Forecast Tables - Company, Buyer
2. Key2 to Forecast and Confirmed Tables - Company, Buyer, ShopNo, RelNo, SeqNo
3. Key3 to Confirmed and Actual Tables - Company, Buyer, OrderNo, LineNo, DelNo
what i need to get as the final out put is shown in the Image No 2. in yellow color i highlighted a data set linked as per the above keys.
and please find attached a sample data set herewith. could someone pls help to solve this matter. thanking in advance.
Image No 1.
Image No 2.
Thank you