Business Intelligence – Oracle

Archive for April 22nd, 2008

Hyperion Data Integration Management (DIM) – An option for loading data into Essbase cubes – First Impressions

Posted by Venkatakrishnan J on April 22, 2008

Before Oracle actually acquired Hyperion, Hyperion and Informatica had an OEM agreement(this is still in place like the OEM between Oracle and Informatica for BI Applications) which allowed Informatica to load data directly into Essbase Cubes. Also, Hyperion rebundled the software (under the purview of the OEM) as Hyperion Data Integration Management. What this suite basically does is, it provides ETL options to a variety of Hyperion related products like Essbase, Planning and Financial Management. This suite basically contains the following components.

     1.   Informatica PowerCenter Client
     2.   Informatica PowerCenter Server
     3.   Informatica PowerCenter Repository Server

Also, it contains adapters to the following Hyperion Components

     1.   Hyperion Enterprise
     2.   Hyperion Essbase
     3.   Hyperion Planning
     4.   Hyperion Financial Management
     5.   Hyperion Translation Manager

Using the above adapters, one can load data directly into Essbase, Planning etc using the Informatica. On the same lines, Oracle Data Integrator (formerly sunopsis) also has the above adapters. You can download the above components from Edelivery. Remember to read the licensing aggrement atleast once since this entails the use of a third party software (Informatica). The installation of the software is pretty straightforward. All we would need is to install the DIM first and then followed by the adapters. Then the adapters would have to be registered with the repository server in order for the connections to work. The architecture for the Hyperion Data Integration Management is shown below

    

One of the very good features of the Hyperion Data Integration Management is that it has the capability to automatically normalize an Hyperion Cube i.e if you want to load a data warehouse from a Hyperion Cube, all you would have to do is to use the Normalize option which would automatically split the cube into its corresponding dimension and Fact tables. For example. look at the screenshot below. This shows you a simple cube containing the Products and Channels Dimensions. As you would see at a high level, it contains the cartesian product of all the dimension attribute values (very similar to what we have in OLAP Views of Oracle OLAP). I just hope we can have this feature out of the box (instead of going through an adapter).

    

Below is another sample screenshot showing how the normalization would split up the cube into its corresponding relational sources (based on the demo application).

    

I can imagine a lot of use for this DIM product since it has excellent Administration as well as Data Load/Unload capabilities on a Hyperion Essbase Cube. I believe ODI (Oracle Data Integrator) also has this capability. Yet to give that a whirl. To summarize, there are different ways of loading data into an Essbase cube. They are

1. Using Hyperion Administration Services
2. Using Hyperion Integration Services
3. Using Hyperion Data Integration Management and its Essbase Adapter
4. Using Oracle Data Integrator and its Essbase Adapter

Depending on your needs/environment, you have that flexibility to use the tool of your choice. In later blog entries lets see how to go about loading an Essbase Cube using the Hyperion DIM product. 

Advertisements

Posted in All Posts, Hyperion Essbase, Informatica | 9 Comments »