In aggregate storage databases, the size of the compressed database changes depending on which dimension is specified as the compression dimension, and can affect retrieval performance.
When the data model property is set to aggregate storage, the Accounts dimension is specified as the compression dimension by default. However, you may determine that another dimension is the optimal choice for compression. Using the Compression Dimension check box, you can specify any single dimension as the compression dimension.
After performing a data load, use Administration Services Console or MaxL to view detailed compression and query statistics for your database.