ASO Dimension and Member Properties
The properties for the ASO dimension and member properties displayed in Table 3-2 are pulled automatically into Oracle Essbase during deployment. No manual actions are required to align these properties with the Master Essbase Application.
Table 3-2 Profitability and Cost Management ASO Dimension and Member Properties
Property Label | Property Name | Description |
---|---|---|
Alias | Alias | The alias is the dimension member name that is displayed in a deployed application. Any member aliases are displayed, except for the Root Member. |
Comment | Comment | A comment may be entered for the dimension or member. Comments can contain up to 255 characters. By default, this text box displays the current comment, if one exists. |
Consolidation | Consolidation | Member consolidation properties determine how children roll up into their parents.
If the current member is not a dimension or an attribute, one of the following consolidation operators is assigned to the member:
Note: Some restrictions exist regarding the use of consolidation operators in aggregate storage outlines (ASO). See the Oracle Essbase Database Administrator's Guide. |
Data Storage(ASO) |
|
The ASO storage options that are available for dimensions and members:
|
Dimension Formula(ASO) | ASODimensionFormula (for dimension root member) | The calculation formula that is applied to the dimension. |
Dimension Solve Order | DimensionSolveOrder | The numeric value in the solution sequence for selected dimensions. For example, if this dimension is to be solved second, enter "2." |
Hierarchy Type
(Dimensions Only) |
DimensionHierarchyType |
The Hierarchy Type property applies only to Aggregate Storage (ASO) databases in Essbase. The type of hierarchy for the dimension is set to one of the following values:
|
Hierarchy Type
(Members Only) |
HierarchyType | The type of hierarchy available for the member:
|
Member Formula(ASO) | ASOMemberFormula | The calculation formula that is applied to the member. |
Member Solve Order
(Members Only) |
MemberSolveOrder | Enter the numeric value in the solution sequence for selected member. For example, if this member is to be solved second, enter "2." This property applies to ASO databases only. Members that have a solve order of 0 inherit the solve order of their dimension. Members with the same solve order are evaluated in the order in which their dimensions appear in the database outline, unless otherwise specified by the dimension sort order property. Members with no solve order are evaluated after members with a solve order. |