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.
This was always a special request from multiple customers Can I run Data Management rules from a form? For quite a while the answer was sorry you cannot. But with Groovy + Calculation Manager you can do that. Yes, you can call the Data Management rule from a Calculation manager rule and attach the Calculation Manager rule to a Menu and attach that Menu to the Form, so the users can run them when needed.
The next question is if the User id is not an Admin user, will he be still able to run the Data Management rule. As per the Oracle EPM security setup you cannot.
But
you can overcome this by using Connections
either by using On
Demand Connections or Named
Connections.
A Brief intro on when to use when, (from the Oracle document)
In general, connections can be created in one of two ways:
Connection connection = connection(http://server:port/HyperionPlanning/rest/v3/applications/Vision, "user", "password")These connections are easy to change and are great for prototyping and trying out connections. Connection connection = operation.application.getConnection("Job Definitions")These connections allow clean separation between resource details and usage. This has multiple benefits over on-demand
connections including:Oracle released the cool feature of "CROSS APPLICATION SUPPORT FOR SMART PUSH IN DATA MAPS" in April 2022.
Cross Application Smart Push feature enables customers with multiple applications to instantly move data, cell comments and supporting detail from a cube in a source application to a reporting or other cube in a remote target application
Applies to: Planning, Planning Modules (both as source and target), FreeForm (both as source and target), Financial Consolidation and Close (target only), Tax Reporting (target only).
We all might have come across this request when we need to add a history year. The Years are populated using the parameters specified while creating the Planning application.
It is pretty common where we created the Planning application starting from FY16 but later on the request was to add the FY15 too.
Newly added users to PBCS/EPBCS cannot access the instance!
You might have hit this issue that the recently added users to PBCS/EPBCS cannot access the instance, it gives an error message,
"User is not authorized on this service instance"
.png)
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,
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.
REST API allows running the Data Management rules using the following two job type methods
We all have loaded non-numeric (Text, Date & Smartlist, etc..) using the Data Management (FDMEE cloud). I thought I will reiterate the common mistakes done while loading the All data types data.
The first step to verify the Import Format is set to Multi Column -All Data Type or Delimeted- All Data Type as Numeric data will not load Date format data.
In this screenshot, i am loading the Date to the member OCX_Purchase Date
