-
EPM GROOVY – How to Perform On The Fly Webform Level Custom Calculations Before Saving the Form
The majority of us executes groovy rules in ‘Run Before Save’ operation to check if user-entered data fits all of the validation requirements. If the data does not meet the conditions, we have the option to cancel the ‘Save’ action. We’ll utilize the same “Run Before Save” groovy business rules and perform simple calculations on…
/
-
EPM GROOVY – Validate Data Files To Identify Unknown Members Before Loading It in Oracle Planning From The Calculation Manager
Without uploading the data into the system, there are few methods for validating the data file to see if all of its records are going to be loaded or not without rejections. This type of validation is frequently carried out on a local server by comparing members to downloaded meta data csv files. I’d want…
/
-
EPM GROOVY – Renaming Members in Bulk: A Guide to Using CSV Files with Calculation Manager
We don’t have many choices for renaming many members at once. One common use case is when the source system decides to change the prefix of members, renaming all of the members becomes a challenge in a fully data loaded plan types. Here’s how groovy can help you solve the problem. RENAME MEMBERS I am…
/
-
EPM GROOVY – Run Multiple Calculation Manager Rules and Send HTML Email Summaries
This is a more in-depth look at how to use REST APIs to send emails from Calculations Manager. Please go to the send email post before reading any further if you are not sure how its done. I experienced an issue while sending an email from Calculation Manager; whenever a special character or multi-lines appear…
/
-
EPM GROOVY – Custom Data Export, Transformation, and Import in EPBCS without Data Management
Thanks to the latest addition of export and import data functions in the Groovy EPM package, we can now export, transform, and load data in any EPBCS application. This, like Data Maps and Data Management, is a privileged function that only administrators can use. As we all know, there are a variety of ways to…
/
-
EPM GROOVY – Perform Focused Calculations Based on User Selection Rows/ Cells in Web Forms
EPM Groovy’s focused calculations based on the edited cells from the web forms are one of the most utilized features so far. But for focused calculation to work, the cells need to be edited so that groovy can identify the members for which it needs to execute the calculation. Oracle has recently provided an option…
/
-
EPM GROOVY – How to Create Custom Files in EPM Inbox from Calculation Manager
Due to job console output limits, one of the primary issues consultants experience is not being able to print the whole script which is sent back to Essbase execution. Some of us are already using alternative techniques to obtain the complete code, such as emailing the entire script to email using REST APIs, and uploading…
/
-
EPM GROOVY – Capturing User Edited Rows for Dynamic and Focused Calculation Processing
This is one of the first ever features, and it’s frequently utilized in most Hybrid Business Rules ( Groovy + Business Rule ) to collect the edited members from the form and execute the calculation exclusively to them. We create a Set and capture all the changed cells as shown below to collect only one…
/