Oracle^® Business Intelligence Applications Upgrade Guide > Upgrading Oracle BI Applications > Process of Upgrading the Siebel Analytics Repository >

Equalizing the Analytics Repositories

The Merge feature in the Administration Tool relies on a change detection algorithm to determine the changes that need to be made to upgrade repositories correctly. For the algorithm to work correctly, it has to determine which objects in the three repositories (for example, SiebelAnalytics_7x.rpd, OracleBIAnalyticsApps.rpd, and Customer_SiebelAnalytics.rpd) are equivalent.

The point of this step is to determine for every object in the OracleBIAnalyticsApps.rpd and the Customer_SiebelAnalytics.rpd whether it is coming from the SiebelAnalytics_7x.rpd.

Equivalence between objects is established using the Administration Tool's Equalize feature. The file that you specify in the Output option (-O) is the only file that is modified during the equalization process.

The Equalize feature has several mechanisms for determining whether an object in two different repositories is semantically the same:

• Fully Qualified Name. If an object in one repository has the same fully qualified name as another object of the same class in another repository, then the two objects are declared equal.
• Simple String Substitution. Equivalence can be declared between two objects of the same class in two repositories whose only difference is that some key characters in their names differ. The equalizerpds executable file ignores those characters while checking fully qualified names. For example, "Core"."W_DAY_D" might be considered equivalent to "Core"."W DAY D" if the characters "_" and " " have been declared as equivalent.
• Rename File. When none of the preceding rules are applicable, equivalence can be manually declared using a script as input to the equalizerpds executable file. Oracle ships the rename files (MAP) for the major releases. The files are located in the OracleBI\Upgrade folder. You can also create your own rename files for customizations not covered in the files that Oracle ships. You can open and edit the rename files in Microsoft Excel.

The syntax of the equalizerpds command is as follows:

equalizerpds.exe -A userid1 [-B [password1]] -C base_repository_name -D userid2 [-E [password2]] -F repository2_name [-J udml_utf8_file_name_equalization] [-O ouput_repository_name] [-X] [-Y equalStringSet]

-X Treat 'Factxxxx' as 'Fact' in Business Model.

-Y Treat the characters as equals.

/? Display this usage information and exit.

To equalize a repository

1. Copy the appropriate MAP file from the OracleBI\Upgrade folder into the folder where you will execute equalizerpds.exe, for example, \OracleBIUpgrade\Original.
2. Run equalizerpds.exe to equalize the repository from the latest installation (for example, OracleBIAnalyticsApps.rpd) with the original repository (for example, SiebelAnalytics_7x.rpd). An example of the equalizerpds command is as follows:

   equalizerpds -A Administrator -B SADMIN
   -C \\OracleBIUpgrade\Original\SiebelAnalytics_7x.rpd
   -D Administrator -E SADMIN
   -F \\OracleBIUpgrade\Original\OracleBIAnalyticsApps.rpd
   -O \\OracleBIAnalyticsUpgrade\AfterEqualize\OracleBIAnalyticsApps.rpd
   -X -J rename7x-79.map

   The MAP files are located in the \OracleBI\Upgrade folder.

   If the equalizerpds.exe executable file runs correctly, no errors are returned.

3. Run equalizerpds.exe to equalize your customized repository (for example, Customer_SiebelAnalytics.rpd) with the original repository (for example, SiebelAnalytics_7x.rpd). An example of the equalizerpds command is as follows:

   equalizerpds -A Administrator -B SADMIN
   -C \\OracleBIUpgrade\Original\SiebelAnalytics_7x.rpd
   -D Administrator -E SADMIN
   -F \\OracleBIUpgrade\Original\Customer_SiebelAnalytics.rpd
   -O \\OracleBIUpgrade\AfterEqualize\Customer_SiebelAnalytics.rpd

   The execution of equalizerpds that equalizes the customer repository with the original repository does not use the rename file.

   Make sure that the original repository is copied unchanged into its new location so that after running the script, all three repositories are contained within the \OracleBIUpgrade\AfterEqualize directory.

4. To verify the process completed successfully, compare the size of the repositories. The output repository (-O) should be close to the same size as the repository you equalized (-F).