Siebel Applications Administration Guide > Upload of UPT and UPT-IRM Intersect Data > Process of Uploading and Intersecting Data >
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 To upload UPT and UPT-IRM Intersect data to a Siebel CRM database.
NOTE: Create a separate folder, such as C:\IRMFiles, in which to copy the IRM files.
- 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.
|