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.

Exporting and importing data in OAC!

For one of the OAC (Oracle analytics Cloud) customer need to export the data from an existing OAC Essbase application and need to load that data to a new OAC Essbase applications.

There are multiple ways we can export the data from an existing OAC Essbase applications, but since the amount of data it has so huge we chose to export the data using the  Essbase web interface, on the Applications page, expand the application, and select the respective cube

• From the Actions menu, select Export to Excel.
• On the Export To Excel dialog box, select the Parent-Child Export Build Method.
• Select Export Data and click OK

It will export the complete application in a Excel sheet, on opening you will find different sheets for each dimension and a tab for the data.

As i said since  the application contains lot of data this is what it says when you look under the sheet for data,

As it says it creates a .zip file for the data under Files. The interesting factor about the data file is it creates a column for each dimension and in our case we have multiple "Scenarios" as follows

When looked at the data exported file 

Its listing all the Scenario members with starting and ending with "Scenario"

So i deleted the "Scenario" and made the header as a single row which will allow me to create a rule file and load the extracted data file as it is. 

So i did change the headers as follows

Hope this was useful, Happy days ahead with Cloud!!!!!!

New Groovy Training Available from Oracle!!!!

Wow i just saw this and cant help myself in advertising this, now we have the OBE (oracle by example) for the GROOOOOOOVYYYYYYYYY yahhhhhh enjoy...

Introduction to Groovy Business Rules
Learn about the Groovy scripting language and see how to create a Groovy script in Oracle Enterprise Planning Cloud.

Working with Data Grids and Iterators in Groovy
Implement Groovy scripts to work with data grids and data grid iterators. You use conditional logic to set the background colors in a data grid, implement performance benchmarking, and set default data values in a grid.

Moving Dimension Members with Groovy
Create a Groovy script to work with metadata, in this case, moving a member from one parent to another.

Moving Modified Data Using Groovy and Smart Push
Push data from a source location to a target location via Groovy rules.

Validating Data Entry Values with Groovy
Implement a Groovy script that validates data entry against allowed ranges stored in a driver cube.

Adding Dimension Members with Groovy
Create a Groovy script to work with metadata, in this case, adding a member to a dimension.

Calculating Modified Data Using Groovy
Generate a focused calculation script to calculate only data that has been edited, instead of the entire data entry form.

Integrating Data Between Planning and Strategic Models Using Groovy
Learn about Strategic Modeling concepts and how to integrate data between strategic models and planning applications using Groovy scripts.

Creating Groovy Templates
Create a Groovy template with interactive Design Time Prompts (DTPs).

The OBEs are available on the Help Center.

Downloading the logs from the OAC Classic instance!!!

This is applicable only to Oracle Analytics Cloud - Classic

One of our Customer OAC instances went down and we raised an SR to work with Oracle, Yes you guessed right they did ask for the logs 😊

The first question on the mind since this on the Cloud and how can I get the logs from the cloud. Well, Oracle Analytics cloud (OAC) is different from Oracle Planning and budgeting cloud service (Oracle PBCS).

New Row and Column Suppression Behavior for EPM Cloud!!

I am sure you will love this exciting new feature released in Smartview  11.1.2.5.720

NewRow and Column Suppression Behaviour for EPM Cloud

This feature applies to these EPM Cloud services:

• Oracle Planning and Budgeting Cloud
• Oracle Enterprise Planning and Budgeting Cloud
• Oracle Financial Consolidation and Close Cloud
• Oracle Tax Reporting Cloud

In web applications, your administrator can use the Smart View Suppression Behavior option to change suppression behavior when both the Smart View No Data/Missing and Zero suppression options for rows, or columns, or both are selected.

Testing Network Throughput - Oracle PBCS!!!

Testing Network Throughput

I accidentally found this functionality thought it will be useful to share.

From the document, This topic does not apply to Oracle Cloud at Customer.

Using My services, you can test the end-to-end throughput of the network connection between the browser displaying the network throughput test page and the Oracle Cloud data center. Throughput is the average data rate attained for the transfer of an entire file.

The network test pings the Oracle Cloud data center multiple times with several predefined file sizes, and displays the throughput, latency, and response time. Throughput is expressed in megabits per second (Mbps); latency and response time are expressed in milliseconds (ms). If you contact Oracle for support about poor network performance while using Oracle Cloud, the support representative may ask for this data.

Quick Tip - Oracle Smart View disable for Outlook

Had an instance where one of the customers had installed the Oracle SmartView for accessing the Oracle Planning and Budgeting Cloud. After the installation, the Microsoft Outlook didn’t get started and was staying in the screen starting for a quite long time.

This was quite annoying, but luckily there is an easy solution to the issue. There is life saver option given in SmartView under Options -> Advanced.

With this option, Smart view will be disabled in Outlook and will not hamper the time to load the Outlook. Hope this helps.