i loaded data from 2LIS_13_VDITM data source.
now i can see correct data in rsa3, but while cheking infocube
0SD_C03 1 record is coming twice, so data is not matching,
i got that recored which is deplicate in infocube,
please guide me to handle this issu.
The first step should be to see if there was any filters when you ran the report (If you had viewed data thru a report).
Then proceed to see the contents of the infoprovider/table level in BW. See of data is there. If data is there in cube and not showing in report it may be an issue with report.
If data is not there in Cube, once see in R/3 if its there.
Check the data availabilty in RSA3 of R/3 for the data source that supply data to the first level target.
Check if the application tables in R3 have data.
Check the extraction progaram in R/3 for any function module to update data.
If its found in R/3 and not in cube take a top down or bottom up apporach and follow the data flow path to see to what level data is populated, the presence of any filters in transformations,etc.
Check the data flow from source to target.
Check if any update or transfer routine available in the data flow.
Check the contents of all the targets in the data flow for this plant.
Create a Remote cube to pick the data from and r3 and a basic cube which we load regularly in BW, and we have to create a multi provider on top of these 2 cubes.
R/3 - BW reconcilation