Siebel Business Analytics Applications Upgrade Guide > Upgrading Siebel Business Analytics Applications > Process of Upgrading the Analytics Repository >

Equalizing the Analytics Repositories

The Merge feature in the Analytics Server 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 (SiebelAnalytics_7x.rpd, SiebelAnalytics_78x.rpd, and Customer_SiebelAnalytics.rpd) are equivalent. Equivalence between objects is established by running the equalizerpds executable (equalizerpds.exe) in the \SiebelAnalytics\Bin folder.

The equalizerpds executable file 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. Siebel Systems ships the rename files (MAP) for the most common upgrade paths. You must also create your own rename files for customizations not covered in the files that Siebel Systems 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.

repository2 in case of conflict.

/? Display this usage information and exit.

To equalize a repository

1. Run equalizerpds.exe to equalize the repository from the latest installation (for example, SiebelAnalytics_78x.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

   \\SiebelAnalyticsUpgrade\AfterTrim\SiebelAnalytics_7x.rpd

   -D Administrator

   -E SADMIN -F \\SiebelAnalyticsUpgrade\AfterTrim\SiebelAnalytics_78x.rpd

   -

   O \\SiebelAnalyticsUpgrade\AfterEqualize\SiebelAnalytics_78x.rpd

   -X -J

   rename7x-78x.map

   The MAP files are located in the \SiebelAnalytics\Bin directory or the \SiebelAnalytics\Upgrade directory.

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

2. 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 \\SiebelAnalyticsUpgrade\AfterTrim\SiebelAnalytics_7x.rpd

   -D Administrator

   -E SADMIN -F

   \\SiebelAnalyticsUpgrade\AfterTrim\Customer_SiebelAnalytics.rpd

   -O

   \\SiebelAnalyticsUpgrade\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 \SiebelAnalyticsUpgrade\AfterEqualize directory.