What is changing in EPM Cloud from Jan 2021 – Part 1

 

This blog will cover the important changes effective from Jan or later in 2021, I will share this again….

 

REDWOOD USER EXPERIENCE

As part of the new Redwood experience, we are introducing the Dynamic Tabs feature only within the Redwood theme in the 21.02 update. Dynamic Tabs will allow you to open tabs on the fly, both from a list view or from an existing navigation flow tab to perform related actions. Some use case examples: view drill through from a form in a new temporary tab; view a form in design mode; open Web ad hoc from a form or dashboard; open forms from right-click menus; open dimensions on the fly to view how members are calculated.

"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,

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 ( ). 

Oracle Enterprise Performance Management Cloud June 2020 update part 1

I want to highlight the June 2020 new updates for the Oracle Enterprise Performance Management in this blog, yes I will be stressing on the REST API and the Groovy 😊

All the common new updates across are listed below, and I would handpick my favorites here...

EPM INTEGRATION AGENT - My Presentation

Inspirage Webinar on Epm integration agent

My presentation

Inspirage Webinar on Epm integration agent from Dayalan Punniyamoorthy

ODTUG Learn from Home S E R I E S-Automating Security Management in PBCS!

Due to COVID -19, my KSCOPE 20 session was canceled. But the session was added to ODTUG Learn from Home S E R I E S-Automating Security Management in PBCS!

For those who couldn't attend I am uploading my presentation for your reference.

ODTUG Learn from Home S E R I E S-Automating Security Management in PBCS! from Dayalan Punniyamoorthy

Happy days on the cloud!!!

Why its important to run the EPM Automate upgrade!

Downloading EPM Automate from the PBC/EPBC/EDMCS is not always the latest!

This came as a surprise while trying to install EPM Automate from the Oracle Enterprise Data Management Cloud (EDMCS) pod and trying out a command. It said the command not found

C:\Oracle\EPM Automate\bin>epmautomate importDimension FinPlan 'Cost Center' Merge EPM_Cost_Center_20200323.csv

EPMAT-7:"importDimension" is not an epmautomate command. See "epmautomate help".

The most similar commands are importmapping, importrates, importsnapshot, importbalances, importtemplate.

It said  EPMAT-7:"importDimension" is not an epmautomate command. See "epmautomate help".

So the one downloaded straight from the cloud instance is not the latest and we need to run the “upgrade” before executing any commands or if you happen to see the words IS NOT A EPM AUTOMATE COMMAND

Happy days ahead on the cloud!!

PBCS-DataManagement-Delete-Entire-Integration!!!

Everyone wants to be smarter rather than a hard worker, and one tip today to make you smarter is the DeleteIntegration

You can delete an integration including the name, import format, location, mappings and any data rules created in Data Integration. This option enables you to delete an entire integration without having to delete individual components.

We all have come across a situation to delete a Data load Rule, Import Format or the Location and since they all tied to each other its difficult at times to deal with these errors messages, 

Well that is where the Delete Integration comes handy as a lifesaver

You can delete an integration including the name, import format, location, mappings and any data rules created in Data Integration. This option enables you to delete an entire integration without having to delete individual components.