Skip to Content
Former Member
Jun 06, 2006 at 02:09 AM

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



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