Oracle Cloud EPM: Groovy Scripting (3 days)

Image

HOME | TRAINING COURSES

How Can I Take this Course?

Keyteach provides flexible training options to suit your needs. Choose from globally scheduled instructor-led courses or private classes for your team.

Would you like to arrange a private class for your team?

Keyteach provides the flexibility to deliver this instructor-led course on dates that suit your team’s schedule. Private classes, conducted live online with a remote instructor, require a minimum of two participants. Alternatively, we can arrange in-person training at your location upon request.

  • Oracle Cloud EPM: Groovy Scripting Private Instructor-Led Training for Your Team   US $2,880.00 per person (min 3 attendees)

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.

Audience

  • System Administrators
  • Implementation Consultants
  • Developers

Duration

  • Instructor-led training: 3 days (21 CPE Credits)

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, this course focuses on automation and integration activities and attendees will learn 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 Cloud EPM Planning (E/PBCS).

Learning Objectives

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
  • Identify the process for making external connections via scripts
  • Explore the execution of EPM Automate commands via business rules
  • Evaluate various methods for extracting and moving data slices between environments

Summary by Day

  • Day 1 - Groovy fundamentals, data types, syntax, creating Groovy Rules, development environment, Groovy Rules Java APIs, Cube Interface, Data Grid Interface.
  • Day 2 - Working with Grids, Iterators, Changing Cell Colours, Data Grid Builder, Validation Rules, Working with Data, Working with Metatdata.
  • Day 3 - Performance Enhancements, Focused Calc Scripts, Focused Aggregation, Focused Smart Pushes, Monitoring Performance, Using Groovy to Interact with the REST APIs. Creating external connections and building custom integrations.

Course Agenda

Groovy Fundamentals:

Explore the fundamentals that underpin the Groovy scripting language, from declaring and assigning variables to setting up a local development environment, helping to prepare and validate your code.

- Groovy Basics

- Data Types

- Syntax Introduction

- Use Cases in EPBCS

- Creating and Managing Groovy Rules

- Setting up a Local Development Environment

Exploring the Groovy Rules Java APIs:

Discover how the Java API allows Groovy Rules to leverage the syntax and powers of the EPM Groovy object model.

- The EpmScript Class

- The Operation Class

- The Application Class

- The Cube Interface

- The Data Grid Interface

Working with Grids:

Augment the end user experience by using Groovy to add interface enhancements, such as rich validations or more useful and detailed log messages.

- Iterators

- Changing Cell Colors

- Altering Values

- Log Messages

- DataGridBuilder

- Validation Rules

Working with Data:

Review how the available helper classes can be used to prepare on-screen data dynamically and how detailed validations can be added to prompts.

- DataGridDefinitionBuilder

- Run Time Prompts

Working with Metadata:

Discover how Groovy Rules can be used to interact with an application’s metadata, allowing adjustments to be made to an application on a dynamic and intelligent basis.

- Adding Members

- Renaming Members

- Moving Members

- Changing Member Properties

Improving Performance:

Learn how Groovy can be used to significantly improve the performance of routines beyond what is possible with traditional business rules.

- Generating Focused Calc Scripts

- Focused Aggregation

- Focused Smart Pushes

- Monitoring Performance

Additional Topics:

This section focuses specifically on automation and integration activities, such as retrieving external datasets, creating automation routines for common administration and maintenance activities and building custom integrations, allowing data to be moved quickly, securely and reliably between environments.

- Using Groovy to Interact with REST APIs

- Making external connections via scripts

- Execution of EPM Automate commands via business rules

- Learn scripting methods for extracting and moving data slices between environments

National Association of State Boards of Accountancy (NASBA)

Image
  • Course title: Oracle Cloud EPM: Groovy Scripting
  • Duration: 3 days
  • Audience: System Administrators | Implementation Consultants | Developers
  • Pre-requisites: None
  • Delivery method: Group Live, Group Internet-Based
  • Advanced preparation: None
  • Group Live and Group Internet-Based: 21 credits - computer software and applications
  • Programme level: Intermediate

Keyteach is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. Registration ID No 115820. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Any complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org

KEYTEACH