on 03-02-2011 2:26 PM
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
Hi Thomas,
The BWA comes into picture even when you save back the results.
The following link gives the details:
Thanks,
Divya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Thanks to all of you for this helpful information.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
13 | |
13 | |
11 | |
11 | |
7 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.