Selecting Data Compression Methods

If you have Database Manager permissions, you can select a data compression method for a database (bitmap compression, run-length encoding, or ZLIB compression). When data compression is enabled, Essbase compresses data blocks as it writes them to disk. During retrievals, compressed blocks are swapped into the data cache; the blocks, including empty cells, are fully expanded.

Generally, data compression optimizes storage. You can evaluate compression efficiency by reviewing the compression ratio statistic. See Checking the Compression Ratio.

Note:

Data compression does not apply to aggregate storage databases.

Compression-scheme changes affect only blocks that are subsequently written to disk, not blocks that are on disk.

  To enable data compression methods for databases:

  1. From Enterprise View or a custom view, select a database.

  2. Right-click, and select Edit, and then Properties.

  3. In the Database Properties window, select the Storage tab.

  4. From Data compression, select a data compression method.

  5. Click Apply.

Related Information

Related Commands