TopDown Blog

Tag: Hyperion Planning

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…

Handling Textual Data in Planning and Essbase—A Starbucks Case Study

By on June 20th, 2017

Handling text data in a Hyperion Planning application is relatively easy and straightforward. Managing and reporting on text data is not quite as simple in the Essbase technology. But it can be done. Find out how.

Extreme Calc Manager

By on April 25th, 2017

Calc Manager is at the center of Oracle’s EPM suite. It’s the place to develop logic for Essbase, HFM, and Planning on-premise or in the Cloud.  At Kscope17, Ludovic De Paz and Ron Moore focus on the Calc Manager features that save time and/or allow you to do things you can’t otherwise do and/or explore. This blog post highlights the details of that session and more.

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.

Transforming Planning at Suez with Hybrid Aggregation

By on February 6th, 2017

Suez administrators had to carefully plan when to execute aggregations to avoid taking the application off line and disrupting users. Back up and other administrative tasks were also very time consuming. To solve this problem, Suez collaborated with TopDown to optimize the aggregation process through a Hybrid aggregation approach.

Data Type Features in Oracle PBCS & EPBCS

By on February 1st, 2017

If you’re working with Hyperion Planning, the good news is that the cloud versions —PBCS and EPBCS—offer the same data type features. The key thing to know is that the configuration is slightly different. This post will show you how to enhance your Planning cloud application with non-financial data such as Text or Dates.

Managing and Integrating Hyperion Smart Lists Using DRM – Part 1

By on January 10th, 2017

Oracle Essbase is the industry leading Multidimensional Database platform. As a modeling and reporting technology, Essbase can only store numeric information, strings and other data types are not supported. However, both Essbase and Planning can get around this limitation using some functionality called Smart Lists, which are nothing more than lookup tables. This blog post will show you a design to manage both the Smart Lists themselves, as well as the association between member (in Essbase/Planning) and Smart List.

2016 Top 10 Topics & EPM in the Cloud

By on January 4th, 2017

Every year TopDown showcases our top content for the year with the Top 10 most popular blog posts. Some of these topics remain evergreen, making the list for multiple years. Other topics are more recent. To make things more interesting, this year our experts have looked at the content and weighed in on how the topic at hand fits in with the maturing of EPM in the cloud. Read on to find out what they have to say.

Allocations Always Equal 100

By on December 7th, 2016

Discover a simple trick that you can use in Hyperion Planning and Essbase to ensure you never have to worry about over or under allocating your expenses when entering a value that doesn’t equal 100%.

Driver-based Budgeting Poll

By on June 21st, 2016

We recently finished a very successful PBCS driver-based budgeting project. There are a lot of reasons why the project was successful. One big reason was the great team on the customer’s side. In particular, the customers project owner had a deep understanding of driver-based budgeting and how to use it to help his stakeholders. I’ve…

© Copyright 2019 TopDown Consulting. All Rights Reserved.