Consolidating Data with Oracle Hyperion Financial Management (HFM)

Consolidation of the data can be done with various dependent entities by gathering the data from their parent entities. After the entry of the data into the base level entities, the data can be adjusted and calculated by running the consolidation process throughout the organization by adjusting the scenarios. Now, let us go through the role of Oracle HFM in consolidation process.

Customized Process: For enabling the consolidations, the HFM can customize the process and change them from the default method. The consolidation rules can be applied with the statutory rules of the attributes. If the settings are not enabled properly, the system will perform the elimination activities. When the setting is enabled properly, the system will perform the consolidation process with the sub consolidate routine by the administrator.


Data Grid: The consolidation process can be launched through data grids. This particular consolidation by integrating with HFM can set specific rules for the entity, period, value, and the scenario. As part of the HFM process, the consolidation can be carried on for all the entities and prior time periods of the same year. The Calculate function can affect the value and the entity. The Translation function can be continued for converting the data from the currency of the child entity to the parent entity. In cases where the child and the parent entity are using the same currency, translation is not required at all. When you choose the parent entity of the consolidated dependent entity, the following processes can run by default:

  • The calculation rules can be processed with the system where all the descendents of the entities are present
  • If the child and the parent entity contain different currencies, depending on the exchange rates, the system will translate accordingly. The translated values of the child entity can be saved with the member of the Parent currency of value dimension. The translated values can be stored in the parent entity.
  • The modifications of the data can be done through the journals
  • If the entity of the parent’s ownership for the child is less than 100%, the ownership percentage can be applied. The proportion and the details of the elimination can be generated through system and the contribution data can be created. If further adjustments are required, the contribution data can be modified through the Journals.

Calculation Process: The calculation process can run by specifying the value of period, scenario and entity. For example, you can calculate the present month’s opening balance with the help of the previous month’s closing balance. The calculation rules cannot be consolidated with the prior time periods in the same year. As the source entities cannot be consolidated through translation, the status is not eliminated from the cell. If the input accounts are not present, then also the calculation function can be used for deriving calculated accounts.

Currency Rates and Percent Consolidation: During the translation and the consolidation process in HFM, the currency rates can be used. The currency rates can be entered with the data members with the help of the data grids. For utilizing the application currency, the FROM currency and the TO currency dimensions can include well defined currency members. The percent consolidation is by default 100 % when the parents are consolidating the child entities.

Therefore, you can observe various consolidation options available with the HFM. There can be options like Consolidate (Impacted), Consolidate All or Consolidate All with Data. The process control pane or the data grids can run the consolidation process with the help of Oracle HFM. For using all the options, you can be assigned with the security role of the Consolidate All.