Month and Year dimensions play a major role in most of the calculations. If it is a single-year app, it is easier to handle the month and year ranges inside our fix statements, but when it comes to multiple-year planning or forecasting, it is required to have multiple IF conditions inside FIX statements. These additional…
If you’ve been working with EPBCS recently, you may have all encountered the problem of a frozen screen when users attempted to update a new user variable value using the user preference window. This has been fixed now using a recent patch. But I hope it’s good to have a solution where the system prepopulates…
Java and Groovy both offer a wide range of options for creating, parsing, converting, and comparing date objects, which helps to address a number of use cases. The issue in EPM is that we either directly access the month and year values from the Scenario start end end period objects or save them in the…
A powerful method named getEvaluatedMembers() can be used in a Groovy business rule to fetch members from the system depending on various relationships to the current member. We can retrieve members based on below conditions. There aren’t a lot of resources available right now. I therefore decided to make a cheat sheet for quick reference.…
Recently, a very typical request from business asking for the YTD data export to a file for an external integration. Although it seemed like a very simple request, the challenges we ran into are described below. We have decided to try with two options: Because I hadn’t yet looked at Groovy’s transformer function, we went…
When calculating simple formulas at the form level, formula rows and columns prove to be very helpful. I haven’t implemented formula rows or columns in my previous implementation in a few years. Using groovy rules, we can modify “any” data fields after the form has loaded thanks to the “Run After Load” functionality. Whether it…
I’ve been curious about how easy it was to use externally fully trained ML models in planning apps ever since Oracle released Bring Your Own Machine Learning in EPM. For those who have no past experience with Machine Learning, Given the massive knowledge base already available on the internet, getting started is pretty simple. ML…
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…