cancel
Showing results for 
Search instead for 
Did you mean: 

Increase planning performance using BWA?

Former Member
0 Kudos
60

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
Developer Advocate
Developer Advocate
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks to all of you for this helpful information.

Former Member
0 Kudos

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
0 Kudos

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
Developer Advocate
Developer Advocate
0 Kudos

>

> 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