QPR Knowledge Base 2014.1

Installing QPR Metrics Integration Kit

Installing QPR Metrics Integration Kit

Previous topic Next topic  

Installing QPR Metrics Integration Kit

Previous topic Next topic JavaScript is required for the print function  

QPR Metrics Integration Kit provides a set of QPR data queries for building different kinds of custom analysis and reports. QPR Metrics Integration kit requires that Microsoft SQL Server is used.

 

QPR Metrics Integration Kit is installed by running database scripts to database. The database scripts are located under the Add-Ons\QPR Metrics\Integration Kit folder of the QPR Suite delivery package.

1.Start your favorite SQL Query tool.
2.Log on to database with the same login id as QPR products are using.
3.Open the following files and execute them in the order they are listed:

Metrics_Import_ValuesSQLServer.sql

sql_QPR_ReportingViews.sql

sql_QPR_ReportingProcedure.sql

sql_UMS_PopulateActionReportingTable.sql

sql_QPR_ReportingJobs.sql

 

See the QPR - Developer's Guide for descriptions about the tables and views the QPR Metrics Integration Kit creates.