Database performance options

Select Dashboards > OLAP > Database Performance .

You can specify that cubes that have not been accessed for a specified period are unloaded from memory. Select Unload idle cubes and specify the idle period.

You can specify that cubes are optimized periodically. Select Optimize cubes and select the time at which the first optimization should occur and the interval between subsequent optimizations.

An optimization re-indexes all cubes if more than 100,000 cell changes have been executed. The count is based on the number of changes on basic values. If there have been fewer than 100,000 changes, the cube is not optimized.

OLAP can split calculation tasks for each user into separate packages, which can be run in parallel on separate threads. Optionally, switch off the Multi-thread Calculation option.