Same Member for both Input and Calculated value? You might be wondering why someone would want to combine a calculated value and an input value within the same data member. While this isn’t a common request in every implementation, it’s something I’ve encountered and addressed in my past experience. To explain this, let’s explore a…
This is not my regular Groovy post. Instead, I want to focus on a simple function we use every single day in our planning applications and how we can really push its boundaries, customizing it to fit our specific needs. Accessing prior or next member data is absolutely essential in almost any application. Think about…
Skip Update? Really? After a 4-month hiatus from blogging, I’m back with a question. Why am I writing about the Skip Update feature in Oracle EPM, which can be easily managed by EPM Automate? This year, Oracle stopped HTTP requests and access to port 9000, so we had to delay the update to the instance.…
Dynamic Member creation is one of the cool features of Oracle Planning. Those who understand how Planning interacts with Essbase would much appreciate how helpful this feature is. This helps to achieve two things: How does it work? The core idea is that if you create a parent member with the dynamic member enabled, it…
Most of the time all we do with EPM Groovy business rule is to fetch the members from the form and use those members in the fix and trigger the business rule. This seems like an essential thing to do that saves time for the business users, but in order to do that we have…
For those already familiar with Oracle EPM integration, you’ll know it provides a built-in file archiving process. Essentially, after your file is loaded by Data Management, the archival process creates a copy for future reference during debugging or auditing. Built-in Archival Process: Lets see the options: Lets look into the system settings: How to Access…
Beyond Static FIXes One of the first features of EPM Groovy was focused calculations using dynamic fixes. we’ve relied on dynamic fixes based on edited or selected members/rows. Now, we’ll explore a new approach: understanding the currently edited form and dynamically adjusting calculation regions based on the form name. Typically, EPM business rules fall into…
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…
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…
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…