When selecting an aggregate storage option, consider the following guidelines.
Note: | For information on aggregate storage and its use, see “Creating, Calculating, and Managing Aggregate Storage Databases” in the Oracle Essbase Database Administrator's Guide. |
Formulas can be specified only on members in a dynamic hierarchy or in a comparison dimension.
If a dimension contains alternate hierarchies and the Label Only option is used in any hierarchy, the same member level in all hierarchies in the dimension must be set to Label Only.
In a dynamic hierarchy, only stored members can have attribute associations.
All members of stored hierarchies must be tagged with the + [addition] consolidation method. The only exception to this is a member tagged as Label Only member and any direct child of a Label Only member.
A shared member may be used only once in a stored hierarchy.
The top member in a dimension with multiple hierarchies must be tagged as Label.
A compression dimension must contain a single dynamic hierarchy.
A single dynamic hierarchy must have at least one level 0 member without a formula.
The product of the number of stored dimension levels in an aggregate storage outline must be less than 2^32.
Currency settings cannot be specified.
Attribute dimensions cannot be associated with an accounts dimension
In the accounts dimension, the Label Only property for members can used for all member levels with the exception of member level 0 member.
In all dimensions other than the accounts dimension, all the levels above a member tagged as Label Only must also be tagged as Label Only. All children of a member tagged as Label Only must be tagged with the + [addition] consolidation method. The only exception to this is the direct child of the member.
Note: | A level 0 member cannot be tagged as Label Only. |
In the accounts dimension, all consolidation methods are allowed.
In all dimensions other than the accounts dimension, only the + [addition] consolidation method can be used. All children of a member tagged as Label Only must be tagged with the + [addition] consolidation method. The only exception to this is the direct child of the member.
Formulas can be specified only on members in a dynamic hierarchy or in a comparison dimension.
Dynamic Time Series settings may be used only with a time dimension.
A compression dimension must contain a single dynamic hierarchy.
A compression dimension must have at least one level 0 member without a formula.