You use the Select Accounts Dimension dialog box to review compression statistics and to select an accounts dimension for an aggregate storage database.
Note: | You can also view compression statistics in the Compression tab of the Database Properties window. |
The Accounts Dimension column:
Lists all dimensions in the current database
Includes a “No compression dimension “row, which assumes that no accounts dimension exists
Displays red icons to discourage you from tagging some dimensions as accounts. Typically, such dimensions contain more than 10,000 level 0 children.
Displays green icons to suggest suitable dimensions to tag as accounts. Typically, such dimensions contain fewer than 10,000 level 0 children.
The Expected Level 0 Size column displays, in each row, the expected size, in megabytes, of the compressed database if the dimension identified in the row is tagged as the accounts dimension.
After reviewing the compression statistics, from the Accounts Dimension column, you select the dimension that you want to tag as accounts. When you click OK, the outline is updated to reflect your change and is restructured.
“Choosing an Accounts Dimension to Manage Database Compression” in the Oracle Essbase Database Administrator's Guide