Business Intelligence with SAP Business Objects 4.3

Variables that impact on Dashboard  Load Time In order of importance: 1. Queries or connections that are set to Refresh Before Components Are Loaded.           This is the default setting for a query.            If you have any queries or connections set to refresh before components are              loaded the             Initializing message phase stays up until they have all completed. 2. Excel cells 3. Excel calculations 4. Components 5. Bindings from components to Excel (also size of ranges) 6. Dashboard file size Please Note: Default  maximum number or rows you can refer to in a formula or in a binding is  512  rows. You can  change this in  File  >  Preferences  >  Excel Options  (max recommended is  2000  rows) but this may affect the performance of your dashboard. See Also: SAP BusinessObjects Dashboards 4.0 - Spreadsheets

Here you will find some tips in order to improve your Business Object Universe: 1. In Universe design Un-necessary Tables, Classes, Objects and joins are to be remove. 2. Use Shortcut joins for query retriving fast. 3. Integrity Check. 4. Use Index awareness 5. Disable List of values for Measures and unncessary dimension Objects. 6. Partitioning the fact table can boost your query performance. 7. Keep the number of key figures low to increase the performance Performance Tuning in WebI: 1. Un-necessary Objects remove from Query Panel. 2. Limit the no of Rows for report level analysis and usage. 3. Use Query filters and report filters. 4. Array fetch size will be use as max. 5. Limited use of complex queries and Prompts. 6. Decrease the Creation of variables See also Universe best practises