QPR Knowledge Base 2016.1

Installing QPR Metrics Integration Kit

Installing QPR Metrics Integration Kit

Previous topic Next topic No directory for this topic  

Installing QPR Metrics Integration Kit

Previous topic Next topic Topic directory requires JavaScript Mail us feedback on this topic!  

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.