Error: 1012700 The dynamic calc processor cannot allocate more than  blocks from the heap. Either the CalcLockBlock setting is too low or the data cache size setting is too low. Increase CalcLockBlock setting or the data cache size setting and then retry
I have actually done the following for several times;
1. In Administration Console, I have; increased Data Cache;
Data Cache Setting (KB) 10000000
Block Size (B) 810720
Could be a possibility for that... Please check and Analysis the Calculation Scripts or Business Rules which causes for the issues....
Some times, the script will through errors, if we not handled properly... please check is there any below command is ON inside the FIX or anywhere in the Script, this should is OFF at the end of the particular point or in somewhere. If it is not handled properly, could be issue also...
FIX () or IF ()
SET CREATENONMISSINGBLK ON....
SET CREATENONMISSINGBLK OFF /* Always the script should close this function */
Your Databse block Size is also very high, try to make dynamic calc to parent members to reduce the block size or
try to make a dimension sparse form any one of the dense dimension if you have more dimension as dense other than
Account and Period.
It is the simple calculation given in the oracle document which is 12.5% of the page file size.
whereas index cache is equal to the index file size.
There is no limit to the no. of dimensions in a dimension, but you need to check
the block size if you are adding too much members to the dense dimensions since it will impact the
calculation performance and retrieval issues.
If you need to lock let's say 10000 blocks (we don't know how many yet, we only know that you need to lock more than 6315), you will need over 8.1GB of datacache.
Either reduce the block size (500~600kb is the maximum I would recommend), either set a datacache large enough (if you are not using the latest version, you'll need to use the option MEMSCALINGFACTOR in Essbase.cfg)