Module Overview

Groovy for Oracle EPM Cloud

Enroll ($1,599) Bundle And Save 20% Step Up to All Things Groovy to Save $700

This class is designed to be self-paced and will give participants everything they need to know about Groovy to build complex solutions. Everyone will leave with the knowledge of reading and understanding the Java Docs, enabling them to expand their abilities as enhancements are released.

Whether you have experience or not, this course will move you to be an independent creative solutions provider with Groovy.

Module Summary

Module Estimated time
Introduction Video 0:30
Module 1
Introduction to Groovy and writing your first Groovy calculation		 Module 0:45
Lab 0:45
Module 2
Creating Groovy variables and collections		 Module 1:15
Lab 0:60
Module 3
Looping through a Data Form and manipulating Groovy collections		 Module 1:15
Lab 0:60
Module 4
Using Groovy strings to create a dynamic Essbase calculation		 Module 1:15
Lab 1:30
Module 5
Manipulating lists and maps to efficiently execute jobs, Data Maps, and Smart Pushes.  Scripts using the Job Factory and isolating only edited data are included.  Scripts included:

  • Clear stored members
  • Update member properties
  • Validate the addition of members
  • Build Essbase script dynamically from the
    edited combinations (rows/columns)
 Module 1:25
Lab 1:30
Module 6
Using Groovy variables and validating user input.  Validations include form input, RTP input, and the reuse of error messages in multiple languages.  Scripts include:

  • Handle numeric validation with precision
  • Cell-level validation
 Module 1:15
Lab 1:30
Module 7
Building advanced user input validation rules with regular expressions.  Scripts included:

  • Validating form data against data not on the form
  • Validating against metadata
  • Transferring multiple people simultaneously
 Module 0:45
Lab 1:30
Module 8
Querying metadata and understanding the dimension, member, and rule classes.  Scripts included:

  • Filter metadata based on member properties (Time Balance, etc.)
  • Dynamically executing calculations based on the open and close periods/years without sub vars
  • Optimizing calculations using member properties
  • Apply security based on UDAs
  • Close project periods based on project start/end dates
  • Change member storage based on generation/level
  • Change member storage based on regular expressions
  • Export data with member properties and stored attributes in the export
 Module 1:15
Lab 2:00
Module 9
Introduction to Grid Builders		 Module 1:30
Lab 3:00
Module 10
Advanced Grid Builder concepts to move data between plan types		 Module 1:40
No Lab
Total Estimated Time 40 to 50
Hours

Module Format

Every module is organized in the same way, so those attending have a consistent and positive experience. They start with an introduction and a review of the module objectives. Every module includes instruction that covers both basic and advanced content in a way that is easy to understand for both the novice and the experienced. The modules include a narrated presentation of the material. The concepts are demonstrated with an application modeled after Best Buy* products, departments, and stores, and I apply the teachings to real-world scenarios. Each module concludes with reiterating the module objectives and gives the attendees exercises to complete to reinforce what was learned. Every module is supported by downloadable copies of every line of code that was discussed, as well as the answers to the learning labs when applicable.

Real-World Learning

When participants complete the modules, they will not only be capable of building end-to-end solutions with Groovy, they will also leave with critical information I have consolidated by using Groovy since its release. There are challenges I share that have taken me months to overcome. These include roadblocks developers encounter, from data precision issues using data grids to optimization techniques when calculating ASO plan types.