Performance issues

[Former Member]

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.

[Former Member · Accepted solution]

Hi Asha,

Refer to the following documents for performance tuning aspects on reporting

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/aec09790-0201-0010-8eb9-e82...

performance tuning in general

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/cccad390-0201-0010-5093-fd9...

You can refer to these documents on the Performance tuning link below

[original link is broken]

Hope it helps.

Message was edited by: Anurag Khungar

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

hi

go through these pdf files for performance tuning in bex

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/cccad390-0201-0010-5093-fd9...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/afc59790-0201-0010-9f99-940...