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

@StartsWith

@STARTSWITH tests to see if the string starts with the specified prefix.

DTP Type:

@STARTSWITH can be assigned to a DTP of type boolean.

Syntax:

@STARTSWITH(String,Prefix)

Parameters:

Parameter Description
String Design-time prompt or text
Prefix Design-time prompt or text

Example:

[DTP_Start]=@STARTSWITH([Mbr1],[String1])

Where:

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

  • [String1] is a DTP of type string that is a checked prompt.

Assume that the following values are input:

  • [Mbr1]: "Joe Smith"

  • [String1]: "Smith"

In this example, [DTP_Start] returns "false."