1. Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
  2. Designing Business Rules
  3. Creating a Groovy Business Rule
  4. Creating a Groovy Business Rule for ASO Cubes

Creating a Groovy Business Rule for ASO Cubes

You can create a Groovy business rule for a ASO cube.

  1. In System View, right-click Rules, then select New, and then enter the information in the New Rule dialog box.

  2. Change to Script mode by clicking the arrow next to Designer, and then selecting Edit Script.

    If you select Edit Script on a graphical rule, the script designer opens and the rule is blank. Close and reopen the rule, and the rule will open again in graphical. If you save the rule in Edit Script, the rule will be empty.

  3. Enter the Groovy script, and then save, validate, and deploy the rule to your application.

Note:

Groovy business rules for ASO cubes support all variables with run time prompts (RTPs).

Note:

When designing groovy rules, add this reference header at the top of the Groovy script:

/*RTPS: */

If you reference Runtime Prompts (RPTs), add the Runtime Prompts to the reference header as follows:

/*RTPS: {rtp1}, {rtp2} */

For example, if you had two variables named rtpYear and rtpScenario, the reference header at the top of the script would be

/* RTPS:{rtpYear}, {rtpScenario} */

For more information, see Class RtpValue.