Symptom
- The initialization of the dashboard is very slow.
Reproducing the Issue
- Xcelsius 2008
Resolution
- If you are using external connections such as Query As A Web Service (Qaaws) or Live Office
Instead of using the 'Refresh on load' option within the Data connections (which loads the queries during initialization), place a Connection refresh button to the canvas and activate the 'refresh on load' on the button instead (which will load the queries once the initialization of the dashboard is complete)
2. INDEX/MATCH functions
If you are extensively using INDEX/MATCH functions within the Excel spreadsheet, opt for a selector component with 'Filtered rows' option under the Data Insertion Type
See Also
Xcelsius 2008 Best practices guide:
Keywords
loading, start, improve, performance, speed up, quick, increase, initialisation , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , How To