TopDown Blog

Category: Financial Close & Consolidation

Reconciling Data in Oracle EPM or OneStream CM

By on December 28th, 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. Whether you are working with Oracle EPM or OneStream CM applications, the best way to make sure data reconciliation is smooth and mostly uneventful is to take a planned and considered approach. 

Consolidations in ERP or OneStream

By on December 18th, 2017

If your ERP systems will do consolidations, you may be asking the question: How would I benefit from spending the extra money to implement a separate CPM application for Financial Consolidation and Reporting?

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…

© Copyright 2018 TopDown Consulting. All Rights Reserved.