I have got a $Syn problem in Data Model. It is a Star Schema with Purchasing Order as the fact table and others are the dimension tables.However, there is a $Syn problem due to the fields "Year" and "Month" in Purchasing Order, Training and Expenditure table. Actually, those table do not have linkage besides Year and Month.
I wonder QlikSense is able to generate the Time or Timeline table Automatically or manually. What I can do to solve the problem for better database design?
Thank you very much. Please give me a helping hand.
You have only one synthetic key using the Year and Month fields. I don't think this is a problem. If you wish you can create a calendar table and link all the tables to calendar table. You could use a date field (e.g. makedate(Year,Month) as DateKey) to link the tables.