Reg: Cumulative key figures and non cumulative key fig

[former_member185071]

Hi BW Expertz

Could any one give me the clarification about cumulative and non cumulative key figures .Why we go for cumulative key figure and non cumulative key figure.If any docs could u just mail to the following sapbwsource@gmail.com

Thanx In advance

Best regards

Krish. K

[former_member619464 · Accepted solution]

Hi Krish,

Cumulative values are those key figures that are cumulated using all characteristics, thus also using time.

Example: sales revenue, weight, etc.

Non-cumulative valuesare those key figures that are measured in relation to a period in time; that is to say they cannot be meaningfully cumulated over time. Non-cumulative values are summarized over time using so-called exception aggregation.

Example:stock quantities/-values, number of employees, account balances, etc.

Hope it helps...let me know

Regards,

RV.

[former_member185071]

HI SAchin Sach dev

Thanx For u r replay Please dont give the entire help link about SAP BW Could just make sure abt the link what exactly it shows.

Thanx N Regards

Krish .K

[Former Member]

hi krish,

You can go through these links...

http://help.sap.com/saphelp_nw04/helpdata/en/80/1a62ebe07211d2acb80000e829fbfe/frameset.htm

Hope it helps..

[edwin_harpino]

dear Krish,

check this

http://help.sap.com/saphelp_bw33/helpdata/en/80/1a62dee07211d2acb80000e829fbfe/frameset.htm

http://help.sap.com/saphelp_bw33/helpdata/en/80/1a62dee07211d2acb80000e829fbfe/frameset.htm

and docs

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/93ed1695-0501-0010-b7a9-d4c...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/d61b1e95-0501-0010-dfbe-a03...

hope this helps.

[Former Member]

hi krish

A non-cumulative is a non-aggregating key figure on the level of one or more objects that is always displayed in relation to time. Examples of non-cumulatives include headcount, account balance and material inventory. here the aggregation of key figure is based on the another info object

There are two different ways to define non-cumulative key figures:

• Non-cumulative key figure with non-cumulative changes:

Before you can define the non-cumulative key figure, an additional cumulative key figure containing the non-cumulative change must exist as an InfoObject.

• Non-cumulative key figure with inflows and outflows

There has to be two additional cumulative key figures as InfoObjects for non-cumulative key figures - one for inflows and one for outflows. The cumulative key figures have to have the same technical properties as the non-cumulative key figure, and the aggregation and exception aggregation have to be SUM.

Features of non-cummulative key figures

A non-aggregating key Figure.

Records are not summarized for Reporting

Exception Aggregation is being applied on these key figures on the level of one or more info objects usually with time .

Examples: Head Count, Account balance, Material stock

consider simple senario

Date Net Stock Quantity Sales Revenue

01.02.2005 40 1000

02.02.2005 50 2000

03.02.2005 25 3000

this is the query output if stock quantity has treated as cummulative and non-cummulative key figures

if stock quantity taken as a cummulative key figure

Date NET STOCK QUANTITY SALES REVENUE

01.02.2005 30 1000

02.02.2005 50 2000

03.02.2005 20 3000

RESULT 100 6000

in the above result the key figure has aggregated to the total value that wont give sense to the net stock quantity

if stock quantity taken as non-cummulative key figure

Date Net Stock Quantity (LAST) Sales Revenue

01.02.2005 30 1000

02.02.2005 50 2000

03.02.2005 20 3000

RESULT 20 6000

here the stock quantity has been aggregated based on the last date and hence the 20 is the net stock quanity. that adds sense to the key figure

i hope u better understood with this example

Also sent an how to doc to ur mail i.d

confirm the same

<b>Awarding with points is the way of saying thanks in sdn</b>

cheers

ravi

[former_member185071]

Hi Ravi Kiran

I am heartfully than ful to you It gives a very clear explanantion about this particular topics.

Thanx N Regards

Krish K

Bangalore

[Former Member]

hi krish,

thanks for the compliments

u can close the thread if u got ur answer

cheers

ravi

[former_member185071]

Hi Ravi

How can I close The thread.

cheers

Krish K

Bangalore

[Former Member]

Hi Krish,

Please refer to the following link.

http://help.sap.com/saphelp_bw320/helpdata/en/ad/6b023b6069d22ee10000000a11402f/frameset.htm

Let me know if that helps you.

Regads

Sachin