TopDown Blog

Category: Reporting & Analysis

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…

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.

Challenge #5 – Variable Needed for Report Calculation

By on October 12th, 2016

In this example, I had a Report that did a calculation where an Account balance was divided by a Variable that corresponded to the Period number. This data was not maintained in the application and the Report Administrator had to change the Variable in the Report each month. This made the Report static and a maintenance problem so the challenge was to make it dynamic.

Financial Reporting Studio – Challenge #4

By on September 27th, 2016

In many Reports there is a requirement to show the Base or Level 0 Members and to skip any of the roll-up Ancestors in the hierarchy. If the Report is HFM, no problem – simply utilize the Base or Base (Inclusive) Functions provided in FR Studio. However, if the Report is for a Planning or Essbase application, this Function does not exist.

Financial Reporting Studio – Challenge #3

By on September 19th, 2016

It is common to have Reports that are dynamic with respect to the Periods and Years in the Report’s POV. But what happens when the current Period is in one Year and one or more of the trailing Periods is in another? This is the third post in a five-part blog series on FRS challenges and tips for solving them.

Financial Reporting Studio – Challenge #2

By on September 12th, 2016

There is an issue with HFM Reports where if the Offset Function is used in a Report, and there is more than one Dimension referenced in the Rows, the Basic Suppression will not work. This is the second post in a five-part blog series discussing five Oracle Hyperion FRS challenges and tips for solving them.

Financial Reporting Studio Tricks

By on September 7th, 2016

Anyone who has worked with Hyperion’s Financial Reporting Studio (“FRS”) knows that over the years as Hyperion has evolved, FRS has not really changed very much. Oracle describes FRS as “a powerful tool for designing and presenting analytic data graphically.” It is commonly used for designing traditional financial report formats and nontraditional formats.

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.

Q & A—“It’s Always Sunny With Smart View” Webinar

By on June 10th, 2014

During last week’s webinar, “It’s Always Sunny With Smart View,” there were a number of questions that I didn’t have time to get to. Below you will find answers to most of them. Please check back next week for answers to the remaining questions.

Automate Smart View Reports in Two Steps

By on January 29th, 2014

Smart View reports often rely heavily on the appropriate option settings. Luckily, you can automate them in two steps using VBA. First, import the smartview.bas file:

© Copyright 2017 TopDown Consulting. All Rights Reserved.