How To Migrate OBIEE Reports Between Web Catalogs

The easiest way of migrating across Web Catalog objects is to use the Catalog Manager application that comes with OBIEE 10.1.3.2 and higher. You’ll be using the copy and paste feature of the tool to copy across the items, so first of all start up Catalog Manager and connect to the Web Catalog that has the objects you wish to migrate. Locate the first of the objects (or a folder, if there’s a whole set of requests to migrate), and select Copy from the application toolbar.

Then, either close this catalog and open one you want to copy to, or start another copy of Catalog Manager, and paste the objects into the other catalog.

As an alternative to the GUI, you can copy individual requests, dashboards or whole folders using filesystem copies. If you locate the catalog you wish to copy from in your filesystem – for me, it’s at C:\product\OracleBIData\web\catalog\paint\, you can copy whole folders across to your other catalog, or individual requests, as they are (from 10.1.3.2 onwards) stored as individual XML files within a catalog filesystem.

Be sure to copy both the report XML file (in the format report+name with no file type suffix) and the accompanying attribute file (the same file name, with a .atr as a suffix) to the new catalog, the first file contains the report criteria definition in XML format whilst the accompanying attribute file contains the name of the request owner, the access control list and so on. Once you’ve copied these files across, they will appear in the new Web Catalog and will run as long as the relevant logical tables are present and correct in the RPD file.

Source: Rittman Mead