Intersecting UPT and UPT-IRM Data

To view and analyze the .csv files, you can view them in any supporting editor or upload them to the Siebel CRM database. For more information on how to view UPT and IRM data on the Siebel CRM database, see Analytical Reports for UPT and UPT with IRM Intersection.

Performing an intersect of the UPT and IRM data provides:

A list of objects from the UPT-IRM intersect indicating those that are used and modified and, therefore, require testing.
Prebuilt reports, such as UPT-IRM Intersection, after loading data on OBIEE.
UPT raw data to use with any analytics tool to generate custom reports.

To intersect UPT and UPT-IRM data

Perform the steps shown in Uploading UPT and UPT-IRM Intersect Data.
Note: Create a separate folder, such as C:\IRMFiles, in which to copy the IRM files.
- Download the IntersectUPTMrg.jar to the same folder if you want to use the command prompt to intersect the .csv files or use the data upload utility for user interface indicated in Uploading UPT and UPT-IRM Intersect Data.
Navigate to the folder where you downloaded the utilities.
Intersect the UPT and IRM files from the file folders where they are stored.
- To intersect the .csv files from the command prompt, enter the following command:
```
java -jar IntersectUPTMrg.jar /u [CSV files folder path] /m [IRM files folder 
path] /l compareCSV.log /o [output folder]
```
  For example:
```
java -jar IntersectUPTMrg.jar /u C:/UPTFiles /m C:/IRMFiles /l compareCSV.log /o 
upt_mrg
```
- To upload from user interface, invoke the data upload utility for user interface and navigate to the IRM tab.
The utility creates the upt_mrg folder in the same folder as the .jar of the utility and places the merged files in it.
Note: These files will be used for further reporting and analysis as outlined in Analytical Reports for UPT and UPT with IRM Intersection.