View Only

 Possible to log SQL generated by "Interactive"-style reports

's profile image
posted 06-19-2024 13:44

Hi Folks,

Is there a counter-part to the mondrian-sql.log logging capability for Interactive-style reports?
I don't see anything in server/pentaho-server/tomcat/webapps/pentaho/WEB-INF/classes/log4j2.xml
Is it even possible to configure?

Thanks for whatever you can tell me,

's profile image

This appears to be the only way to do it (via the Pentaho User Console--which isn't much help when Pentaho is embedded in another application which supplies values to placeholders in the SQL):

The admin user can access the SQL used in a PIR report by doing the following.
- Create a new Interactive report.
- Drag some fields onto the workspace.
- Right click on the header tool bar of the report, select the option View SQL from the list.
- The SQL query will be displayed.