Analytics | Oracle EPM | Advanced Analytics | Many More...

The first product of Oracle EPM cloud was launched in 2014 and it's been 5 years and over the course of these 5 years, Oracle has every EPM product in cloud to what is available in on-premise. With so many products under the EPM belt each with its own functionality, there is a real need to have a single unified reporting tool that can handle all your reporting requirements across all your EPM products at one place. EPRCS (Enterprise Performance Reporting Cloud Service) is the Oracle direction to address all the reporting needs for any organization of any size. If your team is responsible for the management, narrative and external reporting with the ability to author, collaborate and a solid approval process, you definitely have to consider implementing EPRCS at your organization EPRCS can connect to your EPM Cloud products, Essbase cloud and also to your Fusion Applications Essbase app. It addresses all your financial, management, narrative and disclosure reporting. I am not goi

I am part of the EPM competency at my organization and I often get pulled in to few of the discussions. There was one instance this week where I was pulled in to a meeting for a simple yet typical problem Problem statement Client had an Essbase ASO application that was migrated to Oracle Analytics Cloud and was not used for a long time. Recently, they have loaded the data and started validating. There is a currency conversion process which is not producing any results. They wanted to check what got changed / what was missed. Unfortunately, they only had the OTL and the data files and they do not have any on-prem instance where they could easily open the OTL in EAS. We had a lab instance where we opened the outline and figured out that the Entity dimension is missing the UDA's. Now, we wanted an easy way to get the UDA's so that we can make the change very quick There was no way that you could view an OTL file and reached out asking how can we extract the dimension from

As you all are aware that Oracle releases patches to EPM cloud every month (EDMCS is released every 2 months) and the patches are applied on first-week of Friday in Dev and third-week of Friday in Prod I did a post long back about a challenge that I have faced in on-premise and how I have addressed that. New functions were released in Nov-2018 release of PBCS. Below is an excerpt from the readiness document. You can find the document here New Aggregate Storage Functions in Calculation Manager The following Aggregate Storage functions have been added to Calculation Manager. These functions filter the shared and dynamic members from the Point of View (POV). The functions can be used in the POV of an Aggregate Storage custom calculation or allocation. @FilterDynamic(Dimension Name, Member Name) removes all dynamic members from the list of members @FilterShared(Dimension Name, Member Name) removes all shared members from the list of members @FilterSharedAndDynamic(Dimensio