Using the tracing facility

While developing and testing a query template, you can activate the trace facility in the SQLDrillQuery.aspx file. Tracing displays the specific query generated with parameter values from the data cell in the CPM report.

To use the tracing facility for custom drill through:

  1. On the server computer, go to the Program Files\Infor\CPM\Web\Workstation directory.
  2. Make a backup copy of the SQLDrillQuery.aspx file.
  3. Using a text editor, open the SQLDrillQuery.aspx file.
  4. Add the Tracing parameter to the first line of the file. For example:
    <%@ Page Language="C#" AutoEventWireup="true" Trace="true" CodeBehind="SqlDrillQuery.aspx.cs" Inherits="Infor.PM.Workstation.UI.SqlDrillQuery" %>

    CodeBehind="SqlDrillQuery.aspx.cs" Inherits="Infor.PM.Workstation.UI.SqlDrillQuery" %>

  5. Save the changes and close the file. When you open the CPM report, the request details and trace information are shown at the bottom of the page.

After testing the query templates, you should remove the Trace parameter from the SQLDrillQueryaspx file.