Introducing Oracle Profitability and Cost Management Cloud Service

By on October 20th, 2016

If your company uses Oracle Hyperion Profitability and Cost Management, and you have built your model using the management ledger style, it is easy to migrate to the Cloud solution. Now is the time to discover and act on hidden profit and loss and empower business users with the insight and flexibility to discover the many dimensions of profitability.

Read Full Post

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.

Read Full Post

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.

Read Full Post

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.

Read Full Post

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.

Read Full Post

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.

Read Full Post

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.

Read Full Post

Why Host Your Financial Systems in the Cloud?

By on July 26th, 2016

At different times, I have been a controller, and a director of IT at different companies. In any of these positions I would have been happy to host the financial systems in the Cloud. Why? Because it would help me to keep my job. In any of these positions, the financial reporting and the IT departments will be held responsible if the computer systems fail, and failure is much less likely in the Cloud with a big company like Oracle.

Read Full Post

The Next Generation (Essbase) Outline Extractor

By on July 7th, 2016

AppliedOlap has implemented useful improvements for extracting Account Dimensions from a v11.1.2.4 Essbase Cube to the Next Generation Outline Extractor. The original OlapUnderground Outline Extractor is only supported up through This next generation of the tool, does the trick, and this blog post outlines how. Note that the updated tool is not dependent on having the Essbase Client installed in your system, rather it uses the new Essbase Java API.

Read Full Post

Kscope16 – Final Thoughts

By on June 30th, 2016

Thanks Kscope16, ODTUG, and everyone who attended the conference for another year of learning and community. We look forward to seeing everyone next year, at KSCOPE17, in the Lone Star State of Texas, San Antonio that is.

Read Full Post
© Copyright 2016 TopDown Consulting. All Rights Reserved.