You use the Compression tab to view compression estimates for aggregate storage databases. Compression estimates, which are related to the size of the database on disk, change depending on which dimension is tagged as the compression dimension.
In the Compression tab, information about each database dimension and about the “No compression dimension” is displayed in a series of columns:
Dimension Name
Is compressed—True or False, whether the dimension is tagged as the compression dimension
Stored Level 0 Members—The number of level 0 members that are stored
Average bundle Fill—Estimated average number of values per compression dimension bundle
Average Value Length—The estimated average number of bytes required to store a value
Level 0 Size (MB)—The estimated size of the compressed database
Note: | The values in the row labeled <No compression dimension> assume that no dimension is tagged as accounts. |
“Understanding the Compression Dimension for Aggregate Storage Databases” in the Oracle Essbase Database Administrator's Guide
query database (MaxL) in the Oracle Essbase Technical Reference