Tune & Optimize

The chapter of "Tune & Optimize" from "Look Smarter than you are with Hyperion Essbase" is the most one I've been reading several times. Belows are some tips or summary on how to tuning performance the essbase application .
1. Tune the Index Cache

• set the index cache equal to the combined the size of all essn.ind files, if possible
• do not set this cache size higher than the total index size, as no performance improvement will be realized.

2. Tune the data cache

• set the data cache to 0.123 times the combined size of all essn.pag files with a minimum value of about 307,200 KB.
• consider increasing this value even further if you have a high humber of concurrent users

there's more about tuning performance but, enough for the theory, lets prove and test it..