This was a key feature that had been absent from the start of the REST API operations using groovy. Currently, when a planner performs a REST job, it executes so without using the planner’s access and instead uses the user id (Admin Access) that is linked with the REST Connection. This helps us most of…
I’ve been curious about how easy it was to use externally fully trained ML models in planning apps ever since Oracle released Bring Your Own Machine Learning in EPM. For those who have no past experience with Machine Learning, Given the massive knowledge base already available on the internet, getting started is pretty simple. ML…
The majority of us executes groovy rules in ‘Run Before Save’ operation to check if user-entered data fits all of the validation requirements. If the data does not meet the conditions, we have the option to cancel the ‘Save’ action. We’ll utilize the same “Run Before Save” groovy business rules and perform simple calculations on…
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…
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…
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…
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…
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…
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…