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,

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.

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.

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.