I am working on a QV app to create a data model. I try wherever possible to work towards a Star model. So I created a facttable called 'Transactions' (Sales Lines, Purchase Lines). The original sales lines contain 2 date fields and the original purchase lines 4. Through a Link Table I want to place alle the date fields into the LinkTable so I can then created a MasterCalender out of the LinkTable. I only got $ Syn keys because all the fields are from the same table wich I created through the concatenate action.
I'm totally stuck with this problem
How do I fix this?
As an attachment I attached an example QVW and the 2 QVD's wich contains the data.
My understaning of Master Calender is connect the rest of the dates from different tables to MC using alias right. For instance I have multiple dates from various tables and when i was trying to connect to MC, end up with synthic keys.
I have modified your MC script, have look at it and see where am i making mistake. Other words please let me know what is the best way to handle this situeation.
My question isnot howIshouldmakea calendarbutmoreofhow can I create a Master Calendar of multiple datesfrom the same(concatenatedtransaction)? I think that I have to create a linkedtable.I would like toknow ifthe linkedtablethat I madein the example is theright way to create a linkedtable by usingmultiple datefieldsof the same tableandthen usesthe linkedtableto createa MasterCalendar.