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 Essbase database.
Split large data forms into multiple smaller data forms having fewer rows and columns. Organize related data forms into folders.
Using account annotations impacts performance, so use them sparingly.
The first time Planning is launched and data forms are opened, caches are loaded, which takes more time than in subsequent sessions. So, before your users start using Planning, launch the product and open the most commonly used data forms to reduce the loading time for your users.