August 29, 2021

The Clone Environment feature came to PCM first earlier this year, then it came to Planning, FCC, and other EPM solutions. In this post, let’s take a look at some migration ideas for both the on-prem and cloud solutions.   On-prem LCM When talking about EPM migrations, Lifecycle Management (LCM) is commonly used for an…

March 28, 2021

  In EPM Planning, we can now apply cell level security (CLS). It is finally here. It is surely exciting news.   The CLS can deny access to cells that a user would normally have access to due to their regular security. It is defined as an exception to the existing member security.   Historical…

December 8, 2020

The September patch (20.09) releases a new dashboard version, the Dashboard 2.0. This brings the JET technology into EPM solutions.   Background Info The dashboard 2.0 is available for the following EPM solutions: Planning Financial Consolidation and Close Tax Reporting Dashboard (1.0) and Dashboard 2.0 are using different backend technologies. Dashboard—Existing dashboards using Oracle ADF…

September 28, 2020

Enterprise data management has slightly different security settings comparing with other EPM cloud solutions. There are 3 levels of role access. We will take a look at these levels in this post.   First Level Role – Service Roles from My Services The first level role is set up on the My Services page. When…

September 20, 2020

When deploying an on-prem Hyperion planning cube, a native Essbase cube, or refreshing planning cloud database, you may get the following Essbase error.   “Cannot restructure cube. Essbase Error(1010004): Total possible blocks of database [xxx] exceeds the limit, which is [2^52], or [4.5036e+15], for each of two dimension groups.”   If you check Oracle support…

April 16, 2020

When it comes to aggregation, there are a few ways to achieve this. Let’s consolidate a few options and see what are the differences and benefits among them.   AGG The most common one is AGG. It consolidates the database values ignoring all member formulas. Keep in mind that it works for sparse dimensions. The…

April 11, 2020

Profitability and Cost Management (PCM) got released during the OpenWorld in September 2016 as the software-as-a-service (SaaS) replacement for its on-premises Oracle Hyperion Profitability and Cost Management (HPCM) solution. PCM is a great tool to analyze costs, revenue and profitability. We often receive questions about the similarities and differences between PCM and HPCM, and the…

April 5, 2020

  When using a planning and budgeting system, scheduling jobs to load data, update hierarchy, etc. is necessary. The task scheduler is commonly used for Windows systems. What if a file transfer and automation server is using a Linux system? Most likely, we would come across using Cron.   Cron is a service that allows…

March 26, 2020

Oracle releases the application updates documentation on new features and fixed issues from the Applications Release Readiness site. From there, you will be able to check the update for Marketing, Sales, and Service, Human Capital Management, Enterprise Resource Planning, Supply Chain Management, Data Cloud, Enterprise Performance Management, and Industry Solutions. A quick recap of the EPM applications….