cancel
Showing results for 
Search instead for 
Did you mean: 

Data Loading in ADSO in SAP BW4hana

SANJEEVE
Participant

Hi Expert,

Advance thanks for your help.

I want to automate the load from the Data Source to Advance DSO in SAP BW4HANA.

when new records came, they should be loaded into the ADSO.

please suggest me this scenario.

waiting for your quick response.

Accepted Solutions (0)

Answers (6)

Answers (6)

SANJEEVE
Participant
0 Kudos

Hi Chandra,

Thanks for the answer.

k_chandra1
Explorer
0 Kudos

Hi Sanjeev,

As per my knowledge, you cannot get real-time data streaming with this data source, if required you can schedule the process chain with this delta DTP multiple times in BW4.

Otherwise, you can try running real-time reporting on this data source using Open ODS view, but please check how much data will be transferred and how frequently this data set will be used because it impacts the source system for each run in BW Bex report.

Thanks,

Chandra

SANJEEVE
Participant
0 Kudos

Hi Chandra,

Data Source :0SLL_CD_1, its supports delta mechanism.

thanks & Regards

Sanjeeve.G

k_chandra1
Explorer
0 Kudos

Hi Sanjeev,

What is the data source and does it supports delta mechanism ?

Thanks,

Chandra

SANJEEVE
Participant
0 Kudos

Hi Chandra,

Thanks for your response.

for your information the data is coming the Global Trade Service (GTS) Data Source.

in that the data is changing daily please suggest me can I run the daily DTP for it, or can I create the process chain.

please provide it in detail to work on this scenario .

k_chandra1
Explorer
0 Kudos

Hi ,

You can use the CDC mechanism in CDS view to achieve this requirement.

Already in S4 Hana, most of the logistics data sources has enabled by this mechanism.

If we need to enable this to custom data sources, then please write a CDS view and enable the CDC mechanism for a required field.

Please go through the document :

https://blogs.sap.com/2019/12/16/cds-based-data-extraction-part-ii-delta-handling/

https://blogs.sap.com/2018/10/31/how-to-create-delta-extraction-based-abap-cds-views/

After enabling this, please use the streaming process chain in BW4 Hana.