performance problem to retrieve the report

[Former Member]

hi gurus

i am working in BW support, i got a issue regarding reports.

query taking to much time to retrieve the report, and the same probs arise when u try to drill down in report.

can anyone plz give me a solution to solve my problem.

thanks in advance

z

[former_member195940 · Accepted solution]

Hi Zammy:

do a search on "performance", you will got lot of answers which pertains to queries. there are lot of things involved when a query takes a lot of time :

install BW stats and analyze the queries

may be an option to use aggregates is a good idea to consider

you can multi providers to do reporting for better query performance

try to avoid " excludes" in BEx

Query Read Mode - Read when navigating and expanding hierarchies

Check if indices under ORACLE are degenerated. OSS Note 323090

OLAP Cache OSS Note # 456068

Assign points if helpful

Kalyan