Other Performance Optimization Tips

• Set upper-level members in a dense dimension to Dynamic Calc.

• Clear unnecessary or historical data. For example, move historical data to a separate plan type to reduce the database size in your current plan type.

• Routinely defragment the Oracle Essbase database.

• Split large forms into multiple smaller forms having fewer rows and columns. Organize related forms into folders.

• Using account annotations affects performance, so use them sparingly.

• The first time Oracle Hyperion Planning is launched and forms are opened, caches are loaded, which takes more time than in subsequent sessions. So, before your users start using Planning, launch Planning and open the most commonly used forms to reduce the loading time for your users.