cancel
Showing results for 
Search instead for 
Did you mean: 

ODS Data

Former Member
0 Kudos

Hi Experts,

Customer has been deleted from R/3 side due to his retirement.

BW extracting data from R/3 to ODS, then to another ODS1 and finally to cube.

To the fist ODS, data is not coming for the particluar cutsomer and in second ODS the data is present with negavtive values for the order quntity for the customer and the same is reflected in cube also. The update is in Delats update.

Could you please give some light on this how the data is polulating in second even though there is no data in the source ODS.

Thanks

SKR

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Reddy,

On this scenario like this:

if Customer is retired,then KUNNR table where the masterdata will be available will be updated first and then the transaction tables will get updated regularly(R/3).

Similarly in BI,we have Master Data and Transaction data Process Chains which gets loaded to reflect the R/3 data.

In your Case,

whenever your loading the DS0,you need to be careful.Since it acts as source to other dataproviders.

DSO-->DSO1 (junk data is getting loaded bcos of the breakin data of the customer details in DSO)

Solution:

Run a repair request to DSO's infoPackage and then run delta DTP.After this run delta DTP(DSO-->DSO1) and delete the before request in cube(also you need to delete the datamart status in DSO1) then only you can run delta dtp to cube.

Hope this clarifies

Assigning pts is the way of saying thanks in SDN