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.

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.

 

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.

Automating Security Management in PBCS! from Dayalan Punniyamoorthy

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.

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.

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.