Oracle^® Business Intelligence Server Administration Guide > Completing Setup and Managing Oracle BI Repository Files >

Comparing Repositories

This section explains how to use the Compare Repositories option in the Administration Tool. It allows you to compare the contents of two repositories, including all objects in the Physical, Business Model and Mapping, and Presentation layers.

If you are using an Oracle BI Applications repository and have customized its content, you can use this option to compare your customized repository to a new version of the repository received with Oracle BI Applications.

For more information about merging the contents of your customized Oracle BI Applications repository with that of a new version of the repository, refer to Merging Oracle BI Repositories.

To compare two repositories

1. In the Administration Tool, open a repository in offline mode.

   The repository that you open in this step is referred to as the current repository. For instructions on opening a repository, refer to Online and Offline Repository Modes.

2. From the File menu, select Compare.
3. In the Select Original Repository dialog box, select the repository you want to compare to the open repository.
4. In the Open Offline dialog box, type the password and click OK.
5. Use the Compare repositories dialog box to review the differences between the two repositories.

   The following list contains the values in the Change column and a description:

   Change	Description
   Created	Object was created in the current repository and does not exist in the original repository.
   Deleted	Object exists in the original repository but has been deleted from the current repository.
   Modified	Object exists in the original repository but has been modified in the current repository.

   The following is a list of some of the buttons in the Compare repositories dialog box and a description of the functionality provided:

   Button	Functionality
   Diff	Differences between the current repository and the original repository.
   Edit 2	Opens created objects for editing.
   Equalize	This equalizes the upgrade id of the objects. If objects have the same upgrade id, they are considered to be the same object. Not available when merging repositories.
   Filter	Opens the Comparison Filter dialog box to allow you to filter the objects that appear in the Compare repositories dialog box by type of change and type of object. You can specify what you want to appear and what you want to be hidden. If you select the check box (Group created and deleted objects), the tool will filter out the child objects of created and deleted objects, allowing you to view only the parent objects. By default, all items are shown.
   Find	Search by an object Name and Type (such as Initialization Block).
   Find Again	Search again for the most recent Find value.
   Mark	Marks the object you select. Boxes appear around created and modified objects. To remove marks, from the File menu, choose Turn off Compare Mode. Not available when merging repositories.
   Save	Saves a list of the differences between the two repositories.
   Select	Allows you to select a repository to compare with the current repository. Not available when merging repositories.
   Stats	Provides the number of changes by Change type. During a multiuser development merge, this allows you to view an overview of the merge decisions that will take place.
   View 1	Opens deleted objects in read-only mode.

Turn Off Compare Mode

This option allows you to remove marks applied to objects while using the Compare Repositories and Merge Repositories options. The Turn off Compare Mode option is only available after you have clicked Mark during the File > Compare action. If no repository object is marked, this option is not available.

To enable the Turn Off Compare Mode

• From the Administration Tool toolbar, select File > Turn Off Compare Mode.