Restoring the Out of Box artifacts for the EPBCS modules!

It happened that some of the module-based artifacts were missing/accidentally deleted and we were finding a way to restore them.

As a user of Oracle Enterprise Performance Budgeting and Planning Cloud Service (EPBCS), you may want to restore the out-of-box artifacts that were delivered with your EPBCS instance.

In this blog, we will see how to systematically restore artifacts related to the EPBCS module's process of restoring the out-of-box artifacts for the EPBCS modules.

Cube refresh failed with Essbase Cube: Cube Name, Error code: 1060374 - Fix/suggestion

A quick one that took a while to fix the issue, assuming it helps the needy.  

The customer was running on EPBCS on version latest version. While running the database refresh it did throw the following error message, 

Cube refresh failed with Essbase Cube: Cube Name,

List Backups via REST API for PBCS/EPBCS applications

The new REST API features enabled on April 22 are so cool, you can now access all the backups created by Oracle on your own without the need to raise an SR with Oracle support. I am referring to the Artifact Snapshot taken by Oracle when there is a change to the instance.

From the Oracle Documentation,

List Backups - Only for OCI (Gen 2) Environments

In OCI (Gen 2) environments, you can list available backup snapshots archived by Oracle in the Oracle Object Storage Cloud.

You can then restore available backup snapshots (copy them to the environment), To restore backup snapshots in OCI (Gen 2) environments, see Restore Backup. After copying the backup, you can archive it or use it to restore the current environment by yourself. After copying the backup, you can archive it or use it to restore the current environment by yourself. With the List Backups and Restore Backup APIs, you no longer have to create a service request to request a backup from an OCI environment.

This API is version v2.

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.

Migrating Data Maps between PBCS/EPBCS instances

Migrating Data Maps between PBCS/EPBCS instances

This is applicable only for the data maps created by the Admins/Users, Not for the system created ones like the following 

For the Custom-created Data Maps, you can migrate using LCM

Navigate to the Tools 

 

Under Migration, Go to the Core 

"Format code" in PBC/EPBC Calculation Manager

Its been a while I blogged due to my work schedule, but thought I will share this with all on a great handy option that surprised me.

 It’s the “Format Code” in the Calculation Manager. This is the definition from the document When you Format Code, the lines of the script are grouped together and are indented, and blank lines are removed. 

To explain how this works this is my code written before formatting the code,

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.