OBIEE 10g - repository merge help

Question

Hello, experts.

I'm hoping that you may be able to help me with details of a repository merge.

Specifically, I'd like to bring in only particular presentation catalogs from one repository (repo B)  into the other repository (repo A).

I'd like to keep repo A as it is -- all objects (presentation, BMM and physical) remain the same.  The entire repo A will move into the merged repository.

I'd like to merge only certain presentation catalogs from repo B into repo A.

Please note I'd like only the presentation catalogs to move as well; the BMM and physical layers of repo B will be excluded from the final repository.

I've tried different combinations of the two-way merge and three-way merge to accomplish this, but I'm having difficulty getting only the presentation catalogs of repo B to move.

I've tried opening both repositories and copying/pasting the presentation catalogs.

Reviewed many different posts on this topic, but this one seems most relevant.

Unfortunately, I have yet to find a merge combination that pulls the content together as I'd like -- without manual work of deleting different objects from the merged repository.

Any tips/suggestions are welcome and much appreciated.

Thank you - Fritz

Fritz Skinner · Answer

Have gotten traction on this issue, sharing in case others experience similar issues.

After equalizing the repository objects, I am able to copy presentation tables from repo B to a presentation catalog in repo A.

There were a couple issues that I needed to overcome:

1) equalizing is best practice to ensure that similarly named objects in BMM and physical layers have the same underlying upgrade ID -- so admin tool sees those as same object.

2) the copy of an entire presentation catalog was failing because there were elements (presentation columns) -- which had different logical sources.  Those I am reconciling and recreating manually.

Thanks for weighing in and helping out.

Fritz

Fritz Skinner · Answer

In the spirit of sharing (and hopefully progress), it looks as though -- in my situation -- it will be necessary to first equalize the rpd objects which are the same between repo A and repo B.  Here's a post that I've found helpful.

Will update as more experience is available.

Fritz

Fritz Skinner · Answer

I'm doing copy-then-paste on Windows - so it's right clicking a catalog content and copying, then right clicking and pasting into the other repository.  Admin tool does not seem to like it.  Merge feature is typically how I'd bring this data together.

Yes, the necessary business model is present in the BMM of repo A to support the presentation catalogs of repo B.

Thanks again for considering and weighing in, Srini.

Fritz