When FDM Isn’t an Option…Using Essbase to Map Data

data mapping, Essbase, FDM, Financial Data Management, Planning & Essbase

There are times when you do not have an option of using FDM to do large data mapping exercises prior to loading data into Essbase. There are many techniques for handling large amounts of data mappings in Essbase, I have used the technique oultined here several times for large mappings and it continues to exceed my expectations from a performance and repeatability perspective.

Oracle Business Intelligence Essbase Cube Builder: Continued Integrations with Essbase and OBIEE

BI Reporting, EPM, Essbase, Multi-Dimensional, OBI Answers, OBI Interactive Dashboards, OBI Publisher, OBIEE, Oracle 11g, Oracle BI Administration Tool, Oracle Business Intelligence Enterprise Edition, Oracle Hyperion, Planning & Essbase, Relational, Smart View, Smartview

Oracle has been busy focusing on improved consolidation of their BI applications this past year. This next offering within Oracle's arsenal of BI apps will allow for enhanced integrations between the multi-dimensional and relational worlds of Essbase and OBIEE. The new application is called Oracle Business Intelligence Essbase Cube Builder (OECB) previously referenced as Oracle Essbase Integrator (OEI) during beta testing and its purpose will help refine and make for more consistent binary integrations. OECB will permit OBI apps to push metadata and data into Essbase cubes, a significant advancement for OBIEE users where leveraging in-depth ad hoc and what-if scenarios can be available. You can download OECB on the Oracle e-delivery site:

ORACLE HYPERION CALC MANAGER – Part 4 – Creating RuleSets

calc manager, Calculation Manager, Essbase, HFM, Hyperion, hyperion experts, Oracle Hyperion, Planning, Planning & Essbase

In Part 1 of this series, we introduced Calc Manager, providing a general overview and explanation of some new terms.  In the second post we walked through the development of a Planning rule that utilized a run time prompt.  Part 3 covered templates available with Calc Manager.

ORACLE HYPERION CALC MANAGER – Part 3 – Working with Templates

calc manager, Calculation Manager, Essbase, HFM, Hyperion, hyperion experts, Oracle, Oracle Hyperion, Planning, Planning & Essbase

In Part 1 of this series, we introduced Calc Manager, providing a general overview and explanation of some new terms.  In the second post in the series, we walked through the development of a Planning rule that utilized a run time prompt.  In this post, we’ll explore templates provided within Calc Manager.

ORACLE HYPERION CALC MANAGER – Part 2 – Creating a Planning Rule

calc manager, Calculation Manager, Essbase, HFM, Hyperion, hyperion experts, Oracle, Oracle Hyperion, Planning, Planning & Essbase

In Part 1 of this series we introduced Calc Manager, providing a general overview and explanation of some new terms.  In this post, we will walk through the development of a rule for Hyperion Planning using the graphical interface within Calc Manager.

ORACLE HYPERION CALC MANAGER – Part 1

calc manager, EPMA, Essbase, HFM, Hyperion, Oracle, Oracle Hyperion, Planning, Planning & Essbase

With the continued investment in the Hyperion tool set by Oracle, there was a desire to centralize the development of calculations for HFM, Essbase, and Planning.  As a result of this, Oracle Hyperion Calculation Manager was born.  Calc Manager is a powerful tool for developing and administering rules for Planning and Essbase.   An intuitive graphical interface is available to help in the development process, helping to expedite movement through the learning curve for people just beginning to dip their toes into the world of Oracle Hyperion Planning and Oracle Essbase.

Using Hyperion Essbase to Report Comparable Store Sales

BI Reporting, comp sales, comp store, comparable store sales, comps, Essbase, Hyperion, Oracle, Oracle Hyperion, Planning & Essbase, reporting

One of the commonly used measures in the retail industry is “comps” – comparisons of actual sales for this year versus last year.  The goal of reporting comparable store is to provide information on what portion of a company’s sales comes from increasing sales growth in existing stores versus opening new stores.   This metric is used to measure whether a company’s sales will continue to grow when store base reaches a saturation point, or the company slows expansion.

Special uses for Life Cycle Management (LCM)

1, EPM, EPMA, Essbase, HFM, Hyperion, LCM, Life Cycle Management, Oracle, Planning, Planning & Essbase

In my previous post, I showed how to use LCM to back up or copy an entire planning application environment.  Here I’ll expand on that subject a bit by showing some other uses you may find handy.  This is by no means meant to be an exhaustive collection – just a few suggestions you may find useful and which may provoke ideas for other uses.

Using Oracle's Hyperion® Life Cycle Management

EPM, EPMA, Essbase, HFM, Hyperion, LCM, Life Cycle Management, Oracle, Oracle Hyperion, Planning, Planning & Essbase

What is LCM?

LCM (Life Cycle Management) is a tool which can be used to migrate Hyperion applications, cubes, repositories, or artifacts across product environments and operating systems. It is accessed through the Shared Services Console.

Business Intelligence Technology Environment – Welcome to the Buffet

1, BI, BI Reporting, EPM, Essbase, FDM, Fusion, HFM, OBIE, OBIEE, ODI, Oracle, Oracle DRM, Oracle Hyperion, Planning & Essbase, Shared Services, System 11

Business Intelligence Technology Environment or BITE is my own little tag line and acronym (maybe I should copyright it) to express the host of solutions available in the Business Intelligence application world today. (It could also be used as a verb to describe the plethora of poorly designed solutions… ahh but that is another story.)

About Edgewater Ranzal

Edgewater Ranzal is an integrated Business Analytics solution provider deeply rooted in Enterprise Performance Management (EPM). Coupled with our Business Intelligence (BI) and Big Data (BD) expertise, we provide holistic solutions that help organizations define, measure, and innovate their business, provide a clear vision, and drive business value.

Subscribe to Email Updates

Recent Posts

Posts by Topic

see all