Oracle Cloud EPM Profitability and Cost Management vs. Hyperion Profitability and Cost Management (HPCM): Performance Comparison!
In our previous blog in this series, we discussed the most immediate comparison point; how easy is it to upgrade to HPCM 11.2 compared to migrating to Oracle Cloud EPM Profitability and Cost Management.. In this blog, we are going to look at an aspect that comes up in almost every EPM implementation, performance!
As we are looking at PCM Management Ledger applications, the comparison points for performance between HPCM and Oracle Cloud EPM Profitability and Cost Management are quite simple. For this blog, we broke up performance into 4 broad categories:
- Deploying Dimensionality
- Rule Maintenance
- Model Execution
Now normally, I would want you to read the entire blog before getting to my conclusion, but this one I will do slightly different because there is such a clear winner… Oracle Cloud EPM Profitability and Cost Management WINS!
The reason why I am so confident in giving the award to Oracle Cloud EPM Profitability and Cost Management is that Oracle Cloud EPM Profitability and Cost Management outperforms HPCM even without leveraging the performance features of Oracle Cloud EPM Profitability and Cost Management. With HPCM, each client will most likely have different infrastructure setups, this can lead to dramatic differences in performance between clients based on infrastructure alone. However, with Oracle Cloud EPM Profitability and Cost Management, all clients leverage the same infrastructure setup which is optimized for Oracle Cloud EPM Profitability and Cost Management. It’s not a question of whether Oracle Cloud EPM Profitability and Cost Management will have better performance than HPCM, the question is how much better?
That said, let us take a look at some of the differences in performance across our 4 categories:
Deploying dimensions is a frequent activity at most clients, and performance can be a result of various elements such as application dimension size, the number of attribute dimensions and associations and network connectivity, and other infrastructure-related factors.
Provided you are using the Master cube approach, HPCM has a 3-step dimensionality deployment process; update the master cube, deploy dimensions to HPCM through Profitability Manager, and then deploy it to the HPCM Essbase databases. On the other hand, Oracle Cloud EPM Profitability and Cost Management has a two-step deployment process; update/deploy dimensions and deploy it to the Essbase databases. Because of this, even in the best-case scenario for HPCM, Oracle Cloud EPM Profitability and Cost Management will deploy faster as it has fewer steps to perform.
However, at some clients with less than optimal network setups deployments, can take HOURS in on-premise HPCM compared to minutes in PCMCS. Again, Oracle Cloud EPM Profitability and Cost Management is optimized to run as quickly as possible where HPCM infrastructure has to take into account the larger organization requirements.
I am taking a little bit of liberty to include Rule Maintenance in this performance comparison as it is more of a maintenance task. Still, it is important to consider it for clients with a large number of rules that require frequent updating.
The Rules in HPCM have to be updated individually, for each Point of View (POV). There is no way to bulk update rules without hacking the backend XML file. In Oracle Cloud EPM Profitability and Cost Management new features exist that allow us to bulk update rules, copy Rules between Rule Sets and copy Rules between POV. In addition, Oracle Cloud EPM Profitability and Cost Management have a text entry feature which can make updating rules faster. In certain situations, this can have a dramatic impact on the turnaround time to produce results, which is why I have included it in the performance comparison.
This is the category that has the widest gap when comparing HPCM to Oracle Cloud EPM Profitability and Cost Management. As I mentioned in the introduction, Oracle Cloud EPM Profitability and Cost Management will almost always execute calculations quicker than HPCM due to an optimized environment, however, it doesn’t stop there.
In Oracle Cloud EPM Profitability and Cost Management, we have various performance-centric features that we can deploy and that are not available to us in HPCM. These include but are not limited to the ability to utilize NONEMPTYTUPLE in Custom Rules, the ability to change the Essbase Clear Type from Physical to Logical, and whether NONEMPTYTUPLE is used in the allocation rules through updating various governors. This in combination with other performance features not available in HPCM, and the optimized environment can have a dramatic impact on performance.
Reporting is by far the most subjective part of any performance tuning and analysis at clients. Each individual can have a personal level of acceptability for how long reports can take to run. In this comparison, we are grouping report retrieval performance in SmartView and Financial reports as well as data extract performance, which is important when considering the overall time, it takes to produce reports.
In Oracle Cloud EPM Profitability and Cost Management, we have the advantage of additional features such as the “Optimize for Reporting” option when executing calculations and an optimized environment. Oracle Cloud EPM Profitability and Cost Management also has additional reporting level functionality that we can leverage such as, Model Queries. On the flipside, HPCM can take advantage of more features available at an Essbase level, which can make exporting data easier (for example, through Report Scripts). So, in this category, I would call it a tie.
It’s important to note that I am not evaluating the Reporting features available in HPCM and Oracle Cloud EPM Profitability and Cost Management but the performance of the Reporting. Oracle Cloud EPM Profitability and Cost Management has significantly better Reporting features compared to HPCM.
Well, since I have already declared a winner, I will leave you with a real-life example of a client who migrated from HPCM to Oracle Cloud EPM Profitability and Cost Management and the difference in the performance the experienced across the above categories:
|Category||Actions||Execution Time (HPCM)||Execution Time (Oracle Cloud EPM Profitability and Cost Management)|
|Deployment Dimensionality||Update Dimension (Update Dimensionality and Database Deployment)||4+ Hours||<25 Mins|
|Mass Rules Updates *(100+ Rules)||1-2 Hours||5-15 Mins|
|Model Execution||Rule Execution (per POV)||3-4 Hours||< 10 Mins|
|Reporting||Running of System Reports, Financial Reports and SmartView Reports Refresh and Export to Reporting Application||1 Hour||< 30 Mins|
As you can see from the above real client example, the performance benefits of moving to Oracle Cloud EPM Profitability and Cost Management are significant! Just think about your month-end process and how a reduction similar to the times about would make a difference in your world.
For comments, questions, or suggestions for future topics, please reach out to us at firstname.lastname@example.org. Visit our blog regularly for new posts about Cloud updates and other Oracle Cloud Services such as Planning and Budgeting, Financial Consolidation, Account Reconciliation, and Enterprise Data Management. Follow Alithya on social media for the latest information about EPM, ERP, and Analytics solutions to meet your business needs.