The Oracle EPM Cloud June 2020 Update: Five Things We Are Looking Forward To

The Oracle EPM Cloud is the platform that has been “built for autonomous unification of business processes; delivering on scale, agility, visualization, automation and ease of use innovations”. It consists of a collection of Oracle tools that provide a great foundation for building tools to meet needs in Corporate Performance Management (CPM). Oracle just announced the June 2020 update for the Oracle EPM Cloud which will take place on 6/5/20. While the list of updates is long, we wanted to highlight five items that we are really looking forward to:

1. The ability to connect to EPM from Oracle Analytics Cloud (OAC) Instances

Previously, in order to create reporting solutions using EPM Cloud content, we had to use one of two options: connect to the individual plan types in a Planning application via the repository (RPD), or stage the data in one or more Essbase cubes in the Oracle PaaS. With this update, Oracle is providing a native connection via the Data Visualization interface. This is functionality that has been eagerly awaited for a long time, due to the previous options having many short-comings such as the inability to handle changing hierarchies natively, or handle multiple alias tables. It remains to be seen if the initial version of this connection will cure all these ailments, or will deliver these features over time. The necessary patch for OAC has also not been released yet, but we hope to be able to test it as soon as it is available.

2. Flash is disabled by default in Calculation Manager

Adobe announced a while ago that they will stop updating Flash player after 2020. As a result, most web browsers have disabled it by default. However, since the default ‘Designer’ interface for Calculation Manager uses Flash to function, business rule writers had to jump through multiple hoops to be able to work in this interface. With the June 2020 update, Oracle has announced that “Flash is now disabled by default in Calculation Manager. You can still enable Flash temporarily, if desired.”

3. REST API can now download data kickouts

In the April 2020 update, the ability to download rejected records for metadata loads was introduced. With the June 2020 update, this same ability has now been extended to data loads. Previously, it was possible to download the first 5 rejected records, which would not necessarily paint an entire picture.

4. The ability to write to upper-level (parent) dynamic members in ASO or BSO

Groovy business rules now provide the ability to write data to non-level 0 members in ASO and Hybrid BSO cubes, even if the member is dynamic. This ability is provided in the form of the function ‘setForcedEditable()’, which would change the target intersection to writable. From that point, it would not be difficult to create allocation rules to push that data down to the level 0 descendants of that member. Theoretically, this will allow for an all-ASO Planning model. We think that’s pretty cool!

5. Suppress missing rows at the Essbase level in data grids

With the ‘DataGridDefinitionBuilder’ groovy object, we can apply certain settings to the data grids that we can build on-the-fly in groovy business rules. Such grids come in handy to do things like source specific slices of data to work on. Among the settings is the ability to suppress missing data like blocks. Now, we will be able to filter out data rows with all #Missing values at the Essbase layer itself, reducing the number of records that are sent from Essbase to Planning, potentially increasing calculation throughput.

Are these items on your list too? Did we miss a feature update that you think we should be excited about? Let us know in the comments, or drop us a note here! We look forward to posting an update once the June 2020 update hits our instances.

#oracle #Planning #PaaS #Groovy #Businessrules #enterpriseperformancemanagementEPM #PlanningandBudgetingCloudServicePBCS #EnterprisePlanningandBudgetingCloudServiceEPBCS #calculationmanager #analytics #DV #DataVisualization #OracleAnalyticsCloudOAC