Automation PowerShell Script to invoke EPM Automate commands!

Lets have a detailed walkthrough of the PowerShell script detailing its purpose and functionality. The script is designed to perform several tasks: logging into the EPM, run the Data Management Integration rule, download the generated extract created by the integration rule, download the data file & then logout from the EPM instance.

Oracle Enterprise Performance Management Cloud June 2020 update part 2

This is in continuation of Part 1 series of the June 2020 new updates for the Oracle Enterprise Performance Management.

Quick one today is the sortMember

Image courtesy https://www.computerhope.com/unix/usort.htm 

Sorts members of Entity, Account, Scenario, and Versions dimensions and of custom dimensions. This command is useful for sorting dimension members after loading members into Planning.

Note:

You cannot use this command to sort members of Period, Years, and Currency dimensions.

 This command works only for Planning.

EPM AUTOMATE Login issue - password with ()

A quick tip on a Sunday afternoon, I was trying to login to the EPM AUTOMATE using the login command and it was failing.

I did notice that my password contains open and closed braces ( ). 

NEW EPM AUTOMATE UTILITY - Oracle PBC July 2018 update

A new version of the EPM Automate Utility is available with this update. This version includes the copyfilefrominstance command, which copies a file from a source environment to the environment (target) from which you run the command.

This version also includes changes to the following commands to make them consistent with other file operation commands:

• listfiles: now lists snapshots and files available in an environment 
• deletefile: now deletes snapshots and files from an environment

You can download  the file from the PBC instance

And get that downloaded for the Windows or Linux

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.

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

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.

What does EPM Automate Utility offer - Part 4

In this series lets see how to read a file and strip a particular value from a column of a CSV file and use that value in the EPM automate script.

Requirement:

Every month the pay details are extracted from the source system and the data file is loaded into the PBCS, to get this automated the file name should be named as MMM-YY (Pay month and year format).

Let us explore how this is achieved using the EPM  automate.

What does EPM Automate Utility offer - Part 3

After the EPM automate serious 1 & 2 let me cover downloading the latest exported file & logs related to a specific Data export job.

Currently we don’t have a specific command to download the latest exported file and when you run a export data command it prefix the job id ad the end and created the export file.

Let’s see how to download the latest file or the latest log file using EPM automate