-
EPM Groovy – Beyond Reporting: Empowering ASO with Dynamic Calculations through Groovy
Groovy APIs and Edited Cells Since Groovy APIs introduced access to edited cells, there has been significant adoption for using it in form-based business rules. Unsurprisingly, with all calculations written in BSO cubes, FIXes were dynamically updated using Groovy business rules. But what about ASO cubes? ASO Cubes Step Up ASO cubes were traditionally used…
/
-
EPM GROOVY – Simplifying Server-side EPM Automate Scripting: Utilizing EPM Connection Manager for Secure Credentials
Secure Your Server-side EPM Automate with Encrypted Files Server-side EPM Automate has become a powerhouse for streamlining administrative tasks, but just like its client-side counterpart, it faces the critical challenge of secure connection establishment to Cloud EPM applications. Traditionally, this has been achieved through two methods: password strings and encrypted password files. While both serve…
/
-
EPM CALC MANAGER – CalcMgrLogMessageTrace Function: A Swiss Army Knife for Business Rule Functions Learning, Creation, and Debugging
In the world of business rule development, finding tools designed specifically for our needs can feel like a rare treat. Groovy offers script debugging with console logs, but what about regular business rules? Calculation Manager’s debug mode has its limitations, especially when functions get complex. Recently, I discovered a game-changer: the @CalcMgrLogMessageTrace function. It’s unlocked…
/
-
EPM GROOVY – How To Compress A Text File With Groovy For Email Attachments And Faster Data Transfers
SEND EMAIL FEATURE both server-side and client-side EPM Automate supports the sendmail command to send custom email notifications to users. This is commonly used to summarize the tasks from scheduled jobs and inform system administrators of the job status PIPELINE IS AN AWESOME ADDITION With the new pipeline feature, which sends a well-formatted email with…
/
-
EPM GROOVY – EPM Speaks many Languages: How We Handle Multilingual Error messages from scripting layer
While Oracle EPM boasts global reach and multilingual capabilities, English often dominates its error messages. This leaves non-English speaking users frustrated and confused. Thankfully, the EPM Groovy era empowers us to create internationalized error messages using Groovy! This ensures every user, regardless of language, receives clear and helpful prompts, ultimately leading to a smoother and…
/
-
EPM GROOVY – Add Entries to Smartlists Dynamically (No, Not from hierarchies)
Smart List drop-downs are used to select predefined values in a data form. They are typically associated with a member. If the number of entries is expected to grow, a hierarchy-driven Smart List can be used. This will automatically update the list of entries as the number of members in the hierarchy increases. However, an…
/
-
EPM GROOVY – Writing a Grid-Spread Groovy Script That Works With Any Planning Application Without Any Modification
A few years ago, I worked in an ASO cube that allowed user input at the parent level. That was probably one of my first blog articles. I recently worked on an application where we had to allocate values to lower levels after they were entered in a form at the parent level. What if…
/
-
EPM GROOVY – How To Create Re-usable Custom Month and Year Ranges in Groovy
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…
/
-
EPM GROOVY – How to Transform Data Management Files Outside The Data Management Layer
Using EPM Groovy, I was able to transform a >600 MB data file with 34 columns and more than 1 million rows in under 35 seconds (only transformation). Let’s explore how Server-side EPM Automate, CSV Iterator, and CSV Writer may be used to modify a huge data management file. The data file transformation is carried…
/