topic Re: How to enable parallel processing - Cube to DSO load in Data and Analytics Forum

How to enable parallel processing - Cube to DSO load

kirankumar440 — Sat, 27 Jul 2024 10:37:09 GMT

Hello Experts,

I have some flow in SAP BW 7.5 on HANA system : Cube to DSO load. ( We need to persist data into DSO for some business requirement so that that flat table can be used for Look ups, HANA CV's in further levels)

All of the field mappings are one to one in BW TRFN, So I have used the "HANA Execution" option.

But, currently that dtp load is happening at one go as a data Insertion as its "hana execution" & I don't have any control to enable the parallel extraction as its Greyed out in DTP screen.

So, how can we enable Parallel extraction/ Insertion incase of HANA Execution/AMDP ? because currently its inserting all data at once using that - SAP HANA Execution option & occupying 400GB of memory. We want that Inserts happening in parallel.

Kiran K

Re: How to enable parallel processing - Cube to DSO load

kirankumar440 — Mon, 29 Jul 2024 15:07:52 GMT

@kurzdo93 @FrankRiesner @MarkGreen - Any inputs will really helpful.

Re: How to enable parallel processing - Cube to DSO load

FrankRiesner — Tue, 30 Jul 2024 07:34:16 GMT

If I got it right, you have simple 1-1 mappings in the TRFN. If that is the case, you have the free choice between HANA Runtime and ABAP Runtime. If HANA Runtime consumes too much resources, then simply switch to ABAP Runtime in the DTP and evaluate if the loads runs better...
KR Frank

Re: How to enable parallel processing - Cube to DSO load

kirankumar440 — Tue, 30 Jul 2024 08:13:31 GMT

Hi @FrankRiesner Thank you for the response. yes we have tried that too.. But the run time is too long with ABAP execution as the source has 200Million records & its taking around 2-3 hrs where as HANA execution just takes 10min. Is there any way that we can enable parallel extraction option in HANA execution to reduce the Memory consumption ?

Kiran

Re: How to enable parallel processing - Cube to DSO load

TuncayKaraca — Tue, 30 Jul 2024 18:07:12 GMT

Hi Kiran,

Is parallel extraction like its grayed out in DTP screen when you try with ABAP Runtime? Maybe it's all about HANA Execution and the parallelization is not possible. By saying all this of course I would ask why not! 😁

Regards,
Tuncay

Re: How to enable parallel processing - Cube to DSO load

Babu-Dudekula — Wed, 31 Jul 2024 10:01:58 GMT

Hi Kiran,

Try with multiple DTP's with filters like month etc to minimize the extraction and avoiding writing all the data at once.You can set up DTP's sequentially in Process chain.

Regards,

Babu