SAP Knowledge Base Article - Public

1369382 - How to optimize the initialization time when opening an Xcelsius dashboard?

Symptom

  • The initialization of the dashboard is very slow.

Reproducing the Issue

  • Xcelsius 2008

Resolution

  1. 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:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a084a11c-6564-2b10-79ac-cc1eb3f017ac

Keywords

loading, start, improve, performance, speed up, quick, increase, initialisation , KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Xcelsius Enterprise 2008