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 !

Blog at