Search code examples
pentahopentaho-data-integrationpentaho-cdepentaho-report-designerpentaho-design-studio

Pentaho- How do I view the backend sql of reports?

I have currently managed to get access to the Pentaho User console and have 4 reports that I plan to migrate to an alternate BI platform ( say Power BI or SSRS)

Within Pentaho user console, I can view the reports, my home page also shows me option to create new report/ Manage data sources.

However, I am unable to view the dataset/ query behind any of these 4 reports. I would like to know which are the tables being referred to in these reports and the basically want to reuse the SQL query.

NOTE- My user console does not show an option to EDIT an existing report.

Any pointers would be really appreciated!

Solution

    1. You can't edit Pentaho Reports(.prpt) in pentaho CDE(BI Server), you have to open the files in pentaho report designer itself.

    2. For dashboards we do have option, every dashboard file will create two other files along with CDE, you can edit the CDA file by going into browse files and execute the query and see the result.