Write optimez DSO for API data input?

[Former Member]

Hello

I have the need to update data from outside SAP BW into BW. Thus the DSO for direct input would be then the right candidat (update through API).

The disadvantage in our business case is, that the direct input DSO can't be used for data upload (DTP and transformation etc.)

So the better candidate would be then the write optimized DSO.

From my point of view I don't see any reason, why not to use the same API's and apply it on write optimized DSO instead on direct input DSO. Both DSO types have only 1 x table and both doesn't generate SID's

Experts....!

Do you see any drawbacks? Did I forgot anything in that good idea?

Thanks a lot of any answer

Christian Baumann

Edited by: Christian Baumann on Feb 10, 2012 2:10 PM

[Former Member]

Load the data using API into the direct DSO and then use APD to load the data from Direct DSO to a flat file (on the server)and then create a flat file data source to Infocube or Standard DSO. Put them in a process chain and create dependencies for a smooth data load. In the APD setting to Flat File select the overwrite if file already exist with the same name.

API -> Direct DSO -> Flat File (APD)-> Flat File Data Source ->Infocube/Standard DSO

[Former Member]

Hi Christian,

Your mentioning of Direct Input DSO means a Direct Update DSO which uses a APD to fill data into it.

Even if you sources are non SAP you can use standard/Custom API's to fill the data in.

I did not understand your requirement clearly, but if your intention is to fill the same DSO from a BW source as well simultaneously

we can use a APD and fill the same Direct Input DSO with sources with BI as well using join conditions and there are options to filter out data using routines as well.

We are using Direct update DSO's for snapshots of Inventory in our System. If you can explain your requirement more clearly may be I can help!

Thanks,

Chaitanya