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.
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:
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.
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.
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.
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.
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.
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.)