You can use the debug mode to view what data is passed to your Excel template.
Overview of debug mode
When running an Excel report in the debug mode, PPM replaces the report output by a list of all the data available in the Excel template. The data includes:
- All fields submitted when creating the report (with token name, code value, and visible value – also called meaning, with the token prefix V)
- Information on the user that submits the report and time of submission. This information is automatically passed to every report.
- All built-in objects available in the template to run SQL queries and get data from dashboard data sources.
- Every data added by a Java Preprocessor.
You can find the result of the first example report run in Debug mode in
Samples\3 - Debug mode\1 - Report run in Debug mode.xlsx.
Run Excel report in debug mode
To run an Excel report in the debug mode, in the report type, add the line
DEBUG=true anywhere between the first and the last command step. As long as this parameter is present and set to
true, the report will be run in the debug mode.