Query on cube 0IC_C03 with Non cumulative & cumulative keyfigure together

[Former Member]

Hi

My problem goes like this

Im writing a query on cube 0IC_C03:Material Stocks/Movements (as of 3.0B) with both non cumulated keyfigure (0VALSTCKVAL)& Cumulative keyfigure(0RECVS_VAL) together with characteristics being Plant,calender month & material. All records are shown properly with values if I select for a Plant. But if a I make selection on Material, query returns a row with value for cumulative key figure only. Non cumulative keyfigure doesn't show up.

Any reason for this behaviour?

Thanks & Regards

Padmanabh

[Former Member · Accepted solution]

Padmanabha

Check the aggregation & cumulative properties of Non-cumulative key figure 0VALSTCKVAL. For this key figure inflow is defined as 0RECVS_VAL(cumulative ) & outflow is defined as 0ISSVS_VAL .

When you drilldown on Material , maybe this propery is imapacting the display of no-cumulative key figure.

Hope this helps

Regards

Pradip

[Former Member]

Hi Rao ,

0VALSTCKVAL is a non cumulative key figure with exeception aggregation as 'Last Value'. Go to the change mode of the cube 0IC_C03 select the menu : Extras

->Maintain Non cumulative values -> See if the plant is also characteristic of the validity table . That might be the reason Non cumulative keyfigure doesn't show up if you do not select plant.

Please refer below link for more information

http://help.sap.com/saphelp_sem40bw/helpdata/en/02/9a6a1c244411d5b2e30050da4c74dc/content.htm

Regards,

Prakash

[Former Member]

Hi

thanks for quick replies.

Plant is not maintained in the validity table. Also

if I remove the cumulative keyfigure from the query, selection using material works for non cumulative key figure. Problem exists obly when I have both noncumulative & cumulative together and I make selection on material

regards