Problem during transfering of data from Datasource to Infocube

[Former Member]

Hello SCM APO/BW expert,

I am transferring data from Datasource to info cube.

The data from my datasource are reconciled to my R/3 SIS infostucture.

My problem is when I transfer the data from BW datasource into infocube.

It seems that the value for Invoiced Sales Quantity are always multiply by (2)

For ex.

Datasource(PSA) Infocube

Sales inv qty. = 60 EA 120 EA

= 40 EA 80 EA

My Rule type of this key figure is Direct assignment (no any formula)

I have only 1 PSA request from my datasource.

Can you please help me if you encountered same scenario?

Regards,

Jay Angeles

[Former Member]

Jay,

What is the data in your PSA, is it as expected or doubled?

How is the Data Source extracting the data? try usin RSA3 to check the data source results?

Make sure there are no two entries for the same master data which are being aggregated? Check this in RSA3 extract as well as the PSA.

ABhi

[Former Member]

Hi,

The data from the PSA is correct and reconciled to the main source data from R/3 SIS.

But when I transfered the data into infocube the data was always multiply into 2 or doubled.

I have only 1 PSA request.

[Former Member]

Are there any active requestes in the cube on top of which you are adding this data? In other words do you delete the current requests and reload the data? I am only wondering if teh summation type of the KF is SUM and you have an existing request on top of which you load the current request which causes the sisue. Also is theer a one to one mapping between the time characteristics, or are you doing something different there?

The issue is with only one KF or all?

ABhi