cancel
Showing results for 
Search instead for 
Did you mean: 

webi report taking long time to open

Former Member
0 Kudos

Hi ALL

Im having issue with some report taking too long to open

I know this is a general question but its tough to resolve it

Thing l have check

-whether the webi report is set to "Refreh on Open"  but is not

-I run  the same query in the backend database and it ran in 242.3 seconds.


but still having issue. I run it in Bl launch pad and rich client.


Any other solution out there.



Thanks

JS

Accepted Solutions (1)

Accepted Solutions (1)

former_member185603
Active Contributor
0 Kudos

You need to check if the report has lot of variables, report filters or report formatting. Some of these scenarios will add more delay.

While running webi report, you can check with DBA to monitor the SQL run time and then you need to add extra time for webi processing.

Former Member
0 Kudos

Hi Jawahar,

I have attached screen shot of my WPS

Please advise

DellSC
Active Contributor
0 Kudos

If this is not an instance, I would edit the report, purge all of the data sources, and then save it.  It could be that the saved version of it has lots of data in it and that's what taking so long to load.

-Dell

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

you can try to save the report in Structure mode or purge the data from the report and check.