Hi All,
I did a full upload to Sales overview cube (0SD_C03). The steps were
1. Cleared the setup tables in 'Managing extract structures' in SBIW.
2. Filled setup tables using perform set up for 11,12 and 13.
3. Triggered infopackages
a. 2lis_11_vahdr
b. 2lis_11_vaitm
c. 2lis_12_vchdr
d. 2lis_12_vcitm
e. 2lis_13_vdhdr
f. 2lis_13_vditm(This is transformation. So executed DTP after that)
But the problem is quantity is more in cube than in PSA. For example, say for customer c1 and material m1 quantity is 1020 for january in both R/3 and PSA. So that means quantity is correctly coming until PSA. But in the cube it is showing 2040 for month ?January customer c1 and material m1.
I found that quantity is added up from the order,delivery and billing datasource. Because when i deleted the full upload request of delivery and billing from the cube it is showing the correct quantity. So I think the delivery quantity and billing quantity is showing in the cube for the period. So it is also showing in the report.
Is there any other workaround or did I miss any important steps in the modeling part.
Thanks and Regards,
Jerry