Skip to main content


Practical Application of Oracle HFM Consolidation Options

There are three consolidation options in Oracle Hyperion Financial Management (HFM):

  1. Consolidate All
  2. Consolidate All with Data
  3. Consolidate

What each option does has been appropriately discussed in many articles, which also properly suggest to use the Consolidate All option sparingly.

I wanted to share our experience on these consolidation methods.

If the application design use alternate entity hierarchies and consolidate them separately, Consolidate All with Data should only be used on the primary hierarchy. Alternate hierarchies should be consolidated using Consolidate option. To illustrate:

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

After successfully using Consolidate All with Data on the primary entity hierarchy, the consolidation status would appear as follows:

If the Alternate Hierarchy was consolidated using Consolidate All with Data also, the result would be as follows:

Although the main hierarchy had been previously consolidated, the recalculations, retranslations, and reconsolidation performed on the alternate hierarchy would cause the status of the main hierarchy to be changed to CN.

The desired result shown below could be achieved if Consolidate All with data was used for the main hierarchy and Consolidate was used for all the alternate hierarchies.

Almost always, Consolidate All is not used. On one of our implementation, we modified the rules for a new entity which did not have any data loaded on Jan of the current year.  Using Consolidate All with Data would not calculate the target intersections because they did not have any data at all. We used Consolidate All to allow HFM to invoke the rule that populated the targeted intersections involving the new entity. For all succeeding periods, only Consolidate All with Data was needed.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Eduardo Abaricia

I have a bachelor's degree in Accounting, MBA, and CPA. I have 6 years experience in HFM/FDMEE involving manufacturing, service, and marketing industries.

More from this Author

Follow Us