In this era of big data and predictive analytics, the Facilities Management industry has undergone a sea change in terms of data management and utilization… In such a scenario, the question arises as to whether the in-app reporting features offered by these tools, like the Report Manager offered by IBM TRIRIGA, are comprehensive enough for the purposes of strategic management and analysis. In order to analyze whether IBM TRIRIGA ad-hoc reporting capabilities can satisfy the reporting requirements of your business, you first need to recognize its scope and limitations…
The idea behind ad-hoc reporting is to enable users to create their own report. They should be able to decide on the fields, sorting, or grouping that they might require in their report. By letting the user decide on these criteria, ad-hoc reports ensure that a significant portion of the development time is freed, since the developer no longer needs to produce reports based on individual report requirements.
By and large, IBM TRIRIGA ad-hoc reporting, in itself, should be comprehensive enough for most businesses. But on the other hand, if extensive formatting is what you need, the IBM TRIRIGA ad-hoc report manager may not be enough. IBM TRIRIGA has sought to overcome this limitation by integrating with Eclipse BIRT. Business Intelligence and Reporting Tools (BIRT) is an open source reporting and business intelligence tool which IBM TRIRIGA advanced reporting uses to create data visualizations and reports. Using an IBM TRIRIGA plugin for the BIRT application, you get to experience the power of data mining and predictive analytics, right there, in your IBM TRIRIGA Report Manager…
[Admin: This post is related to the 09.28.16 post by ValuD about when to use OOB in-app reporting versus BIRT reporting.]
I need to know if there is any other documentation available to get an in-depth knowledge of BIRT? I’m trying to do something fairly simple. I want to write a report that prints out our work orders. I can’t get the associations (triResources) to show up in the report. I know I’m missing something fairly obvious, but I have been researching this for several days and I can’t get access to associated data. I have both queries listed as data sets but can’t get them to link together.
Has anyone had any success with any other programs, besides Crystal, to push reports to specific printers without creating a separate report for each printer?
When running a BIRT report, you get a stack trace error in the front end telling you that the report does not exist or contains errors. There is no indication that the .rptdesign file is missing in this error, just a reference to a path to a file \userfiles…
The BIRT engine is generating and throwing the stack in the response. We needed to wrap the response from BIRT and scan for exceptions and stack traces. Moving forward, the stack trace will no longer be shown.
We have a customer who has a requirement for a highly customizable set of notifications within TRIRIGA. I have listed the requirements below, but I wonder if anyone has done anything similar before for other customers? Or if you have any ideas how some of these requirements could be achieved?
- 1. The ability to dynamically select the parameters that will be used in the notification text from the record in question, rather than having to physically set this up via notification content records for each notification.
- 2. The ability to select any piece of data as a parameter from the source record, or from any record associated to the source record, or records associated to the records associated to the source, etc. So, an example would be that if the work task is the source record, they would like to be able to include data from the project and program (and checklists). Again, without having to set up workflows for it.
- 3. The ability to run reports and attach them as content to the notifications (for both native and BIRT reports). This can be either as an attachment (in Excel or PDF format) or as the content within the notification.
- 4. The ability to set up a number of rules defining the notification triggers. These could be triggers on status changes, field changes (any possible attribute), or a combination of 2 or more of these. These rules would also vary from program to program, or project to project.
- 5. While allowing all of the above, still retain the ability to set up some globally defined notifications.
[Admin: A similar question is posted in the Capital Project forum.]
From the Audit Actions tab, we want to pull the Created Date of the logged-in user’s workgroup’s work task records. Since we do not have a specific BO for Audit Actions, we have written a static SQL (i.e., a Select query with joins) in a new data set in BIRT to display the Audit Actions > Created Date. We have hard-coded SPEC_ID values of a user which will pull the records of only that user for any login. But we need to pull it dynamically for any logged-in user.
Can we pull the TRIRIGA logged-in user’s workgroup’s work task records by using a static hard-coded SQL in BIRT Designer 4.3.1? Can you please suggest how to achieve this?
[Admin: This post is related to the 07.16.14 post about using hard-coded SQL statements in BIRT report parameters.]
After upgrading to IBM TRIRIGA 3.5.1, the BIRT reports throw a stack error and fail to run. When observing closely, there is an extra location root in front of the full qualified path. For example:
[Admin: This post is related to the 08.09.16 post about seeing a duplicate path in BIRT reports.]