Skip to Content
0
Aug 04, 2016 at 05:56 PM

Calculation View generating data for years where data doesn't exist

33 Views

I have already created time data which I am using as base for my time dim

Year 2009 2010 2011 2012 2013 2014 2015 2016

Time Dim

I have another table A which has following column

Year Contract NO Amt 2009 1234 400 2012 1234 300 2013 1234 800 2015 1234 100 2016 1234 600 2017 1234 100

Table A

I can do right join and get all the years but I need contract no and amount as 0 where match doesn't exist and I want to get in graphical Calculation View, if it was script then i could have used cursor

Result

Year Contract NO Amt 2009 1234 400 2010 1234 0 2011 1234 0 2012 1234 300 2013 1234 800 2014 1234 0 2015 1234 100 2016 1234 600 2017 1234 100

Please help