Change BW Query Initial Variable Input at runtime

[Oscar_Alberto]

Hi guys!!

I have a BW Query that is used as infoprovider in order to load inventory values (non cumulative) into an ADSO. I have to laod several weeks of history and we have more than 200 hundred plants (it a huge volumen of data).  Right now I'm using a SAP Exit variable with an offset to load the diferents weeks and several queries to load separate plants in order to avoid a memory error.

So, I would like to use just one query instead of creating several Query and change the variable via ABAP during the execution of the DTP, is this feasible?

Thank you all.

BR Oscar

[nachtaktiv]

did you try setting "package size" or "partitioning" to separate this into smaller pieces ?