Eduardo Abaricia

In an Oracle Hyperion Financial Management (HFM) implementation, we always use the historical rate to translate the subsidiary’s equity. Historical rate means the actual exchange rate used when the transaction was consummated. For me, the most practical way of achieving this is by using equity overrides. This gives the client full control of the actual translated […]

In an Oracle Hyperion Financial Management (HFM) application, you can always create alternate hierarchies. We have created them for Entity, Accounts, and any of the custom dimensions. The guideline is always when the consultants leave, the HFM administrator must be able to efficiently maintain the application and meet the company’s management information and reporting needs. […]

Intercompany elimination report is a very useful tool in analyzing intercompany balances. Plug Accounts play a major role as they store differences in intercompany balances and they group accounts with the same Plug Account in the Report. This allows HFM to match balances between Entities and the related Intercompany Partner. How do we get rid […]

We had a client where, by nature of their business, base entities may move from one parent to another. However, all historical data must stay with their previous parent. Only prospective data will belong to the new parent. There may be several ways of complying with this client requirement, but for me, the simplest way […]

Hyperion Financial Management (HFM) data resides at the intersection of all the application dimensions. Consequently, data security should be defined at the dimension intersection. One of our clients requested us to review their HFM security in preparation for their annual audit. The application was previously built by a different consulting group and based on the […]

A Hyperion Financial Management (HFM) application is always tailored to the client’s needs, business environment, and available data. It is almost impossible to lift an existing application and implement it in a different business environment. For this reason, documentation is extremely important. A design document ensures that the client and the consultant are on the […]

HFM/FDMEE have been successfully replacing spreadsheets to achieve efficiency and accuracy during month end close. It is rarely discussed that HFM/FDMEE have also successfully replaced other systems used for consolidation and reporting. In one of our recent implementations, our client previously acquired a large group of companies based in Asia Pacific which had been using […]

When building an HFM application, one of the application settings is Node Security which is either Parent or Entity. What is the difference between these two choices? Selecting “Entity” means that user access is defined strictly by entity security while “Parent” means that user access considers Parent security. To illustrate assume the following: The user […]

Promoting a base entity to a parent entity in Hyperion Financial Management application should be avoided. Parent data are normally the summation of all the “Contribution Total” from its children. Parent entities do not have its own data in HFM other than adjustments if entity dimension attributes allow adjustments at parent level. In an existing […]

A client in the manufacturing industry I was working with recently upgraded from Hyperion Financial Management (HFM) version 9.3 to 11.1.2.4. Their application design in V9.3 served their management reporting needs so well that they required the same functionality in 11.1.2.4. Managerial reporting is very important to the client in addition to their statutorial reporting requirements. […]