For existing calculation scripts, you can use the memory monitoring tools provided for the operating system on the server to observe memory usage. Run the most complex calculation and notice the memory use before and while running the calculation. Calculate the difference and use that figure as the additional memory requirement for the calculation script.
For a comprehensive discussion of calculation performance, see Optimizing Calculations.
If you cannot perform a test with a calculation script, you can calculate a very rough estimate for the operational requirement of a calculation by adding the following values:
The size of the outline. For calculations, Essbase uses approximately 30 additional bytes of memory per member of the database outline. For information about concurrent calculations, see Managing Caches to Improve Performance.
The size of the memory area used by the blocks set aside by the SET LOCKBLOCK command.
To calculate the memory requirement in bytes, multiply the specified number of data blocks by the logical size of the data blocks.
For the logical block size, multiply the number of cells (value MI in Table 249, Worksheet: Factors Used to Calculate Database Memory Requirements) by 8 bytes per cell.
For the total calculation requirement, summarize the memory needed for all calculations that will be run simultaneously and write that total to the cell labeled MF in Table 250, Worksheet: Estimating Memory Requirements for a Database.