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 BSO Cubes

Creating a Groovy Business Rule for BSO Cubes

You can create a Groovy business rule for a BSO 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.

  3. In the top right corner of the script editor, click the arrow next to Script Type, and then select Groovy Script.

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

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.