-
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…
/
-
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…
/
-
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…
/
-
EPM GROOVY – Sending Emails Directly from Business Rules (No Third-Party Required)
We have to deal with long-running rules when dealing with larger datasets, especially when it comes to data aggregation, data maps, and so on. The idea is to provide business rule executors the option of receiving or not receiving an email notification regarding the status of a business rule. Oracle includes a dedicated REST API…
/
-
EPM GROOVY- Performing MDX Calculations with Custom Groovy Scripts In ASO Cubes
I’ve been wanting to check out the new MDX custom calculation capability, which allows us to write MDX calculations directly in ASO cubes. Although the Groovy documentation only provides an example of a constant value assignment, it is possible to write more complex MDX calculations. Before constructing the MDX formula, there are a few factors to keep in mind. Writing Inventory Calculation MDX Interdependent values are heavily used in inventory calculations. This may be accomplished in BSO by forcing the calc to run in Cell mode (@CalcMode(Cell)). Let’s look at how we can use Groovy to convert the BSO calculation below into MDX code. Setting up the POV Pov, Source RegionPov, Source Region, and Script are the three mandatory fields to be specified for any MDX calculations written in ASO cubes with the CustomCalcParameters class. As usual, crossjoin is used to fix multiple dimension members in the POV. Since we have Groovy, I…
/
-
EPM GROOVY – A Guide to Member UDA Updates using Business Rules
The Groovy API provides a privileged function to update metadata properties using business rules. Since it’s a privileged function, only administrators are allowed to execute the same. Of late, I have been using the function to rename the members, change the parents, etc. This helps in many ways, as UDAs get a little better since…
/
-
EPM GROOVY – Setting Up Read-Only Planning Forms with Global Forms
This sounds more like controlling a specific product or entity read only from the planning unit hierarchy. This post is for those who don’t use planning unit hierarchy but use a webform to control whether planners are supposed to edit a certain product or entity during the planning cycle. Below is how groovy can help…
/
-
EPM GROOVY – A Guide to Pre-export Validation with Conditional Checks
I am sure most of us are familiar with the conventional data export from Essbase using the DATAEXPORT option. However, we cannot perform a precondition to export only the required data. But this doesn’t allow us to perform a conditional check to see whether we are exporting valid data or not. In short, we cannot…
/
-
EPM GROOVY – Top Down Planning in ASO Cubes
Although input at higher level intersections in ASO is not possible, the combination of groovy and EPM APIs helps us to achieve the same. Let us make use of instant aggregation in ASO along with groovy grids. Here is the link to the article I published on LinkedIn.- Click Here for full post.
/