Data linking issue

[sourabhsharma]

I have one sales fact that contain invoice date with some missing dates,I made one master calendar based on stardate of invoive to end date of invoice,My sales fact is also linked to budget through the concat(customerid,year,month) now when i am tring to link the year from master calendar to the budget year from budget table its giving me inappropriate results.

[Lisa_P · Accepted solution]

In your calendar script you are populating your varMinDate based on Date field in SALESDETAILS.

This field does not exist, it should be DateKey based on your data.