Inventory Non cumulative values are not showing correct result

[Former Member]

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

K.Srinivas

[sven_mader2]

Hi,

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
    LOOP AT SOURCE_PACKAGE ASSIGNING <SOURCE_FIELDS>.
      IF <SOURCE_FIELDS>-stockcat EQ 'V' OR
         <SOURCE_FIELDS>-stocktype EQ 'V'.
        DELETE SOURCE_PACKAGE.
      ENDIF.
    ENDLOOP.

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

Sven

[Former Member]

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