1. Administrator's Guide
  2. Creating Profitability and Cost Management Applications
  3. Creating Applications Using the Profitability Applications Console
  4. Creating an Essbase Master Cube for Profitability and Cost Management
  5. Dimension Types

Dimension Types

When creating the Oracle Essbase Master Cube, every dimension must be assigned a DIMTYPE UDA.

The valid dimension types for Standard Profitability applications are displayed in Table 3-2.

Table 3-2 Standard Profitability Dimension Types

Property Label Property Name Description
Allocation Type DIMTYPE_ALLOCTYPE

For Standard Profitability only, create an AllocationType dimension using the following criteria:

  • Assign the Generation1 member a UDA value of "DIMTYPE_ALLOCTYPE" so that Oracle Hyperion Profitability and Cost Management recognizes the member. The member name may be anything, but the UDA value must be set as described.

  • Create one dummy member in this dimension to enable Essbase to save an outline where a Gen1 member has no children.

Measures DIMTYPE_MEASURES

  • Create a Measures dimension and assign the Generation1 member a UDA value of "DIMTYPE_MEASURES." The member name may be anything, but the UDA value must be set as described.

  • Create one dummy member in this dimension to enable Essbase to save an outline where a Gen1 member has no children.

    Note:

    For Standard Profitability only, see Custom Measures Dimensions to use Custom Measures dimensions.

Generic (Business) DIMTYPE_GENERIC Assign Business dimensions a UDA value of DIMTYPE_GENERIC.
POV

  • DIMTYPE_POV1

  • DIMTYPE_POV2

  • DIMTYPE_POV3

  • DIMTYPE_POV4

 For up to four POV dimensions, assign the Generation1 Member value in numerical sequence. For example, DIMTYPE_POV1, DIMTYPE_POV2, and so on.

Dimension types for Detailed and Management Ledger Profitability applications are similar except Detailed Profitability has the system dimension MeasuresDetailed (DIMTYPE_MEASURES) and Management Ledger Profitability has system dimensions Rule (DIMTYPE_RULES) and Balance (DIMTYPE_BALANCES).