on 05-10-2006 2:35 PM
Hi,
what are the various Performance issues in Reporting? How can we improve the performance of the query?
Many Thanks,
Any help will be appreciated.
Hi Asha,
Refer to the following documents for performance tuning aspects on reporting
performance tuning in general
You can refer to these documents on the Performance tuning link below
Hope it helps.
Message was edited by: Anurag Khungar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Asha
Please refer to following on SAP Service Marketplace -> https://websmp101.sap-ag.de/bi -> BI InfoIndex-> P -> Performance
Also you can follow some general tipe for improving query performance ...few examples are as follows -
1. Create aggregates on Infocubes
2. Create query on Multiproviders (for Single Infocube also)
3. Don't put too complex exceptions & conditions
4. Don't provide too much selection options
5. Unless it is absolutely essential , don't make ODS object available for BEx Reporting .
Hope this helps
Regards
Pradip
Hi Asha,
please have a look at
/people/vikash.agrawal/blog/2006/04/17/query-performance-150-is-aggregates-the-way-out-for-me
then on have a look at time consumed by various part of your query which are -
1. database time
2. OLAP Time
3. Front End time
look at the part which consuming maximum resources & optimize that, Don't forget to measure the performance through the same parameter post action.
hope it helps
regards
Vikash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
go through these pdf files for performance tuning in bex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.