2016 Top 10 Topics & EPM in the Cloud


January 4th, 2017


Every year TopDown showcases our top content for the year with the Top 10 most popular blog posts. These are topics that most interest clients, referral sources, editors, Oracle, and even competitors recognize who all recognize us as one of the foremost authorities on, and the go-to organization for, Enterprise Performance Management solutions on-premise and in the cloud.

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.

Adding Custom Dimensions to HFM
With the release of HFM, HFM supports more than four custom dimensions. It will also allow the addition of custom dimensions to an existing application. Why add dimensions to your application? How do you add dimensions to an application and what are some considerations?What do dimensions look like in the cloud? Brian Willson talks about this in his blog post,  FCCS Dimensions: You Look Familiar (for the Most Part).
Read more >

Enhancing Hyperion Planning with Text Data Type Members
The ability to assign text data type has been available since Hyperion Planning version 11.1.1; albeit, text data type assignment is limited to the Account dimension members. Nonetheless, this feature allows one to include non-numeric information in Planning Web Forms and Reports—information that can enhance your Planning application.The cloud versions of Hyperion Planning—PBCS and EPBCS—offer the same data type features as in the On-Premise versions. The configuration is slightly different. Ludovic De Paz discusses how to enhance your Planning cloud application with non-Financial data such as Text or Dates in, Working with Data Types in PBCS and EPBCS.
Read more >

FDM – Map One Source Account to Multiple Target Accounts
What do you do when one line item provides more information than only one destination Point of View? For instance, assume that all of the trial balance accounts from an extract will load to a custom dimension member of “END”. However further assume that the trial balance has multiple members, typically in a custom dimension, for the balance sheet accounts that record movement.The release of PSU 200 for FDMEE introduced some exciting new features, including the ability to add a Cloud application as a target application. Thomas Thuresson uses this case study to show you how in his blog post, Using FDMEE to Add a Cloud Application as a Target.
Read more >

Automate Smart View Reports in 2 Steps
Smart View reports often rely heavily on the appropriate option settings. Luckily, you can automate them in two steps using VBA. This blog post walks you through how.We are seeing a push towards cloud solutions in the industry in general and with Oracle rolling out many new cloud products in the last few years something that our customers have often expressed concern over is, “How are my existing Spreadsheets, Reports, and processes going to work once we migrate to the cloud?” The good news is Smart View is fully available and supported with Cloud applications. Find out how in this blog post by Paul Hoch, Automate Smart View in Your Cloud Applications.
Read more >

Hyperion Financial Management Architecture
Discover the key things you need to know about Oracle Hyperion Financial Management (HFM) when considering it as a reporting and/or consolidation tool. Brian Willson shares his knowledge on this evergreen topic, in this blog post, HFM Architecture.
Read more >

Automating Calc Manager Rules for Planning
Oracle’s Calculation Manager has a host of features for creating business rules across the Hyperion suite of products. Today I want to focus on how to automate those rules in a Hyperion Planning environment. If you have Calculation Manager rules that you would like to schedule to run on a periodic basis, including rules with run-time prompts, this post is for you.Like most other components of PBCS, calculations are pretty much the same whether it’s on-premise or in the cloud. But there are a few differences. Ron Moore shares are a few things you need to know, including what is going to change and when is the best time to move your Hyperion Planning environment to PBCS, in his blog post,  Getting started with Calculations in PBCS.
Read more >

What is Oracle Hyperion’s DRM Tool?
There appears to be a lot misconception about what the DRM tool really is and where and how it can be used.  Client’s tend initially to narrowly focus on how they are going to use the product and use that information to develop an initial impression of exactly what the tool really is. This blog post discusses how to take a broader view and discover the true power of DRM.The beauty of DRM is that it integrates with any and all applications. Being application agnostic allows a Company to centrally manage their hierarchies and definitions, then publish the “source of truth” out to all downstream subscribing systems. Find out more in how this applies to both on premise and cloud-based applications in the blog post, Oracle DRM on the Ground and in the Cloud.
Read more >

FDM/FDMEE mapping
Let’s discuss the basic fundamental purpose of FDMEE. That is to say mappings. FDMEE has come a long way since its origins, and is at this stage is an ETL-like tool (Extract Transform Load). Mapping is the “T”, Transform, part of this acronym. This is where source system, typically General Ledgers, metadata members are transformed to a destination EPM application dimension member. Think of these as accounts, entities, cost centers, product members, and so on.FDMEE remains popular with another blog post on the topic coming in the 3rd spot with, FDMEE / FDM Mapping – General Principles. This post covers the basic fundamental purpose of FDM. Thomas Thuresson, a specialist in data integration using FDM/FDMEE, has expanded on the series to include mapping to PBCS in his blog post, FDMEE Mapping Principles, Including PBCS.
Read more >

Getting Started with DRM Parts 1-4
A multi-part blog series that walks you through how to create a DRM application and configure it with the intent of managing & loading metadata for Essbase.Oracle Hyperion Data Relationship Management is an evergreen and ever-popular topic. Getting Started with DRM 1-4 is once more in one of the top spots, this year as the second most popular post for 2016. Find out what to do after you have gone through the DRM basics by looking at EPM, on-premise and in the cloud, and how DRM ties it all together in the post, Oracle DRM – Learn It and Use It
Read more >

Reconciling Data What is the Best Approach?
Most organizations severely underestimate what it takes to reconcile data. They often don’t consider how much historical data is needed and other items that need to be accounted for. The best way to make sure data reconciliation is smooth and mostly uneventful, is to take a planned and considered approach. Mike Arnoldy shares his thoughts on this perennially popular evergreen topic in his blog post, The Best Approach to Reconciling Data.
Read more >



About TopDown Team

The TopDown Team includes members of TopDown Consulting who want to let the community know about webcasts, conferences, and other events. The team also conducts interviews on various EPM industry topics.

Leave a Reply

Your email address will not be published. Required fields are marked *