Increase planning performance using BWA?

[Former Member]

Hi,

does anybody know if the performance of a planning application using Integrated Planning increases if using BWA? From my point of view the planning buffer for IP and the BWA data are separated.

I only can imagine that the planning buffer is filled out of the BWA with e.g. actuals and data out of closed planning requests. That means that only the reporting part (filling of planning buffer) is speeded up. A decrease of planning application runtime is not achieved.

Is that right?

Thanks for help in advance!

Thomas

[Former Member · Accepted solution]

Hi Thomas,

The BWA comes into picture even when you save back the results.

The following link gives the details:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f095d134-bd08-2b10-63ba-a1f6d2f6d...

Thanks,

Divya.

[Former Member · Accepted solution]

Hi Divya,

thanks very much for this material.

But as you can see in slide 8 planning data are not directly written into BWA but into planning buffer and/or real time info cube. I do not see that BWA is participating the planning process. Only if a planning request meets a specific amount of records its being closed and available for rollup into BWA.

So out of this slides I do not see that BWA is accelerating planning functions.

Maybe I'm wrong?

Thanks

Thomas

[Former Member · Accepted solution]

Hi Thomas,

BWA can accelerate only certain planning functions which use the function module:RSDRC_INFOPROV_READ/ RSSEM_INFOPROV_READ ( to read from the infoprovider which uses BWA ).

Thanks,

Divya.

[Vitaliy-R · Accepted solution]

Thomas, you are right.

BWA 7.0 only improves so called "BW read time" during execution of planning functions. All planning data is written into the planning cache in app server, then database-based open request of the InfoCube, and only then asynchronously rolled-up into BWA (but you need to remember to set this up!).

So, improvement depends on the nature of the your planning function. In one POC we managed to reduce planning function execution from 9 hours to 1 hour with BWA in place, but as I said it all depends on the scenario.

Regards,

-Vitaliy

[Former Member]

Thanks to all of you for this helpful information.

[Former Member]

Thomas,

Writing back to the database will not be accelerated, in contrary it will be even worse because the BWA indexes have to be rebuilt each time.

Tansu

[Former Member]

OK. Thanks a lot for all your answers.

That means my assumptions have been confirmed.

Maybe this functionality is going to be put in place with HANA in combination with BO-PC based upon BW-IP?

Unfortunately information about that are rare... We will see

[Vitaliy-R]

>

> Maybe this functionality is going to be put in place with HANA in combination with BO-PC based upon BW-IP?

Thomas, that's exactly on the roadmap for HANA. But even as an SAP Mentor I am not in the position to make any future-looking statements on behalf of SAP