Database optimization

You can schedule a task to optimize a cube. An optimization re-indexes all cubes if more than 100,000 cell changes were executed. The count is based on the number of changes on basic values.

If fewer than 100,000 changes were applied, the cube is not optimized. The number of changed cells is not saved. These settings are on the Database Performance dashboard in d/EPM Administration.