How to delete and load the data into SAP BW system

dataservices job design
1

​Hi,

I want to load the data into BW target from SQL server source.

In the BW we created the data source and successfully load the data.

But If I want to delete the data in the BW and want to load it again there is no delete before loading option in the BW target table.

If I want to load the delta loads into BW systems then how can we achieve?

We have one project to load the data from non SAP source systems to BW system for EPM projects.

Thanks & Regards,

Ramana.

Ramana :india: (BOB member since 2009-04-30)

2

Drive the Data Services process through BW Process Chains. This way you can control the deletion of DSO objects through the Process Chain, this should not be done through/from Data Services IMHO.

From BW 7.4 and up, you can easily include SAP Data Services ETL processes in your BW Process Chains. (This may or may not have been possible as part of BW 7.3 but I’ve only used this in BW 7.4 and newer systems.)

ErikR :new_zealand: (BOB member since 2007-01-10)