Posts

Showing posts from January, 2012

Business Objects Performance

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