Dayalan Punniyamoorthy Blog

Showing posts with label Groovy with REST API. Show all posts
Showing posts with label Groovy with REST API. Show all posts

Monday, May 6, 2024

Multiple Rules of Enterprise Profitability and Cost Management (EPCM) using Groovy in Sequential Manner!

In this blog we will see how to run multiple Rules of Enterprise Profitability and Cost Management (EPCM) using Groovy in Sequential and proceed with the next rule only after completion the previous rule.











 

/**************************************************************************************/

/*                  Run IC Calcs All Region                                                                     */

/*                  Creation Date       : 10th Apr 2024                                                  */

/*                  Version                   : 1.0                                                                    */

/*                  Modifications         :                                                                        */

/*       The Rule uses the Sub Var &CurMth, &CurYr.                                          */

/*  The Rule will be executing the following,                                                     */

/*       1. Clear for EMEA                                                                                          */

/*        2. Clear for APAC                                                                                         */

/*        3. Clear for Americas                                                                                   */

/*       4. Merge Slices                                                                                         */

/*       5. Run Ruleset Ranges:                                                                            */

/*                  Start   End                                                                                      */

/*                  1            999                                                                                   */

/**************************************************************************************/

connectionName is a variable that stores the name of the connection to the server. In this case, it's set to 'Localhost'. This variable is later used to specify which server to connect to when making HTTP requests. 

def connectionName = 'Localhost'

Closure subVarValue = { String subVar -> operation.application.getSubstitutionVariable(subVar).value }

String CurYr = subVarValue('CurYr')

String CurMth = subVarValue('CurMth')

println "The Rule is using the Sub Var Current Year : " +CurYr +" " + "Current Month : " +CurMth

Monday, September 5, 2022

Invoking REST API via Groovy program outside of EPM Cloud – Authentication to EPM Cloud Part-2



This post is the continuation of the previous one where I explained how to read the User ID, Password, etc.. from a file in the Groovy Program. So the file containing the  User ID, Password, etc.. is a central repository where you need to change it only once.

In this post, I will extend that feature by using the encoding/decoding methods to encode the password and decode it wherever needed. So the password Is not exposed anywhere and no security breach of storing the password in a file or a program.

Let me divide this post into two parts

  1. Encode the Oracle EPM authenticating Password using a Secret Key.

Kindly note I have used the AES encryption algorithm to encrypt the password.

 

Saturday, August 27, 2022

Invoking REST API via Groovy program outside of EPM Cloud – Authentication to EPM Cloud

In this blog, we will see how to invoke the Oracle EPM REST API endpoints outside of Oracle EPM (as a standalone program accessing the REST API endpoints from any machine where the Groovy program can be executed). We all knew we can call Oracle EPM REST API endpoints from the Calculation Manager Business rules as Groovy rules but this is entirely different from that.

 

Sunday, February 20, 2022

KSCOPE 21 - Takeaways and programs/code used in my presentation - Part 1

Welcome back to my Blog. Hope you find this one useful & informative.

I did present this topic in KSCOPE 21 -  and as promised during the session will be posting all the programs and the code that is used during the presentation.

In this post, I will post the EPM Automate program and the Groovy Program to automate security management.

Also, you could find my presentation here.



Wednesday, December 29, 2021

Running Data Management rules using REST API (PBCS/EPBCS)

REST API allows running the Data Management rules using the following two job type methods

  • DATARULE
  • INTEGRATION
DATARULE - is an older method for running the Data Management whereas INTEGRATION is the updated version of DATARULE method.

In this blog let's see how to invoke a Data Management rule using the INTEGRATION method using Postman.

Thursday, March 15, 2018

Explore DataManagement REST API - Oracle PBCS/EPBCS with Groovy flavor !!!


In continuation of other series about REST API on Planning ,Migration & User Reports in this post let’s explore the REST APIs for DataManagement to run data rules, run batches, import and export data mapping, and to execute reports. 


To begin let's explore groovy program to get the DataManagement apiVersion details and the Output below

1.DataManagement apiVersion Details



Monday, February 26, 2018

Explore User Reports & Daily Maint REST API - Oracle PBCS with Groovy flavor !!!


In continuation of other series about REST API on Planning & Migration in this post let’s explore the REST APIs for Provision Reports,User Audit reports and the Daily Maintenance Window Time. 

1.REST API for running Provision report on Oracle PBCS\EPBCS

Straight from the document:
Generates a provisioning report of users in the system and writes the report to the filename provided. This is an asynchronous job and uses the job status URI to determine if the operation is complete.

You can manually generate a Provision Report from Oracle PBCS instance
 Navigate -> Tools

Wednesday, November 29, 2017

Explore Migration REST API - Oracle PBCS with Groovy flavor !!!

I hope you have enjoyed the Introduction and the Planning REST API posts which were posted earlier. Lets explore the Migration related REST API for the Oracle PBCS in this post.




Migration REST APIs


Use the Migration REST APIs to get API versions, work with files, and manage
services and application snapshots.

Friday, October 13, 2017

Explore Planning REST API - Oracle PBCS with Groovy flavor !!!

After the introduction to the REST API & Groovy lets explore the Planning REST API in this post.

1. Get REST API version for Planning

Returns information about which versions are available and supported. Multiple versions might be supported simultaneously by Oracle Hyperion Planning.

This is already covered but lets see how to get the apiVersion details using Groovy.

Output of the program

Monday, September 11, 2017

Finally REST(REST API) on Oracle PBCS!!!

This was a lying in my draft for a quite long time after my webinar on this topic, finally publishing it :-)  have fun.

The complete documentation for the REST API for Oracle EPM Cloud is here

Straight from document:

REST describes any simple interface that transmits data over a standardized interface (such as HTTP) without an additional messaging layer, such as SOAP. REST provides a set of design rules for creating stateless services that are viewed as resources, or sources of specific information, and can be identified by their unique URIs. RESTful web services are services that are built according to REST principles and, as such, are designed to work well on the web. Typically, RESTful web services are built on the HTTP protocol and implement operations that map to the common HTTP methods, such as GET, POST, PUT, and DELETE to retrieve, create, update, and delete resources, respectively. 

REST API Methods

You can create, view, update, or delete Oracle Enterprise Performance Management
Cloud resources using standard HTTP method requests, as shown below
Method
Description
GET
Retrieve information about the REST API resource
POST
Create a REST API resource
PUT
Update a REST API resource
DELETE
Delete a REST API resource or related component

Current REST API Version

Covering only majorly used components
REST Resource REST API version Getting REST API Versions
     Planning
v3
/HyperionPlanning/rest/ 
     Migration
11.1.2.3.600
/interop/rest/ 
Data Management
V1
/aif/rest/

There are multiple REST API clients available for free, you can pick as per your choice.

Tuesday, August 20, 2013

Just about me

This is Dayalan Punniyamoorthy and I am passionate about the Oracle EPM suite of products. I did start my career with Brio aka Hyperion Interactive Reporting in 2006. Until now from 2006 I did acquire knowledge on multiple Oracle Hyperion EPM suites of products. In this blog, I will post my findings and the learnings I feel helpful to others who are using the Oracle Hyperion EPM Suite of products.

Keep visiting if you find my blog useful.

I can be reached by Twitter @Pdayalan

Via Linkedin - https://www.linkedin.com/in/dayalanpunniyamoorthy/

Thanks for your time.

Dayalan P.