Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« HAS HFM NOT REALLY MOVED TO CLOUD?? | Main | My experience with Form Development in HFM »

Run Oracle Hyperion Cloud Jobs on Autopilot!!! Using EPMAutomate

 

What is EPMAutomate?

EPMAutomate is an utility helps in automating administrator's activities by allowing remote access and perform tasks within Oracle Enterprise Performance Management Cloud instances. EPM Cloud includes EPBCS (Oracle Enterprise Planning and Budgeting Cloud), PBCS (Oracle Planning and Budgeting Cloud), PCMCS (Oracle Profitability and Cost Management Cloud), FCCS (Oracle Financial Consolidation and Close Cloud), ARC (Oracle Account Reconciliation Cloud), TRCS (Oracle Tax Reporting Cloud), and EPRCS (Oracle Enterprise Performance Reporting Cloud).

Why it is required?

As in On-premise Hyperion world, ex. we have Maxl editor or ESSCMD editor for carrying out administrator activity using Maxl scripts / ESSCMD scripts for Hyperion Essbase module. But in Hyperion cloud world, these editors are not available due to which an alternate way of administering cloud modules has been provided by Oracle using EPMAutomate utility. In a similar fashion, many cloud modules are compatible to adopt EPMAutomate utility for carrying out administrator processes.

What EPMAutomate utility can do?

EPM Automate Utility allows Service Administrators in automating most of repetitive tasks which includes below mentioned activities:


How it works?

  • In Windows

Batch script on project server needs to trigger which will contain EPMAutomate commands to do activities in cloud instance and after completing cloud activities, EPMAutomate utility will disconnects from cloud and control will be passed back to batch script.

  • In Linux

Shell script on project server needs to trigger which will contain EPMAutomate commands to do activities in cloud instance and after completing cloud activities, EPMAutomate utility will disconnects from cloud and control will be passed back to Shell script.

    

EPMAutomate scripts as a Reusable Artifacts?

Scripts created for automation could be re-utilized for different Hyperion cloud products. Ex. Backup automation for PBCS application in Windows as well as Linux can be utilized for other modules. Data Load scripts along with Data Management automation can also be re-utilized for different modules of different projects.

Operating System Supports and Limitations:

This utility is compatible with Windows as well Linux/UNIX Operating System and the setup can be downloaded from Simplified Interface

  • EPMAutomate utility works on 64-bit Operating Systems

  • Corporate SSO credentials cannot be used with EPMAutomate utility and end-user profile for using EPMAutomate required to be created in the cloud.

Comments

Dear Mayur,
Nice Article. Please keep sharing knowledge.
Regards
Sachin

Very informative blog about EPMAutomate. Looking forward to next post.

Regards
Anurag

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles