Within aggregate storage databases, when you mark a dimension as accounts, you enable compression. Compression estimates, which are related to the size of the database on disk, change, depending on which dimension is tagged as accounts.
You can view estimated compression statistics, to help you determine which dimension to tag as accounts. You can view actual compression statistics in the Compression tab of the Database Properties window.
Note: | You can view compression statistics only for databases that contain data. |
To select an accounts dimension:
From Enterprise View or a custom view, select a database.
Right-click, and select Select accounts dimension.
The Select Accounts Dimension dialog box is displayed.
Select a dimension, and click OK.
At the confirmation message, click Yes.
The outline is updated and restructured.
“Choosing an Accounts Dimension to Manage Database Compression” in the Oracle Essbase Database Administrator's Guide