OBIEE Step by Step Guide

May 4, 2010

Migrating BO Linked Universes to OBIEE

Are you trying to migrate your BO universes to OBIEE? First question that comes to mind for everyone is “Is there an automated tool out there that can do this job?”. Sorry! We have no luck here.

Oracle has made lots of money with the Oracle database and creating tools that allow us migrate other non-oracle databases to oracle. Think about SQL Developer Migration Workbench and its vast technical documentation on how easy it is to migrate to Oracle. For more info on SQL Developer Migrations, follow this link.

If Oracle does make lot of money on OBIEE and its associated products, I am sure they are looking at something like this for all the BI migrations.

Coming back to the crux of this post, whats the easy path out there? What If I have complex universes where lot of new metrics have been already defined and developed? Does the same concept and architecture exist in OBIEE. Read this other post for more on this.

What if I have linked universes? Is there a concept like this in OBIEE? To know the concepts of Linked Universes and its associated terms like Derived Universes and the different approaches like Kernal, Master, Component Approach, follow this link. PDF Download Pg 669.

Unfortunately, there is no one to one conceptual match for linked universes in OBIEE. But, you can achieve the same by using multiple approaches in OBIEE. Remember that there is only repository (.rpd) always available online in OBIEE. What does one rpd has? Mutiple subject areas. Can we seperate users based on Subject Areas? Of Course, Yes. Can we create different metrics based on each subject area? Of Course, Yes. But remember, now you are trying to duplicate the functionality available in BO and not understanding the concept of one rpd and one metric definition across all subject areas. So, distinguish your metrics with better naming conventions and with good metadata. Use concepts of Logical Table Sources and Logical Tables carefully so you can mimic the BO universe in functionality and embracing the concept of OBIEE. For more info on Logical Table Sources (LTS), Logical Tables (LT) and Physical tables, follow this link

Until next time, Kudos to all OBIEE evangelists out there !

Advertisements

3 Comments »

  1. hey hari…gud posts

    just wanted to request a feature to subscribe your posts via rss feeds to be able not to read in our rss readers

    regards
    vee

    Comment by vee — May 5, 2010 @ 9:33 am

  2. sorry for edit…. be “able to read” in our rss readers

    Comment by vee — May 5, 2010 @ 9:34 am


RSS feed for comments on this post. TrackBack URI

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: