InterSystems Reports: How to allow Support to run your report for troubleshooting

Support is helping you troubleshoot a report. They want to reproduce a problem in their local system. Too bad they can't run your report, because the JDBC data source connection will fail. Or... is there a way?  

There is a way to run a report offline, with no access to the source database. You must provide a cached query result exported from Designer. This is a file containing report source data. Support will use this to override the report's data source. When they run the report, it will get data from the file, rather than the JDBC connection. 

Clarification

This has nothing to do with the IRIS BI query cache. 

How to send a report with a cached query result

1. Zip and send the entire catalog folder. Indicate which report you are testing. 

2. Open your report in Designer. In the Data panel on the left, right-click the dataset and choose Create Cached Query Result. If the report has multiple datasets, do this for each one.  Send the exported files. 

Disclaimer

Do not send a cached query result containing confidential data. 

Documentation

Logi Cached Query documentation (v18)