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" inPurchasing 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.