Business Intelligence – Oracle

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. 

About these ads

9 Responses to “Hyperion Data Integration Management (DIM) – An option for loading data into Essbase cubes – First Impressions”

  1. [...] the rest of this great post here Author: Time: Tuesday, April 22nd, 2008 at 4:25 am Category: Management Comments: You [...]

  2. [...] Venkatakrishnan J wrote an interesting post today on Hyperion Data Integration Management (DIM) – An option for loading …Here’s a quick excerptBefore 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 … [...]

  3. [...] by Venkatakrishnan J on May 8, 2008 As i had written previously here, one of the methods of loading Essbase cubes is by using the Hyperion Data Integration Management [...]

  4. Subhendu said

    Nice article.

  5. seidy said

    Thanks for the post. I am trying to get data from an essbase cube into oracle. You mention using the normalization option to break a cube into its fact and dimention tables. This is exactly what I need to do. I am new to informatica and Hyperion but the guys on my team say they need to build a source for each dimension and then they are downloading the fact by using a report script. Your way looks so elegant. Can you help explain? I cant find a “normalize option” do you mean the normalizer tool?

    Thanks

  6. Thanks for the post – this gives me a pretty good idea of where to start. Although I am wondering if you have compared this to any of the open source solutions out there? We’re currently taking a look at Jitterbit’s data integration solution. Not quite sure if it will work, but it looks promising. Others are Kettle and Pentaho?

  7. Pedro Ferrari said

    Hello,

    I need to make a dataload using “add to existing values” in Essbase using DIM interface.
    Where can I set this in DIM?

    Thanks,

  8. The style of writing is quite familiar to me. Did you write guest posts for other bloggers?

  9. Pedro Ferrari said

    I never asked about Hyperion.
    I worked with HAL and now I have that to use DIM or ODI.

    Sorry, I’m brazilian and I don’t know to speak English, ok?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 151 other followers

%d bloggers like this: