Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Working with non-cumulative key figures in cube with flat file datasource

Hi Experts,

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.

Please help.

Thanks in advance !

Romil.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question