The properties for Profitability and Cost Management dimensions and members are displayed in alphabetical order in Table 41, which displays the following information:
The Property Label, which provides a more readable display name for the property. If applicable, the associated database type is appended to the name (ASO or BSO). If no database type is specified, the property applies to both types.
A Description of each property
The Property Name, which provides a unique identifier for the property that is used when updating data in the import and batch client.
You can modify any property that presents a drop-down list or data entry text box when you select the property in the Dimension Library.
Note: |
For information on Essbase properties, refer to Dimension and Member Properties. |
Table 41. Profitability and Cost Management Dimension and Member Properties
Property Label | Description | Property Name |
---|---|---|
Alias | Enter the alias for the selected dimension or member. The alias is the dimension name that displays in a deployed application.
|
Alias |
Application Type | Displays the type of Profitability and Cost Management application:
|
|
Attributes | Enter the characteristics of a dimension member.
For example, the Product dimension members may have several attributes, such as a size and flavor. See Dimension and Member Properties for more detailed descriptions. |
Attributes |
Attribute Type |
Associate an attribute type with the selected member. Create attribute values for attributes assigned to dimension members that you can use to query on and to filter members. Attribute types are:
For example, the attribute type for “Caffeinated” would be Boolean; data values would be True or False. |
AttributeDataType |
Comment | Enter a comment for the dimension or member. Comments can contain up to 255 characters. By default, this text box displays the current comment, if one exists.
You cannot assign a comment to an attribute dimension or member. Note: For Unicode-enabled databases, a maximum of 80 characters is allowed. |
Comment |
Consolidation |
Member consolidation properties determine how children roll up into their parents. If the current member is not a dimension or an attribute, select the consolidation operator to assign to the member:
Note: There are some restrictions with use of consolidation operators in aggregate storage outlines. Refer to the Oracle Essbase Database Administrator’s Guide for additional information. |
Consolidation |
Data Storage(ASO) | Select the ASO storage options for dimensions and members:
|
|
Data Storage(BSO) | Select the BSO storage options for dimensions and members:
|
|
Dimension Formula(ASO) | Double-click the cell and then click the Selector button to open the Memo Editor. Enter the formula, and then click OK.
Use the appropriate ASO MDX syntax. |
ASODimensionFormula (for dimension root member) |
Dimension Formula(BSO) | Double-click the cell and then click the Selector button to open the Memo Editor. Enter the formula, and then click OK.
Use the appropriate BSO CALCULATOR syntax. |
BSODimensionFormula (for dimension root member) |
Dimension Solve Order | Enter the numeric value in the solution sequence for selected dimensions. For example, if this dimension is to be solved second, enter “2.” | DimensionSolveOrder |
Dimension Sort Order | Enter a numeric value that indicates where the dimension should be placed in the Essbase outline that is generated by Profitability and Cost Management.
For example, if this dimension is to be the second in the Essbase outline, enter “2.” Dimension Sort Order must be set for every dimension in the model, except Alias and UDA dimensions. The dimension sort order must be sequential, unique and greater than or equal to 1. Set the sort order as follows:
|
DimensionSortOrder |
Dimension Storage Type | The Dimension Storage Type property applies only to Block Storage (BSO) databases in Essbase. Select the type of storage required for the dimension:
|
DimensionStorageType |
Hierarchy Type
(Dimensions Only) |
The Hierarchy Type property applies only to Aggregate Storage (ASO) databases in Essbase. The Reporting database is generated by Profitability and Cost Management.
Set the type of hierarchy for the dimension:
|
DimensionHierarchyType |
Hierarchy Type
(Members Only) |
Set the type of hierarchy for the member:
|
HierarchyType |
Level Usage for Aggregation | Displayed for PrimaryLevelWeightingDim on the Property Grid. | |
Member Formula(ASO) | Double-click the cell and click the Selector button to open the Memo Editor. Enter the formula, then click OK.
Use the appropriate ASO MDX syntax. |
ASOMemberFormula |
Member Formula(BSO) | Double-click the cell and then click the Selector button to open the Memo Editor. Enter the formula, and then click OK.
Use the appropriate BSO CALCULATOR syntax. |
BSOMemberFormula |
Member Solve Order
(Members Only) |
Enter a numeric value to represent the priority with which Essbase calculates the formulas. 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. |
MemberSolveOrder |
POV Dimension | Click the checkbox to set this dimension as a POV dimension for the selected model. | IsPOVDimension |
POV Display Order | If there are multiple POV dimensions, enter the numeric value (such as 1, 2, 3, and so on) to set the display order for each POV dimension. | POVDisplayOrder |
Primary Level Weighting | Restricts the levels which can be selected by the view selection engine during aggregation operations. These settings only apply to Essbase (ASO) applications.
Select one of the following options:
|
PrimaryLevelWeighting |
Two Pass Calculation
(Dimensions Only) |
For BSO databases only, select the check box to calculate a dimension on the second pass through the outline. | TwoPassCalc
(for dimension root member) |
Two Pass Calculation
(Members Only) |
For BSO databases only, select the check box to calculate a member on the second pass through the outline. | TwoPassCalc |
UDA | Enter the UDA name for the selected member.
A UDA dimension must exist in Performance Management Architect, and be associated to the base to which the UDA is being added. See “Viewing Dimension Associations”. You can enter up to 256 alphanumeric characters. Note: For Unicode-enabled databases, a maximum of 80 characters is allowed. |
UDA |
Unicode | Select Unicode to set the application to Unicode mode. Unicode-mode applications support multiple character sets. | Unicode |