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. @Concat

@Concat

@CONCAT concatenates the second parameter to the end of the first parameter.

DTP Type:

@CONCAT can be assigned to a DTP of type member, dimension, string, restricted list, password, or attribute.

Syntax:

@CONCAT(Text, Concat String, Seperator)

Parameters:

Parameter Description
Text Design-time prompt or text
Concat String Design-time prompt or text

Note: concatString will be added to the end of String
Seperator Optional: If a separator is used, then the separator is added between the Text and Concat String only if Text has a value.

Example:

[DTP_CTmbr]=@CONCAT([MBR1],[MBR2])

Where:

  • [DTP_CTmbr] is a DTP of type member that is not a checked prompt.

  • [MBR1]="California"

  • [MBR2]="Washington"

In this example, [DTP_CTmbr] returns "CaliforniaWashington".