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 Data Form Grid Properties).
Set the 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 Planning 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).