Managing Database Compression While Maintaining Retrieval Performance

Another consideration when choosing a compression dimension is how well it is expected to compress the database. The size of the compressed database changes depending on which dimension you tag as compression.

In Administration Services, you can view compression estimates and then choose a compression dimension in the same dialog box. Selecting a new compression dimension in Administration Services restructures the outline automatically.

  To view the expected level 0 size of the database for each dimension when hypothetically tagged as compression, and to choose a compression dimension, see “Selecting a Compression Dimension for Aggregate Storage” in the Oracle Essbase Administration Services Online Help.