By TopDown Team 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…
By TopDown Team 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.
By TopDown Team 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.
By TopDown Team 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.
By TopDown Team 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.
By TopDown Team 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.
By TopDown Team 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.
By TopDown Team 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.
By Paul Hoch 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.
By TopDown Team 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: