How to reconfigure Essbase database to avoid error 1012700
Hello.
I have an Essbase BSO database that is growing in usage, so I am concerned with fine-tuning the cube to keep the size down and performance fast. The specifics/settings on the database are:
- Buffer size 100 kb
- 5 dimensions - 2 Dense and 3 sparse. The Dense dimensions are the Accounts and Time dimensions.
- Block Size is 715008 B; seems very large but is due to there being almost 4,000 accounts. Potential # of Blocks is 198,900.
- Index Cache = 10,240
- Data File Cache = 500,000
- Data Cache = 500,000
- Storage is Buffered I/O
So what I've been trying is making a copy of the application, changing the Time dimension to Sparse, then stopping and starting the application. When I attempt to retrieve from Excel I always get the error: "Dynamic calc processor cannot allocate more than [200] blocks from the heap. Please increase CalcLockBlock setting and retry". This message corresponds to error 1012700.