Compacting the Outline
Although ASO cubes do not contain blocks, cube fragmentation may occur when members or dimensions are added or deleted. Compacting the cube outline, especially after changing metadata, defragments the cube to improve performance and reduce size. Compacting the outline optimizes size, but does not clear data.
You must compact the ASO cube outline on a routine basis, especially after modifying hierarchies. Because compacting the outline requires locking the cube, this process is best scheduled to run when the application is idle. If you are in development phase, you may compact the cube manually using Calculation Manager and review the output to identify areas for optimization. See the following topics: