webi report taking long time to open

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