Using the tracing facility
While developing and testing a query template, you can activate the trace facility available in the DrillToPMView.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 journal detail drill through:
After testing the query templates, you should remove the Trace parameter from the DrillToPMView.aspx file.