Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Data model i Have Attached image for Reference i have one Master Table which is Item spykar and Two Fact Table one is Opening and Another is Financial_Data and I want to Add master Calender please Take A llok and Give surregsion if i Link Master Calender with financial Data data count is Matching and Numbers if i Link with Opening Table which is Another Fact Table Number are Not Matching , request to built Proper Data model in this Case,
Thanks in Advance
One solution could be to concatenate the data from Financial_Data into Opening and to rename in the same statement DATEField to DATE. So both facts will share the same date field.