Factors Affecting Business Object Report Refresh

Following are the few factors affecting Business Object Report Refresh
- Network path
- Location of Server and workstation (Geographical locations)
- Server Configurations.
- Database Design
- Indexes
- Views
- Connection Driver
- Number of Users
- Parallel users
- Number of Joins at Universe level
- Predefined functions and aggregations.
- SQL Query.
- Number of rows in the result.
- Report level variables
- Number of data providers
- Cross-tab Reports


The following are the few Input required for improving Business Object report refresh time
- Good Network Bandwidth
- Fast Network path
- Small distance between all the components like Client, Database and Webi.
- Good server configuration for Web, Application and database servers.
- Good Database design
- Indexes according to reports.
- Views according to reports.
- Native drivers for database connections.
- Number of parallel users.
- Array Fetch size

The following are the areas where we can improve

- The fields used in joins are indexed
- Views are to be created for complex joins and complex calculations.
- Native Drivers for database connections should be used
- Avoid outer joins
- The string manipulations and calculations may be done on database load.
- Trim off blank spaces
- Make User/Group structure as flat as possible.
- Use proper User rights according to available resources.
- Array fetch size should be according to report requirements.
- Aggregation reduces the number of rows returned by queries.
- Use of predefined conditions.
- Avoid multiple data providers.
- Create report specific objects and conditions
- Use Query Optimization technique.
- Eliminate overhead objects
- Allow duplicate rows.
- Replace formula with variables in reports.
- Use cross-tabs reports instead of tables with a lot of columns defined by variables.
- Avoid Grouping variables
- Custom LOV’s
- Create multiple data provider in case of complex queries.
- Limit amount of data.Reducing formulas/local report variables and complex filters