Skip to Content
avatar image
Former Member

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 !


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 30, 2012 at 05:56 AM

    Hi Romil,

    Hope you have taken care of Validity table of your non cumulative cube. (RSDV)

    Calculation wont happen as expected if this is not maintained.


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2012 at 06:27 AM

    Hi Romil,

    have a look in the following link where the concept of Non-cumulative is explained via flat files.

    Best Regards

    Manna Das

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Preethi,

      Thanks you once again for the reply and sharing the knowledge.

      I studied the doc and it was very helpful. I extend the validity of plant P2 and Material M2 by going to RSDV by 365 days and now, everything is working perfectly fine.

      I am closing the thread as my question has been answered.

      Thank you once again..


      Romil Vaghela