TopDown Blog

Category: Financial Close & Consolidation

Another Look at Reconciling Data

By on November 7th, 2017

Most organizations severely underestimate what it takes to reconcile data. They often don’t consider how much historical data is needed and other items that need to be accounted for. The best way to make sure data reconciliation is smooth and mostly uneventful is to take a planned and considered approach.

An Alternative Solution for Dynamic Organization Roll-up

By on July 14th, 2017

Clients often ask for the ability to report historical data the way it was reported organizationally at that previous point in time as well as to report current data in a different organizational view at the current point in time. I call this a dynamic organization roll-up when you need to freeze history in its own view(s) and see current period(s) in a different view.

Consolidations in Oracle Hyperion Financial Management

By on January 23rd, 2017

In the world of corporate financial reporting, what are consolidations? And what is Oracle Hyperion Financial Management (HFM)? This case study answers these questions and demonstrates how HFM is the best solution for providing Profit & Loss statements, Balance Sheet reports, Cash Flow statements, and other related company financial reports.

HFM Admins – It’s Time to Care About BEPS

By on August 3rd, 2016

BEPS stands for Base Erosion and Profit Shifting. BEPS is a tax avoidance strategy used by multinational companies. The goal is to move profits from jurisdictions that have high taxes to jurisdictions that have low taxes. This is important to HFM Administrators because the final BEPS report contains a new Country-by-Country reporting requirement for large multi-national companies.

How to Design the HFM Application to Store Permanent Data

By on April 27th, 2016

Many people are looking for a way to get their Hyperion consolidation application to permanently store data. The commonality in this situation is they have a consolidation process that involves using the HFM application to make topside adjustments in the form of journals. This blog post discusses how the the use of the “Data Type” custom dimension mitigates the loss of traceability of source system data, enhancing the HFM application to store permanent data.

How to Make Your Period Dimension Represent Two Different Fiscal Calendars

By on March 15th, 2016

It happens quite frequently that companies change their fiscal calendar. So how do you create the consolidation solution in Hyperion EPM that is most adaptable to a fiscal calendar change? I recommend building your Period dimension in Hyperion metadata to use generic labeling.

Hyperion Financial Management (HFM) Architecture

By on January 27th, 2016

Whether you are in the process of selecting a tool for your organization’s consolidation and reporting needs, conceptualizing the application design for an in-progress implementation or familiarizing yourself with an application already in place, there are some key things you need to know about Oracle Hyperion Financial Management (HFM).

Solving Oracle HFM Consolidation Issues

By on October 30th, 2015

Accounting means assigning the correct numbers to the correct accounts in the correct time period. Consolidation means combining the accounts of several entities according to accounting rules. Introduction As the administrator of Oracle Hyperion Financial Management (“HFM”), your job is to support the application that produces the consolidated results. Key to supporting the application is…

You Want to Put What in HFM?

By on August 27th, 2015

Most people view HFM as just a financial consolidation tool (and it is an excellent tool for combining data from disparate sources and then consolidating it to produce financial statements), putting HFM into this “consolidation tool-only box” and never think about how to use its capabilities to solve other reporting challenges. Well, guess what? You…

Intercompany Eliminations in Custom Dimensions

By on March 25th, 2015

We all know that HFM will perform intercompany eliminations on the entity dimension. This is inherent functionality in HFM and is used in almost every HFM application. What is not as well known is that it is also possible to perform intercompany eliminations on a custom dimension.

© Copyright 2017 TopDown Consulting. All Rights Reserved.