Non-Cumulative Key figures

Posted by on

The non cumulative key figures are used in Inventory management or Banking application where users are interested to know the stock or Account balance information as of date.

For Example

The stock of a particular product on day 1 is 50 EA, on day 2 it is 45 EA and Day 3 it is 35 EA,
This does not signify the stock for last 3 days 130 EA. User will be interested in knowing the stock available on each day and not the cumulative value for all 3 days.



Stock balance = Stock on previous day + Stock Added – Stock Sold.


now we are going to create a non-cumulative key figure Zstock.

 Zstock = Zstock + Zstcka - Zstcks

 Zstock = Stock
Zstcka = New Stock
Zstcks=  Stock Sold




2 new keyfigures added Zstcka and Zstcks

now lets create a Non Cumulative keyfigure Zstock







activate Key figure..

Lets see how our transaction data will look like



create datasource for source file..



create infopackage and pull data....

Then create a cube as target..




















Activate cube










activate transformation









now lets do query on this cube...






















Comments

  1. UnknownJuly 5, 2013 at 3:33 AM

    Hi,
    very nice post. can you also explain the step with Maintaining Non-cumulative key figures as in fig 12 & 13? why and wht do we do there? this would be gr8 and then this post is Complete!

    ReplyDelete
  2. Mohamed AslamJuly 5, 2013 at 3:44 AM

    In order to analyze the non-cumulative values, you need to define for which time interval you want to calculate the non-cumulative

    ReplyDelete
  3. AnonymousNovember 15, 2016 at 10:45 PM

    Helpful document

    ReplyDelete
  4. AnonymousNovember 26, 2016 at 5:08 AM

    Sir what if initial stock is also available then where to add that, so that after inflow and outflow data will be seen in the output accordingly.

    ReplyDelete
  5. UnknownFebruary 5, 2017 at 12:33 PM

    very helpful, nothing can be more detailed that this

    ReplyDelete
  6. sameer hussainMarch 23, 2017 at 8:56 AM

    Non-cumulative key figures are key figures which are calculated based on other key figures and characteristics, so values are not stored but are calculated during query run time. One example is the calculation of stock quantities at a certain period, based on receipt and issue quantities.

    ReplyDelete
  7. AnonymousSeptember 11, 2021 at 8:25 AM

    one of the best explanation on this topic.

    ReplyDelete

Post a Comment