How to enable parallel processing - Cube to DSO load

[kirankumar440]

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.

Br

Kiran K

[kirankumar440]

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

[FrankRiesner]

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

[kirankumar440]

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 ?

Br

Kiran

[TuncayKaraca]

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

[Babu-Dudekula]

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