1. Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
  2. Using Components to Design Business Rules and Templates
  3. DTP Assignment Components
  4. Using Design-Time Prompt Functions in DTP Assignment Components
  5. @DimType

@DimType

@DIMTYPE returns a dimension that matches the specified type.

DTP Type:

@DIMTYPE can be assigned to a DTP of type dimension, dimensions, or string.

Syntax:

@DIMTYPE(Dimension Type)

Parameter:

Parameter Description
Dimension Type Dimension types used in the application

Example:

[Dims]=@DIMTYPE(Account)

Where:

  • [Dims] is a DTP of type dimension that is not a checked prompt.

  • [Account] is selected from the drop down.

In this example, [Dims] returns "Account." If the Account dimension had been named Measures in the application, it would have returned "Measures."