Rittman Mead Blog - Hyperion Essbase

Oracle EPM 11.1.1.3 – Essbase Clustering for High Availability

Its been almost a couple of weeks since i last blogged due to a flurry of events like Open-World, Training Days, Client Engagements etc. Getting the materials completed took most of my time and since then i haven't had a chance to blog. But now that the busiest

Technical

Early News on the Oracle BI Apps - Essbase Integrator

I was recently going through the recorded Open World sessions using Oracle Open World on Demand [http://openworld.vportal.net/], and came across an interesting session by Alaric Thomas and Mike Nader on the forthcoming Oracle BI Applications to Essbase Integrator. This is a technology project going on within Oracle

Technical

Oracle BI EE 10.1.3.4.1 and Essbase Connectivity – Fragmentation on Essbase Sources

In our BI EE – Essbase session in OOW, we covered 2 important use cases in bringing BI EE and Essbase together. They are 1. Horizontal Federation 2. Vertical Federation There is one more use case that only BI EE as a reporting tool can do on an Essbase source(not

Technical

Oracle BI EE 10.1.3.4.1 & Essbase Connectivity – Time Based Aggregation and Multiple Queries

A good question came up on our OOW session the other day on BI EE & Essbase connectivity for a means of doing Time Based aggregation on Essbase cubes. Time Based aggregation is a pretty common requirement while doing an Essbase implementation. For more details on what this means, refer

Technical

Oracle Essbase 11.1.1.3 and BI EE 10.1.3.4.1 – Displaying Member Properties – UDAs, Attributes and Alias Tables

Evaluate based MDX functions in BI EE currently do not support the display of quite a few member properties like Generation Number, Level Number, Alias Tables etc. These member properties can be very useful for reporting and sometimes these member properties drive the formatting of data, reporting layouts etc. Though

Technical

Oracle Essbase 11.1.1.3 – Integration with Relational Sources and Applications

In the past i have covered a wide range of integration possibilities of Oracle Essbase with relational sources. This is probably one area that will always evoke interest as from a reporting perspective it is not always possible to maintain the data in only one source(either be it Essbase

Technical

Oracle Buys (Bits Of) Hyperroll

The news hit the wires last night [http://twitter.com/eddieawad/status/4479863911] that Oracle were buying (certain assets of) Hyperroll [http://www.hyperroll.com], a technology company out of Israel with a head office in the USA. Hyperroll have been around for as long as I've been

Technical

Book Review : "Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Osborne Oracle Press Series)"

I've been talking with Dan Vlamis about a new book that he, Chris Claterbos and some of the Essbase team from Oracle have been putting together on Oracle OLAP and Oracle Essbase. Oracle Press were kind enough to send over a review copy the other week, and so

Technical

Oracle Essbase 11.1.1.3 – Drill-through to BI EE from Smart View – Using Essbase Studio - HOLAP

One of the nice little advantages of using Oracle Essbase Studio is the fact that it manages the relational drill through much better than the Essbase Integration Services. With the advent of Essbase studio, all the metadata for relational drill through is pushed back to the Studio server. So, when

Technical

Announcing Rittman Mead Training Days 2009, London

I'm very pleased to announce details of our second-ever Training Days [http://www.rittmanmead.com/trainingdays2009] event, to be held at the Bloomsbury Hotel [http://www.doylecollection.com/locations/london_city_hotels/the_bloomsbury_hotel.aspx] in London on October 27th - 29th 2009. This year I'

Technical

Oracle BI EE 10.1.3.4.1 & Essbase Connectivity – Repository Design – Enabling drills on Evaluate Columns – Part 1

One of the common questions that generally come up in the BI EE and Essbase integration is, how do we enable drills on Evaluate based columns. I have covered in detail here [http://oraclebizint.wordpress.com/workshop-series/] with regard to the usage of Evaluate based MDX functions. As of the

Technical

Hyperion Essbase 11.1.1.2 – XOLAP – MDX to SQL Conversion – Part 1

One of the interesting aspects of XOLAP is the fact that it exposes Essbase as a dynamic relational aggregation engine. XOLAP to an extent is pretty good in determining what kind of sql should be pushed back to the relational sources and what requires custom in-memory calculations. For example, lets

Technical

Hyperion Essbase 11.1.1.2 – XOLAP – Reporting on Relational and Essbase sources together – Transparent Partitions

In the last 2 blog entries, i had covered 2 new features of EPM 11 Essbase. They were Format Strings [https://www.rittmanmead.com/blog/2009/06/26/hyperion-essbase-11112-altering-measure-formats-format-strings-and-text-measures/] and Varying Attributes [https://www.rittmanmead.com/blog/2009/06/29/hyperion-essbase-11112-varying-attributes/]. In today’s blog entry we shall see another

Technical

Hyperion Essbase 11.1.1.2 – Varying Attributes

Another excellent feature that was introduced as part of the EPM 11 release was the support for varying attributes. Varying attributes help in providing different perspectives of multiple attributes of a dimension over time. One can visualize this as SCD 2 in a relational world. For example, lets take the

Technical

Hyperion Essbase 11.1.1.2 – Altering Measure Formats – Format Strings and Text Measures

If you had read my blog entry here [http://oraclebizint.wordpress.com/2008/12/10/hyperion-essbase-1111-handling-textual-facts-text-list-manager-and-text-measures/] , i would have shown how to go about creating textual measures in Essbase. Though that was a new feature introduced as part of the EPM 11 release, one related feature that i did not

Technical

Oracle BI EE – Bulk Write backs to Essbase – Using JAPI, Global Temporary Tables and UTL_HTTP – Part 2

I had covered an approach here [http://oraclebizint.wordpress.com/2009/05/25/oracle-bi-ee-10-1-3-4-1-writebacks-to-essbase-using-japi-and-custom-html-part-1/] to do write backs into Essbase from BI EE. In some cases that approach would be sufficient. But in most of the cases, end users would want the capability to do a bulk write back similar