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

More Kscope16

By on June 29th, 2016

A lot to learn and was learned at the Tuesday Kscope16 sessions. TopDown delivered four of our seven sessions, covering Essbase, Planning, DRM, and Financial Close, to big crowds (even at 8:30 a.m.) who came with a lot of great questions. Talk about being prepared.

Read Full Post

Kscope16 – Day 1 & Day 2 Highlights

By on June 27th, 2016

Great start to Kscope16 on Sunday with symposiums and a Happy Hour with great company, conversations, food, and drink. Day 2 (today)kicked off with a lot of information sessions, focusing on different topics. There is a lot of talk about EPM in the Cloud and Essbase amongst other topics EPM. Some Takeaways from the TopDown Team…

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