Optimizing Performance

Use these methods to optimize performance:

• Strategically assign dimensions as dense or sparse and order them from most to least dense (see About Sparse and Dense Dimensions, About Reordering Dimensions, and Setting Dimension Density and Order).

• Design business rules to execute within two minutes. Schedule longer-running business rules to execute in the background (see Setting Background Processing).

• Set the Suppress Missing Blocks option (see Setting Form Grid Properties).

• Set the Oracle Hyperion Planning property OLAP_MAX_CONNECTIONS to 20 if you have 100 users. If you need to after careful testing, increase the setting to 100 for 500 users (see Setting Application and System Properties).

• Optimize the JDBC connection pool settings (see Configuring JDBC Connection Pooling).

• Increase the timeout value for SQL queries (see Optimizing SQL Relational Databases).

• If you use the WebLogic Server, check its performance settings (see Optimizing WebLogic Server Parameters).

• Tune Java Virtual Machine (JVM) parameters (see 500 Error Message).

• Optimize Windows network parameters (see Optimizing Windows Network Parameters).