Essbase Database Optimization Setting recommended
Hi Everyone,
I was trying to Optimize Essbase cube and found few of the deciding factors as follows:
Data cache Size = 0.125*(sum of all exx......pag files of Essbase Cube)
Index Cache Size=Index file size of the Essbase cube
So the question here is how do i calculate the optimal Value for the following:
Committed block setting (default is 3000 blocks)
And other Settings or checks that will help me in Optimization of the Essbase Cube.
FYI
The Essbase App is BSO
Thanks & Regards
Deepak PS