Working with non-cumulative key figures in cube with flat file datasource
I am trying to work on requirement similar to the Inventory application.
I am using non-cumulative key figure 0totalstck(Quantity total stock), 0rectostck(Rec quan total stock) and 0isstostock(Issue_qu total stock) in my cube. These KFs have been used in the Inventory cube 0ic_c03 too.
0totalstck is non-cumulative KF which is calculated from 0rectostck and 0isstostock.
I have made following two generic datasource based on flat file to load to a cube.
1. DS1 : To Initialise the stock which works perfectly well when loaded to cube.
2. DS2 : To load daily data to the cube which gives 0rectostck and 0isstostock.
e.g. if the stock is initialised with 0totalstck = 10 as on 01.01.2010. After that, I have compressed with 'no tick' on 'no marker update'.
now, if I load with date = 02.02.2010, 0isstostock= 5 & 0rectostck = 20.
then, its giving the 0totalstck = 15 on 02.02.2010 which should actually be 25(20-5+10) as the stock on 01.01.2010 was 10.
its simply giving 20-5 = 15 value on 02.02.2010 which is wrong as per non-cumulative KF calculation.
Thanks in advance !