Dimension and Member Properties

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.

  • To assign or change the default alias name for the current dimension or member, click the existing alias name and enter the new one. Follow the proper naming rules. All databases have an alias table named Default.

  • To assign or change an alias name for the current dimension or member, click the existing alias name next to the alias table and enter the new name. Follow the proper naming rules.

 Alias
Application Type Displays the type of Profitability and Cost Management application:

  • General - Standard Profitability application

  • Detail - Detailed Profitability 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:

  • Text

  • Boolean

  • Date

  • Numeric

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:

  • + (addition) - Default

  • - (subtraction)

  • * (multiplication)

  • / (division)

  • % (percent)

  • ~ (ignore during consolidation)

  • ^ (never consolidate)

  • NotUsed

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:

  • StoreData—Data is stored with the dimension.

  • ShareData—Data associated with this member can be shared. The ShareData property applies to the member only. The Dimension Root Member cannot be shared.

  • NeverShare—Data associated with this dimension cannot be shared, even if there is an implied share relationship, such as with a parent with one child. In this case, the data is duplicated in the parent and child.

    Note:

    This option does not apply to stored hierarchies in aggregate storage outlines.

  • LabelOnly—No data is associated with this dimension.

  • ASODimensionDataStorage (for dimension root member)

  • ASOMemberDataStorage (for dimension members)
Data Storage(BSO) Select the BSO storage options for dimensions and members:

  • StoreData—Data is stored with the dimension.

  • ShareData—Data associated with this member can be shared. The ShareData property applies to the member only. The Dimension Root Member cannot be shared.

  • NeverShare—Data associated with this dimension cannot be shared, even if there is an implied share relationship, such as with a parent with one child. In this case, the data is duplicated in the parent and child.

  • LabelOnly—No data is associated with this dimension.

  • DynamicCalcAndStore—Data associated with this dimension is not calculated until requested by a user. Once calculated, the data is stored.

  • DynamicCalc—Data associated with this dimension is not calculated until requested by a user. The data is not stored but is discarded after the request is completed.

  • BSODimensionDataStorage (for dimension root member)

  • BSOMemberDataStorage (for dimension 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:

  • Measures dimension is set to 1, by default.

  • AllocationType dimension is set to 2, by default.

  • POV and business dimensions must be set to 3 or higher.

  • Attribute dimensions must always be sorted as the last dimensions.

    For example, if you have four attribute dimensions in a sequence of 12 dimensions, the attribute dimensions must be set as 9, 10, 11, and 12.

 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:

  • Dense

  • Sparse

 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:

  • Select “STORED” for any dimension members that use the following consolidation symbols:

    • +ADDITION

    • ~ IGNORE

      Note:

      The no-consolidation or IGNORE (~) operator can only be used in a STORED hierarchy if the member's parent is set to LABEL_ONLY

  • Select “DYNAMIC” for dimension members that use any consolidation symbol, including ADDITION and IGNORE, or if the dimension member contains a formula.

  • Select “ENABLED” to support alternate hierarchies

 DimensionHierarchyType
Hierarchy Type

(Members Only)

 Set the type of hierarchy for the member:

  • Stored (For first Gen2 child)

  • Dynamic (For Second Gen2 child onwards. The Second Gen2 member can host the alternate hierarchies)

  • None (Do Not Use)

 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:

  • Default – The view selection engine is free to decide which levels to pick. This is the initial value for new hierarchies.

  • AllLevels – The view selection engine considers all levels of the hierarchy for aggregation.

  • NoAggregation – The view selection engine cannot select any levels for aggregation.

  • TopLevelOnly – The view selection engine considers only the highest level of the dimension for aggregation.

  • BottomaTop – The view selection engine considers only the highest level and the lowest level of the dimension for aggregation.

  • BottomLevelOnly – The view selection engine considers only the bottom level of the dimension for aggregation.

 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