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

Trimming the Analytics Repositories

This task is a step in the Process of Upgrading the Analytics Repository.

Trimming the repositories reduces the time and complexity involved in the merge process. It also helps with metadata maintenance and performance efforts.

Trimming a repository involves deleting objects that you do not use. You might consider these objects to be irrelevant at the levels of the subject area, logical table, or individual column. Complete this step by either visually inspecting and manually deleting the objects that are not required, or by using the Import from the Repository feature of the Analytics Server Administration Tool.

To determine which objects might be irrelevant, make a list of the reports used by business users, and then in Siebel Answers, determine the subject areas that are used for the different reports. The subject area indicates which presentation catalogs are in use. For instructions on using Siebel Answers, see Siebel Business Analytics User Guide.

To trim the Analytics repositories

1. Copy the three repositories in the directory \SiebelAnalyticsUpgrade\Original into the \SiebelAnalyticsUpgrade\AfterTrim folder.
2. Delete from the three repositories all the presentation catalogs that have been identified as not in use. For example, if you are using Siebel Business Applications and not Siebel Industry Applications, delete all the Presentation Catalogs beginning with Pharma.
3. Using the Query Repository Utility, identify the business models that are no longer in use or will not be used after the upgrade, and delete them in all three repositories:
   1. In the Analytics Server Administration Tool, navigate to Tools > Query Repository.
   2. In the Name field, enter the asterisk (*) wildcard character.
   3. In the Type field, enter Business Model.
   4. Click the Filter button:
      • In the Item drop-down list, select Related to.
      • In the Operator column, select <>.
      • Click the Ellipsis button, and then select Set Condition for Presentation Catalog.
      • Click OK.
   5. Click the Query button.

      A list of the business models that have no related presentation catalogs appears in the window.

   6. Select the business model you want to delete, and then click Delete.
   7. Click Yes to confirm you want to delete the object.
4. Identify the databases that are not in use and that will not be used after the upgrade, and delete them in the three repositories.

   CAUTION:  Do not delete the Siebel transactional database (OLTP) in the physical layer, because it is used by the authorization initialization blocks.

5. Identify the initialization blocks that do not have connection pools, and delete them in all three repositories.

At the end of this process, the three repositories in the \SiebelAnalyticsUpgrade\AfterTrim folder are significantly smaller in size than in the previous stage if the process runs correctly. These repositories serve as the input for the next stage of equalization.