Replacement for APD due to memory constraint

[swati_gawade]

Hi All,

we need output of a query as data extract for an open hub for reporting outside SAP for stock related data with non cumulative KF.

Currently we are using an APD function to get data in an Direct Update DSO and then to the Open hub. However, recently we are facing issues as the no of records have increased exponentially and the Job gets terminated due to memory issue.

I can not use Query as infoprovider as Non cumulative KFs are used in Query. What can be solution to this situation?

We are BW 7.3 patch level 18 on HANA DB.

We are currently breaking the selection in multiple iterations. still looking for better solution. If we have any other functionality to achieve this.

Thanks,

Swati.

[nora_roch]

Hi Swati,

did you try already the query partitioning as recommended in the SAP Wiki: Memory issues in APD processing ?

Cheers,

Nora