Showing results for 
Search instead for 
Did you mean: 

Inventory Non cumulative values are not showing correct result

Former Member
0 Kudos

Hi Guys,

I have created a report on Inventory cube taking material in rows and 0T0TALSTCK and 0VALSTCKVAL in colums and i created a variable on calender day . What ever the date if we give we will get the quantity and value as on that date.

Here Quantity is showing perfectly and in case of value it is showing wrongly. In this case the interesting thing is if we substract the (Reciet value - Issue ) value then i am getting the correct value.

Some times Even quantity is zero the noncumulative keyfigure (0VALSTCKVAL)is not showing zero it is showing some value but if i do (Reciet value - Issue ) it will show correctly.

Please help on this issue.

Thanks & Regards


Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos


when the quantity is correct, then you have a problem with the values. You have loaded the infocube correcly.

check your keyfigures and the transformation with the BI content.

=> for example: do you have the coding in the BF transformation?

* see OSS note 571669
      IF <SOURCE_FIELDS>-stockcat EQ 'V' OR
         <SOURCE_FIELDS>-stocktype EQ 'V'.

=> you have used the datasource 2LIS_03_UM. There are no quantities. Is there your problem.


Former Member
0 Kudos

Hi Mader,

I can able to match the some of the materials with noncumulative keyfigure(0VALSTCKVAL).But some of the materials are not matching .

If the problem in the transformation level then no material will match.

We are using the UM data source but even if i load the UM data there is no any impact on the values.I cross verified the value before loading and after loading.

Please help to crack this issue....

Edited by: srinuvas reddy on Feb 15, 2012 3:17 PM