Data Model

[balaraman31]

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  

[vincent_ardiet_]

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.