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…
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…
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…
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…
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…
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…