Merging Repositories

When working with Oracle BI EE, although you can use many data sources, you can only have one repository file (RPD) loaded.

If you are using an existing repository and have customized its content, you can perform a manual merge of the customized repository with the new Oracle Financial Management Analytics repository.

To merge the repositories, you create a new blank repository, and merge both the existing repository and the new Oracle Financial Management Analytics repository into the new one.

  To merge an existing repository file (RPD) with the new Oracle Financial Management Analytics RPD:

  1. Optional: Create a blank repository to serve as the original repository in the merge, if you do not already have one:

    1. In the Administration Tool, select File, then select New Repository.

      The Create New Repository Wizard is displayed.

    2. Enter a name for the repository, such as blank. The file is saved with the .rpd file extension.

    3. For Import Metadata, select No.

    4. Enter and confirm the repository password to be used for this repository.

    5. Click Finish.

  2. Close the blank repository.

  3. Open the existing repository that contains the objects that you want to merge with the Oracle Financial Management Analytics repository.

  4. From the Oracle BI EE Administration tool main menu, click File, then Merge.

    The Merge Repositories wizard is displayed.

  5. In the Select Input Files screen, for Merge Type, select Full Repository Merge.

  6. Click Select next to Master Original Repository.

  7. Navigate to the location of the new blank repository file as the original repository, and then click Open. Enter and confirm the repository password created in step 1.

  8. Click Select next to Modified Repository.

  9. Navigate to the location of the modified repository file, and then click Open. This is Oracle Financial Management Analytics repository into which you want to import objects from the existing repository.

  10. In the appropriate Password field, enter the password for the modified repository.

  11. Optional: Click Select next to the Save merged repository as field to change the default name and location of the saved (merged) file. Enter a new name and location.

  12. Click Equalize during merge to maintain IDs during the merge operation, and then click Save.

  13. Click Next.

    If there are any conflicts, the Define Merge Strategy screen of the Merge repository Wizard is displayed.

    If there are no conflicts, the Merge Wizard continues automatically with the merge process, and then closes automatically when finished.

    The Define Merge Strategy screen displays a decision table that shows conflicts for this merge.

  14. From the Decision List, decide whether to include or exclude objects from the merged repository, and select Current or Modified .

    When you select an object in the decision table, the read-only text box below the Decision Table describes what changes were made to that object in the current repository.

    After you make a merge decision, the row for that decision in the table changes from red to black. When all rows have a value in the Decision field, the Finish button is enabled.

  15. Click Finish.

For additional information about the merging repository files, see the Oracle® Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition.