Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« OPM & Outside Processing: When will they meet?? | Main | Oracle's Big Data Entry - Big Data Appliance »

Thinking beyond Hyperion Essbase for planning (Part 1)

Guest post by
Hari Ram, Senior Systems Engineer, Infosys


Oracle Hyperion Essbase provides the best of multidimensional database capabilities in terms of performance and features. The Essbase lovers and existing users may believe that Essbase is sufficient enough for their planning, budgeting and forecasting requirements. Hence most planning applications still exist on Hyperion Essbase instead of Hyperion Planning - the centralized MS Excel and Web-based planning, budgeting, and forecasting solution from Oracle's Hyperion Suite of Products.

Hyperion Planning & Essbase

Hyperion Planning uses Essbase as the database engine to store the numeric data and dimensions, while it needs a relational database for other repository needs. Hyperion Planning leverages Multidimensional functionalities and capabilities of Essbase to the fullest to provide varied planning options along with inherent Data Forms, MS Excel, Web based grid interface for the data entry and reporting needs. It also has Task lists to track various activities and their status during the Financial Planning process. The Process management feature provides an approval process independent of the Organizational hierarchy.

Why Hyperion Planning is not just {Essbase + Excel interface, Task, Approval.... features}?

Handling various types of planning

Typical Financial Planning systems would handle Expense, Revenue, Capex, workforce, Profit & Loss, Balance Sheet, Cash flow...etc. In planning systems built on Essbase, an application would have one database to handle each types of planning. Data, dimension member sharing between two databases would need additional development/maintenance effort.

While working with similar multi-planning type requirement with Hyperion Planning, I found that the idea of plan type reduces the complexity of the solution, user-appraisal when compared to a Standalone Essbase application. Hyperion planning's Plan Types treated as individual databases in underlying Essbase database comes with inherent facility to share data and dimension members across plan types in Hyperion Planning or equivalent databases in underlying Essbase. This reduces the need for additional development/maintenance effort when compared to Planning systems based on Standalone Essbase. The Hyperion Planning user would seldom realize that the dimension members belong to multiple databases. While this might be an area of concern while using Standalone Essbase to build planning system.

  • Multi-Currency application
    As a developer, I find it quite taxing to work with multi-currency applications built on Standalone Essbase. This requires a Currency database, few defined dimensions and also mapping between members in the Currency database with members in the planning database.

Designing a multi-currency application using Hyperion Planning reduces the developer's effort and complexity of thought. The pre-built Currency dimension, Currency Conversion scripts, Exchange rate table that may be specific to a Scenario and Version (allowing one to have different exchange rate for the same year for different scenario). The User interface for Exchange Rate Table makes it so convenient for the Financial Planners & Analyst to work with the system.

  • Varying attributes, Text/date measures
    Something that excited me about the version 11 of Essbase is "Varying attributes". The 'Varying Attributes' feature in Essbase provides a solution to situations, where the relationship between two dimensions varies with an independent dimension. Example, member of Salesman dimension changes with Period, while tracking Sales. Hyperion Planning doesn't support Varying attributes, but such cases can be handled using a flag member.

Another addition in the newer versions of Essbase is Text and Date Measures, in order to track textual values or measure (say Customer Feedback: 'Good', 'Average' and 'Bad'). Initially it sounded like an imitation of Hyperion Planning's Smart View to handle textual data, but Smart List still remains the favorite. Practically, most of the times, I came across cases where we need to capture textual information for more than one dimension (Accounts, Entity...Products, etc..,). Smart List in Hyperion Planning, which can be used with multiple dimensions of any type, scores higher than the Text/Date Measure in Essbase, which can be used with only one dimension.

  • Data Forms
    Financial Analysts and Planners, I worked with, always like to have set of standard data entry/reporting spreadsheet that complements MS Excel (though it has 'rigidity' as a freebie). We spend lot of time fixing issues with the data validation at individual cells, incorporated either by formula or VBA. But the validation and guiding rules would change with the dynamics of the market. Lack of central maintenance of standard spreadsheet, the need to circulate the revised spreadsheet carrying the newer validation rules, throws up a challenge to the efficiency of Change Controller.

Data Forms in Hyperion planning provides a standard centralized grid-based interface for data entry and data-checks. Customizing or fixing a Data Form issues take lesser time and effort compared to the Excel based spreadsheets. It also provides option to have textual comments, annotations, a built in calculator (Supporting Detail), various data allocation and spreading options like Grid Spread, Adjust, Mass Allocate, etc..,) to handle the daily needs of a Financial Planner &Analyst.

In this blog, I tried to share my view on the basic differentiators between Essbase & Hyperion Planning based Financial Planning systems. In Part-2, I will be sharing my thoughts on Data and Process management aspects.

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles