OBIEE 11G Catalog Manager Best Practices
The catalog manager is used to manage the OBIEE Presentation Catalog. It stores the content that users create in a directory structure of individual files. This content includes folders, shortcuts, Oracle BI EE objects (such as analyses, filters, prompts, and dashboards), and Oracle BI Publisher objects (such as reports and templates).
Here are the topics that I will be covering in part 1:
- Catalog migration (catalog manager and analytics URL)
- Catalog Search and Replace
Migration Using Catalog Manager:
The migration can be completed from catalog manager by selecting the desired folder and using the ‘file’ menu to ‘Archive’ to any local directory.
The archived folder can be unarchived by using the ‘file’ menu and ‘Unarchive’ to any desired location.
Migration from Analytics URL:
The same catalog folder or report or dashboard can be migrated from the analytics page by using the archive or the unarchive method by using the below button on the ‘catalog’ menu for the selected object.
Catalog Search and Replace:
With our daily rpd changes, sometimes we change the column name on the RPD presentation layer, causing much rework on the web catalog side by manually changing references of the column/table/subject area.
Instead of manually changing the references in all the reports, we can use the Catalog manager’s option of XML Search and Replace for small changes as below.
Option 1: XML Search and Replace
This option is straight forward and easy to use. You should know the change required in the catalog files. To give you an example, I have changed the column name from
‘”Time”.”Month Name”’ to “Time”.”Month ” .
Follow Steps as Below:
- Open Catalog Manager.
- Select the Folder from the catalog tree. I wanted to change it globally, so selected “Shared” Folder.
- Now Navigate to Tools -> XML Search/Replace Option (Ctrl +H)
- New window opens up with options like Old Text/New Text.
- Provide the change as needed. I have changed it from ‘”Time”.”Month Name”’ to “Time”.”Month ” .
Import from file
By selecting the folder which we are trying to update with new column name in the reports by uploading xml file containing below sample data.
<?xml version=”1.0″ encoding=”utf-8″?>
<action command=”renameColumn” oldValue=” Month Name ” newValue=” Month ” ignoreCase=”false”/>
In part 2 of this blog, which will be posted on Thursday, November 17th, I will elaborate on the different ways to change the column datatype formats and to extract the catalog report for any column or report related information.