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..

Look Smarter than You Are with Hyperion Essbase

Yesterday, just arrive new book I bought from Amazon.com. Looks like I will spend mostly my weekend time reading the book to sharpen my Essbase skill... :)

Data Value [%] Encountered Before All Dimension Selected,[%] Records Completed

Essbase error description :	"Data Value [%] Encountered Before All Dimension Selected,[%] Records Completed"
Solution :	Check the load rule. If there are any dimensions in your database not specified in the data load file, make sure you specify them in your header.