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…
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…
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…
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…
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’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…
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…
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…
Most of the information in this post will be redundant for people who started working with Essbase prior to the cloud era. The Groovy API provides a mechanism for clearing partial data in ASO straight from Calculation Manager using the Groovy API. Two parameters must be given. Logical Clear Vs Physical Clear The data is…