|
||
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.