Oracle Warehouse Builder 11gR2 – Importing Essbase Cubes using ODI Knowledge Modules – Part 1

Wednesday, March 17th, 2010 by Venkatakrishnan J

One of the new features introduced in OWB 11gR2 is the ability to import metadata objects through JDBC drivers. So, as long as we have an external API providing the JDBC interface to OWB, OWB should be able to leverage that and import the metadata through the API. For example, David Allan, one of the [...]

Oracle BI EE 10.1.3.4.1 – Modeling Measure Dimensions on Relational Sources – Essbase Style

Wednesday, February 3rd, 2010 by Venkatakrishnan J

One of the biggest differences between Essbase and most other reporting/OLAP tools like BI EE/Oracle OLAP etc is in the way Measures are treated(comparison only in terms of data modeling and reporting and not on physical implementation). In Essbase, every data/value(cell) is attributed by a set of dimensions. Even a measure is considered as an [...]

Oracle EPM 11.1.1.3 – Life Cycle Management – Part1 – Essbase Migration

Tuesday, January 5th, 2010 by Venkatakrishnan J

One of the major issues that i commonly encountered while doing 9.3 based essbase implementations was the fact that there was no built in utility within the Hyperion stack that could migrate various applications from a Development to a Test/Production machine(not essbase alone but also other related components like Shared Services etc). I still remember [...]

Oracle EPM 11.1.1.3 – Installing Hyperion Components on Multiple Machines

Friday, December 11th, 2009 by Venkatakrishnan J

In any EPM deployment, rarely do all the components get installed on a single machine. In majority of the cases, you will see that each component is actually installed on separate machines with their own application and web servers. So, how does this all work and how do we go about installing various EPM components [...]

Oracle BI EE 10.1.3.4.1 & Essbase Connectivity – Enriching Essbase reports with relational attributes

Tuesday, November 24th, 2009 by Venkatakrishnan J

If you had attended our training days event or one of our Open World sessions, you will have noticed that we had covered the various aspects of integration between Essbase and relational sources using BI EE. The presentations are available here. One of the scenarios that we had not covered was the ability to display [...]

Website Design & Build: tymedia.co.uk