OBIEE Step by Step Guide

October 19, 2009

Catalog Manager New Features for Merging Presentation Catalogs

Did any one try this new feature available in version of OBIEE for mergeing your web catalog using Catalog Manager.

I have seen people doing it in multiple ways and using some manual methods like UDML, using Copy and Paste and all other workarounds to move your web catalog from one environment to the other i.e. promoting from dev to test, test to qa and qa to prod.

These environment promotions were done manually or semi automatic up until this point. OBIEE Catalog Manager had 2 new features thats worth noting with respect to these migrations. Available since, if you open up your Catalog Manager  under Tools menu, you will find these two new options.

1.  Merge Development with Production

2. Upgrade EBA Catalog.

While the second option, I think, is more catered towards Oracle Apps (EBA –> EBusiness Analytics) catalog promotion, the first one can be used for all generic presentation catalogs that you develop inhouse.


How is this useful? Since most of us have already used MUD and process of checking in and checking out and also use three way merge process, this process falls into the same bucket.

You pick a catalog folder where you have done all your recent changes, choose the folder where you have the archived presentation catalog and then choose your final production presentation catalog. See below what I am talking about.

Open Catalog Manager –> File –> Open Catalog –> In the new dialog box, say Open Offline and choose your presentation catalog where you have made all changes.


Now, once you click “OK” in this dialog box, go to tab Tools –> choose “Merge Development with Production”

The following dialog box pops up asking you for 2 more folders where you have the catalog before changes and also where you do you want to promote the changes.

Lets assume \\BI Team\OBIweb\samplesales has my last merged catalog changes, C:\OracleBIData\web\catalog\samplesales has my latest catalog changes and  \BI Team\OBIwebprod\samplesales has the latest catalog from production.


Now, Click “OK”.

If there are any “Unresolved” conflicts between Development and Prod, the window pops up asking for confirmation of changes and which one do you like to choose.


Pick “Which Catlog Version to keep” .. there are two check boxes next to “Production Modified” or “Development Modified”. If you are sure that you have done all right changes, go for “Development Modified” and click “OK”. Remember that you have to choose for each of the unresolved conflicts. There is no “Apply to All” button. So do it one after the other. I think its better to review these one after the other to see where there are conflicts and how to best resolve them.

This is more of a 3 way merge process that we have done for repository changes… seems like old school? Thats good because now you can use the similar process for repository migration and presentation catalog.

After the process of merge is successful, there is a new pop up which says “Created New Catalog”.

This completes your web catalog migration.

 Next time, we will demonstrate the “Upgrade EBA Catalog” which is almost similar to this but more specific to Oracle Apps.

Comments.. problems .. please share it here….

Until next time, kudos to all OBIEE evangelists


  1. We are just getting into this and have not tried yet.

    Use case is – we want to configuring role based Security in Sandbox and then migrate that configuration to common DEV, TST and PRD without screwing up other Catalog configurations.

    We’ve done our POC successfully where we have role/privilege based access to specific functionality in the run-time Application (e.g. need to be in a certain LDAP groups to have access to Answers)

    Now to migrate only those changes to subsequent environments, is this the best tool to use?

    Comment by Don Isaak — June 9, 2010 @ 7:58 pm

  2. The catalog merging feature is missing from 11g. Do you have any suggestion how to merge two different catalogs other than copy/paste?

    Thank you

    Comment by Georgi — December 15, 2011 @ 6:25 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

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

%d bloggers like this: