TopDown Blog

Tag: Enterprise Performance Management

Data Validations Leading Practices

By on August 9th, 2017

Over my 15 plus years of consulting, one of the great constants in working with Oracle Hyperion EPM is that you cannot hide from data validations.  It must be done.  One of the eternal questions is:  “Does the data tie out?”  And of course, we know that the answer must always be an affirmative.  In…

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.

Top 10 TopDown Consulting Blog Posts of 2015 – #3

By on December 30th, 2015

While it was created specifically to manage hierarchies for applications like Essbase, Hyperion Planning, and Hyperion Financial Management, you can also use DRM to manage master data in other systems like General Ledgers, Data Warehouses, Human Capital Management, etc. DRM is also system agnostic, so it is not tied down to any particular system. And these are just two of the many reasons DRM is an industry favorite Hierarchy Management Tool.

Oracle Hyperion Reports

By on November 24th, 2015

Hyperion has three reporting methods: Hyperion Reports, Hyperion Smart View, and standard reports within Hyperion Financial Management (“HFM”). I will address each of these reporting methods in this blog. I will also discuss XBRL reporting at the end of this blog post.

Oracle Hyperion Security

By on November 9th, 2015

Application security is the security within an application. Security prevents two types of errors: intentional and accidental. Intentional errors are rare, the majority of errors are unintentional or accidental. A large public corporation normally consists of several small entities. The accounting numbers will more likely be correct if accountants are prevented from making unintentional errors by only having the minimum access needed to do their job.

Workforce Planning—Making the Out-of-the-Box Solution Work

By on October 1st, 2015

Join Juan Porter, Chief Solutions Architect & Founder, and Paul Hoch, Principal Architect, on Friday, October 9 at 1p.m. EST, and in one hour you will have a clearer understanding on how to work within the Workforce Planning framework to enhance the application so that you can have a better end result and a better out-of-the-box experience with Workforce Planning.

To Allocate or Not to Allocate in Planning – That is the Question?

By on September 8th, 2015

When it comes to allocating data, most users tend to use HCPM, which begs the question: Is this always the right tool for the job? The short answer is no. Although we have been told that allocations can be handled in HPCM, there are most certainly situations when Planning and Essbase can provide the upper hand when creating an allocation engine. So how do you know when Planning and Essbase are the right tools for the job?

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…

Smart View Power Tools: Break New Analytical Ground with Smart Query

By on August 12th, 2015

Introduced in EPM v11.1.2.2, Smart Query, a feature of Hyperion Smart View, still doesn’t get a lot of attention; and it should because it’s the key to a number of analytical capabilities that Essbase users never had before.

Smart Query goes beyond the capabilities of standard Smart View. To put it more simply, Smart Query is an analysis type like the Essbasse Ad Hoc query tool or Smart View forms, but the cool difference is that Smart Query focuses on “set-based analysis.”

JavaScript Property Formulas within DRM

By on July 29th, 2015

Data Relationship Management (DRM) v11.1.2.3 includes a cool feature that changes the way to write dynamic scripting using JavaScript for your custom derived property and validations. JavaScript has been around for over a decade, but it hasn’t been available to use within DRM until the release of v11.1.2.3.

© Copyright 2020 TopDown Consulting. All Rights Reserved.