Automate version creation and renaming in Oracle EPM with Groovy scripting!

 

Groovy scripting, which enables automation, dynamic validation, and metadata updates.

In this blog, we’ll walk through two Groovy business rules that manage version members in the Version dimension:

1. Creating a new version dynamically
2. Renaming an existing version member

We’ll explain the logic behind each rule, 

Copy data in a ASO cube between members of a same dimension!!!

 I came across a request to copy data between versions for an EPBCS application, absolutely a common request but this is for an ASO Cube. We all have done 100 times this on a BSO cube but for me, this was the first request on an ASO cube.

Let I narrate the process to copy data in an ASO cube between members of the same dimension

 

• Create a new rule in the calculation manager under the respective ASO cube