Clarity

When you click on a report link under Advance Reporting, what processing happens on application server and what processing happens on jasper report server. If there is any slow performing queries, that gets executed as part of the report, will the impact be on Jasper report server OR the application server. Is there any document detailing what happens when user executes a Jasper reports from CA PPM Application Server

When we navigate to Advanced Reporting information like user, language, locale, UI theme, etc. are passed to the JasperReport Server and the navigation in the report server, including permissions, is handled by the report server. When running reports from PPM (Reports and Jobs), the report execution is still handled by the JasperReport Server, however, in this case it is accomplished via API calls. Once the report is executed by the report server, the output is transferred to the Application Server.

When we work with ad hoc views or run reports (ad hoc or Studio reports), we access the database schema via Bean Data Source. The CA PPM Data Warehouse is the main data source of the advanced reporting solution. The data warehouse schema is optimized specifically for reporting and analytics. 

To avoid performance issues, we recommend that you write reports against a data source and not against the domain layer. We also recommend that you write all reports against the Data Warehouse data source. Use the CA PPM Database as your data source only if the required data is not available in the Data Warehouse. Performance is better when you use the Data Warehouse data source.

Also if you want to troubleshoot slow then either you can enable Jaspersoft logs(not applicable on SAAS) and take it forward.

Also can you please let me know which version of PPM you are in?

Regards

Suman Pramanik 

Thanks Suman for the explanation. I have 2 more question based on your response.

1. What happens when user exports the output after it is sent to application server. The processing of export is done at application server or jasper server?

2. When you say  "To avoid performance issues, we recommend that you write reports against a data source and not against the domain layer. " ,  I assume you are referring to regular reports NOT ad-hoc reports. All our regular reports are against data-source, but all ad-hoc reports are against domains, Topics or views. Is there a way to create ad-hoc reports directly against data source?

Thanks

Satish

When you export any report (either adhoc or studio) it will fetch the latest data from database and process the export. 

Yes Adhoc reports will be on domains, but we recommend not to write Studio report on Domains 

Everything related to Advance Reporting is documented here Advanced Reporting with Jaspersoft - CA PPM - 15.3 - CA Technologies Documentation 

Regards

Suman Pramanik