I have a Budget file coming from Excel. The BUdget File is at a certain level and has Year,Month,Dim1,Dim2,Dollars.
The qvw has a MAster Calendar with Year and Month, has a Dimension Table and a Fact Table.
The LInk between Master Calendar and Dimension Table is
Year&'|'&Month as %DateKey
Link between Dimension Table and Fact Table is Fact_ID
The budget is for the whole year of 2017 but the but the dimension table has Data up to 07/2017.
I linked the Budget Excel file to the Dimesnion table as
Dim1&'|'&Dim2&'|'&Year&'|'&Month as Bud_Key
The Issue is that since the Dimension table has only data up to July the Budget data also shows up to July and rest goes under blank. See Attached OUtput file.
I would like see he Budget populated for All months of 2017 up to Dec
So now my data model looks like the attached file .
