• |

    EPM GROOVY – How To Create Re-usable Custom Month and Year Ranges in Groovy

    Raja Stalvin

  • |

    EPM GROOVY – How to Transform Data Management Files Outside The Data Management Layer

    Raja Stalvin

  • |

    EPM GROOVY – How To Update User Variable Values Using a Groovy Business Rule

    Raja Stalvin

  • EPM GROOVY – Incremental Metadata Updates in EPBCS using Flat Files and Calculation Manager

    Comparing the metadata of multiple dimensions to source system flat files can be a time-consuming manual task, especially during the build phase of any EPM implementation. We’ll look at how to avoid manually comparing EPBCS exported metadata files with source system files just to find out the differences, as well as how to incrementally upload…

    Raja Stalvin

    /

  • EPM GROOVY – Custom Data Export, Transformation, and Import in EPBCS without Data Management

    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…

    Raja Stalvin

    /

  • EPM GROOVY – Perform Focused Calculations Based on User Selection Rows/ Cells in Web Forms

    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…

    Raja Stalvin

    /

  • EPM GROOVY – How to Create Custom Files in EPM Inbox from Calculation Manager

    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…

    Raja Stalvin

    /

  • EPM GROOVY – Capturing User Edited Rows for Dynamic and Focused Calculation Processing

    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…

    Raja Stalvin

    /

  • EPM GROOVY – A Guide to Custom Scripting for Partial Data Clearing in ASO Cubes

    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…

    Raja Stalvin

    /

  • EPM GROOVY – Pushing Web Form Data Updates Across Multiple Instances

    UPDATE : Cross Platform SmartPush Data push is available in the DataMaps The purpose is to push data using a webform attached business rule that captures the edited rows and pushes data to a different EPBCS instance.  Within the application, the calculation manager has multiple options, including data map, smart push, and DataGridBuilder. The REST…

    Raja Stalvin

    /

  • EPM GROOVY – How to Capture Failed Jobs from Console to CSV Files

    The EPBCS REST API provides the option to export all the job details to csv files. This is more helpful for consultants who support the application or for service admins who would like to see the summary of failed jobs in a csv file. I wanted to give it a try and explore this feature. We…

    Raja Stalvin

    /