Duration

3 days (21 CPE credits)

Audience

Implementation consultants, developers, system administrators 

Course Summary

By the end of this course you will be able to enhance the potential of Oracle's Enterprise EPM Cloud applications through the use of intelligent and dynamic Groovy Rules. Discover how to use Groovy Rule’s to generate code dynamically at runtime, enabling more targeted and faster executing calculations. Examine how to enrich the user experience, simplifying complex processes and providing increased visibility by way of interactive on-screen validation.

How Can I Take this Course? 

You can search for scheduled course dates for your time zone or request a private class for your team:

Learning Objectives

By the end of this course learners will be able to:

• Recognize the fundamental concepts relating to the Groovy scripting language
• Identify the ways in which Groovy rules can be created, maintained and utilized in the application
• Explain how pure Groovy rules can be used to interact with interface elements, such as data grids and run-time prompts
• Describe how Groovy rules can be used to generate Essbase calculation scripts dynamically, allowing for more flexibility in standard calculations
• Ascertain how to look up information and troubleshoot by exploring the Java API reference for Groovy Rules
• Recall how connections can be made to external resources, including the application’s REST APIs, facilitating broader processes in Groovy rules

Course Description

Groovy is an object-oriented programming language for the Java platform that can be used to enhance the calculation capabilities of Oracle's Enterprise EPM Cloud subscriptions. For those familiar with developing traditional business rules, you'll recognize that Groovy Rules can be managed in a similar way in that they are created in Calculation Manager and are deployed, validated, and executed in an EPM Cloud application. Groovy Rules provide a wealth of potential improvements over the traditional approach however, allowing you to address scenarios that normal business rules can't solve.

This three-day course focuses on the broad use-cases for the Groovy offering and explores how its extended capabilities can be used to both improve the performance of an application and offer an enhanced user experience. One such example is that Groovy rules can execute focused calculations that are based on the cell-level points of view that a user is directly working with. This can lead to faster calculations and quicker availability of data in ASO reporting cubes. Another example is that Groovy Rules can interact with elements of the user interface, providing messages, validations and a host of other improvements for users. This allows you to make processes more robust, by providing highly visible validation criteria, real-time feedback to users and preventing erroneous values from being saved.

In this course, we’ll explore the fundamentals of Groovy scripting for the Oracle EPM Cloud, from an introduction to syntax and setting up a development environment through to writing complex scripts that enhance and improve an application. We’ll investigate the Groovy Rules Java APIs and explore working with it's broad capabilities, from data load and metadata management tasks, through to dynamic run-time on-demand rule generation. Additionally, attendees will explore how Groovy Rules can interact with the available REST APIs, allowing you to embed a host of additional non-calculation functionality into a rule or ruleset.

The hands-on exercises for this training are undertaken with Oracle's Planning Cloud (E/PBCS).

Scheduled Course Dates

Course title: Groovy Scripting for Oracle Enterprise EPM Cloud - 3 days

Duration: 3 days

Audience: System administrators, developers and implementation consultants

Pre-requisites: Knowledge of Oracle Planning Cloud system administration

Delivery method: Group Live and Group Internet-Based

Advanced preparation: None

Recommended CPE credits: 21 credits - computer software and applications

Programme level: Intermediate