15 Optimize Cubes Using Cube Designer
The cube designer Optimize Cube option provides a set of utilities to help you build and optimize 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.