Dashboard was running fine earlier now its taking more than 15 to 20 mins to get results.
Dashboard has been created as follows.
Base Bex query created with variables.
Form Base Bex query -> Removed variables and created query for Reporting.
Through BICS connection, Web I report has been created and publish block through Web service connection created dashboards.
Total 25 Web I report ( WDSL URL) Used in the dashboard.
I ran all the Web I report only one web I report tooks 8 mins of time and others run within a miniute.
Same I ran all the bex queries developed for Dashboard… 1 bex query taking 9 mins
3 bex queries taking 5mins
remaining all between 1 to 2 mins
I couldn’t crack why suddenly running time has been increased.
This kind of thing is nearly impossible to answer on a forum. There are simply too many moving parts. But, some things to look at:
Has anything changed with the database? Is performance directly against the database still good?
Has anything changed with Business Objects? Are any other reports having performance issues?
Has anything changed with the network? With your Tomcat (or other web server)?
Has anything changed with Java? There are certain combinations of Java, browser, and BO versions that have very poor performance.
Has anything changed with the antivirus on the BO server(s)? I’ve had issues in the past where a McAfee update started killing my report performance, because it was scanning every .wid file as it was opened.
Has anything changed with your data? If it’s one particular report, it’s possible that the amount of data being retrieved has either suddenly increased, or simply crossed a threshold where it’s no longer caching or paging efficiently.
And in the end you might consider getting an experienced (performance dashboard tuning) consultant for one to two days to analyze the issue and make some suggestions
By the way, an SAP BEx query taking 8+ min. to complete is kinda slow for any dashboard project IMHO.
(BOB member since 2002-06-20)