TopDown Blog

Welcome to the TopDown Consulting Blog, the top resource for EPM professionals. Find in-depth guides and thought leadership on topics relevant to Oracle EPM, Essbase, OneStream EPM, Business Intelligence and Financial Reporting and Analysis.

Integrating DRM with Oracle Planning and Budgeting Cloud Service

By on March 14th, 2017

When it comes to Oracle Planning and Budgeting Cloud Service (PBCS), the question we are consistently asked is: Can DRM publish metadata for consumption into Oracle Cloud? The answer is yes, with a couple of asterisks. Read on to find out how.

Doing More with Currency Translations

By on March 8th, 2017

Oracle Hyperion Financial Management (HFM) is purpose-built to perform consolidations and reporting. HFM has a great built-in functionality to translate data from any currency into the reporting currency. In this blog post, we’ll discuss extending the use of the built-in currency translation capability.

Oracle ARCS: The Essential Overview

By on February 27th, 2017

In this blog post, we’re looking at Account Reconciliation Cloud Services, or ARCS, the cloud version of Account Reconciliation Manager (ARM). ARCS is a cloud-based solution designed to bring automation and controls to the account reconciliation process. Unlike some of the other members of the EPM Cloud Suite, ARCS currently has the majority of the functionality found in the on-premise version.

Smart View in the Cloud

By on February 21st, 2017

EPM in the Cloud is fast becoming the new normal as Oracle continues to add to its suite of Cloud products. As companies transition Planning applications to the Cloud, they often have questions about how things like existing spreadsheets, reports, and processes going to work once they migrate.

Consolidations in ERP or Oracle FCCS?

By on February 14th, 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 EPM application for Financial Consolidation and Reporting? An EPM solution such as Oracle’s FCCS helps companies address challenges that come with doing consolidations in an ERP system.

Transforming Planning at Suez with Hybrid Aggregation

By on February 6th, 2017

Suez administrators had to carefully plan when to execute aggregations to avoid taking the application off line and disrupting users. Back up and other administrative tasks were also very time consuming. To solve this problem, Suez collaborated with TopDown to optimize the aggregation process through a Hybrid aggregation approach.

Data Type Features in Oracle PBCS & EPBCS

By on February 1st, 2017

If you’re working with Hyperion Planning, the good news is that the cloud versions —PBCS and EPBCS—offer the same data type features. The key thing to know is that the configuration is slightly different. This post will show you how to enhance your Planning cloud application with non-financial data such as Text or Dates.

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.

FCCS & HFM – Similarities & Differences

By on January 16th, 2017

At first glance, FCCS would seem substantially different from HFM. The Simplified interface looks nothing like the traditional HFM workspace interface. When taking a closer look, however, especially when considering the design of the dimensionality, you’ll see that FCCS is a very close relative of HFM. As Oracle continues to increase the features and functions of FCCS, the two seemingly different applications will move closer and closer in comparison.

Managing and Integrating Hyperion Smart Lists Using DRM – Part 1

By on January 10th, 2017

Oracle Essbase is the industry leading Multidimensional Database platform. As a modeling and reporting technology, Essbase can only store numeric information, strings and other data types are not supported. However, both Essbase and Planning can get around this limitation using some functionality called Smart Lists, which are nothing more than lookup tables. This blog post will show you a design to manage both the Smart Lists themselves, as well as the association between member (in Essbase/Planning) and Smart List.

© Copyright 2017 TopDown Consulting. All Rights Reserved.