Profitability and Cost Management Dimension and Member Properties

The properties for Profitability and Cost Management dimensions and members are displayed in alphabetical order in Table 10, Profitability and Cost Management Dimension and Member Properties, which displays the following information:

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.

See Oracle Hyperion Enterprise Performance Management Architect Administrator's Guide for detailed instructions on working with dimensions and members.

Caution!

All Profitability and Cost Management properties are local values. If you modify a property in one hierarchy, you cannot assume that the values will be inherited by other hierarchies.

Table 10. Profitability and Cost Management Dimension and Member Properties

Property LabelDescriptionProperty Name
AliasEnter the alias for the selected dimension member. The alias is the dimension member name that is displayed in a deployed application.

  • To assign or change the default alias name for the current dimension 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 member, click the existing alias name next to the alias table and enter the new name. Follow the proper naming rules.

 
AttributesEnter the characteristics of a dimension member.

For example, Employee dimension members may have attributes of Name, Age, or Address. Product dimension members may have several attributes, such as a size and flavor.

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:

  • Text

  • Boolean

  • Date

  • Numeric

For example, the attribute type for “Caffeinated” would be Boolean; data values would be True or False.

AttributeDataType
CommentEnter 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
ConsolidationMember 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:

Some restrictions exist regarding the use of consolidation operators in aggregate storage outlines. See the Oracle Essbase Database Administrator’s Guide .

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. After calculation, 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 OrderEnter 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 OrderEnter the numeric value in the sequence to set the order of dimensions 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 outlined in Dimension Sort Order and Density Settings.

DimensionSortOrder
Dimension Storage TypeThe 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 AggregationThis property applies to the Gen1 or Gen2 hierarchy members who host a stored hierarchy. in an ASO outline.

Set to DEFAULT

For additional information on this property, see the Oracle Essbase Database Administrator's Guide.

 
Member 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.

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 (BSO CALCULATOR) syntax.

BSOMemberFormula
Member Solve Order

(Members Only)

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.

MemberSolveOrder
POV DimensionClick the checkbox to set this dimension as a POV dimension for the selected model.IsPOVDimension
POV Display OrderIf 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 WeightingPrimary 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 member 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
UDAEnter 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
UnicodeSelect Unicode to set the application to Unicode mode. Unicode-mode applications support multiple character sets.Unicode