6 Optimize Cubes Using Cube Designer

The Optimize Cube option in Cube Designer provides a set of utilities to help you build and optimize Essbase cubes.

You can use these utilities with hybrid mode cubes, or aggregate storage cubes. Doing so helps you to understand where there are opportunities for optimizing the following processes: building and loading the cube, calculating or aggregating data, running queries, and exporting data.