Configuration

Activation of the new OLAP Server Rules Engine

The OLAP Server will, by default, use the old rules engine for calculations on cubes where acceleration is enabled. If you disable acceleration, then the new rules engine will be used.

Which rules engine the server uses is not influenced by the existence of accelerator definitions. I.e. even if there are accelerator definitions that create accelerator flags, they will not be used if the "Use accelerators" checkbox is unchecked.

Size of the calculation blocks

As described in the section Rules and Calculation, the OLAP Server retrieves and calculates the values in blocks. The maximum size of those blocks is defined in the database settings of OLAP Administration, in the section Memory, Size of calculation block:

The default value is 1e6 (equals 106 = 1.000.000) cells. i.e. the OLAP Server will create internally blocks with no more than 1e6 cells. This limit is conservative and too low for many data models due to their sparseness. If it is too low, then calculations can be split into too many blocks, slowing the calculation.

It is recommended to try the server behavior with values like 1e50 or 1e80. Usually they will speed up the systems without problems. But for safety, we recommend that you monitor the memory usage as described above. If you run into a memory problem, avoid especially fixed results in rules as described in 'Best practices' related to rules.