Question:
My reports are executing very slow it is taking about 4-10 Min's to get on the screen. We did all efforts like check net workspeed and frontend machine memory and application server and as well as database server tunning but still this is problem. The quries not used filters they are constructed with hierarchies more and need to have rebuilding of quries.I do have with me various methods to improve query performece id there any chance we can improve performence by furthercapacity planning as rebuilding or recreating queries will take time and need testing as well and need to sync with old report etc..
Any one has any ideas in this subject ..
raonk
Answer:
Hi, You can create Aggregates. If you don't use filters in the Query, You have to construct your aggregate with the characteristic that yo use to drilldown. If you use hierarchy you must indicate which node is drilldown by default.
Regards
Answer:
I would suggest that you recheck with DBA whether they have taken runstat of the database.
Also, use transaction code RSRT ( select Read mode), and check whether the raido button is set to 1. ( By default it is 1st).
Aggregates should certainly improve the performance.
Answer:
The transaction code RSRT works quite well - you have to apply this at each query however. I would recommend running 1 query with the way it is - remember the filter values utilized. Then, access RSRT and modify the query tested and change to the setting pointed out above - and re-run with same filter values. Check the time difference to measure the performance. Also, look into implementing the Statistics Cube - this reveals some good information (metrics, if you will) that can help with creating aggregates and also providing some info on where the bottlenecks may be happening (measures system responses to different actions of the user).
Regards,
RT
Answer:
Actually, there is a global setting in RSRT. Go to Environment --> All Queries Read Mode and set it to whatever option you want for all existing queries.
You can also change the default for any new queries that get created for an infocube in transaction SPRO. We set this once (for each infocube) to the same as the setting chosen above.
Bob
Answer:
Thanks, is this in 3.0B or 2.0B?
Answer:
Aggregates are generally where your performance increase comes.
I generally use the system generated MIN and MAX aggregates, copy them and insert hierarchy levels 2 and 4 for any objects that have hierarchies (mostly profit ctr, account etc). These help alot.
Also ..
Make sure your indexes on the cubes are ok (You can use rsrv for this), and that statistics are ok ... check these in manage infocube.
Look into partitioning your cube.
There is an entire section devoted to bw performance in sapnet, and if you search on oss you can find good material.
Angelina J.
Answer:
Hi,
I was in SAPNET this morning... there is a document in Know-How Network on Web Reporting & Performance and Accelerating BW Reporting Performance - Transcript - so you might want to have a look at these
Greetings from Germany,
Angie