Hey Robert! Thanks for sharing your experience with the report in your portal section - I imagine that was quite frustrating to deal with. My name is Ashley and I'm from the Kurve team.
The large size of this particular report being on a page shared by multiple users sends requests to TRIRIGA that TRIRIGA's API ultimately cannot handle - resulting in the system-wide performance issues you encountered.
There are shared sentiments that safeguards should be in place to prevent the system from experiencing performance issues and we are actively collaborating with IBM to classify and solution on the issue.
In the meantime, we do have a couple suggestions to alleviate what you're experiencing in the portal section:
1. Have 'Query Filters' created on the report so that it isn't auto-run for each user when they land on the portal. The user can click "skip" or pre-filter the data which would reduce the resources required while providing a more specific view.
2. Reduce the underlying TRIRIGA query size so that the request isn't as large, therefore, not requiring as much memory to run. System Filters, like dynamic date ranges, could be helpful in achieving this.
To speak to your use case in particular, if you find that the need is to pull all 500k records at one time, there are other tools better suited for especially large datasets. The general rule of thumb is that TRIRIGA Reporting can do 80% of your ad hoc, everyday reporting needs. The 20% that falls out of TRIRIGA Reporting scope, like large historical data pulls, should be created with an external BI tool.
TRIRIGA Reporting was built to handle ad-hoc request sizes based on the available resources from TRIRIGA and each environment's unique setup.
------------------------------
Ashley Walter
------------------------------
Original Message:
Sent: Fri June 14, 2024 08:56 AM
From: Robert Binion
Subject: Performance issues when making TRIRIGA Advanced Report available as a Portal Section on Dashboard
We have built an Advanced Report that hits a table containing about 500,000 rows. When we load the report in Advanced Reporting, the query runs, and the report renders in about 15 seconds. We attempted to make this report available as a portal section for a specific security group to add to their native TRIRIGA dashboard (about 30 users). WE encountered two issues: the report would never load as a portal section, and when multiple users from that security group logged in, it caused massive system-wide performance issues to the point that we had to restart servers and delete that portal section to restore our system. Have others found ways to successfully embed Advanced Reports in native TRI portal sections?
Thanks!
------------------------------
Robert Binion
------------------------------