ValuD: Is TRIRIGA OOB reporting good for your business needs?


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.]

Continue reading

Why does the BIRT report time out before the email is sent?


When you have a large data set and a record triggers a notification that sends an email when a BIRT report link is attached, if the query takes too long to retrieve results, users will not be able to see the report. The session will expire before the email containing the link is sent. For example, click on the link to a BIRT report in the email notification, and you will receive a message stating the session has expired. Other messages have been observed, as well as the request to sign back in.

By default, a report is written against the active session. So, if the session times out, the report is lost. To resolve the problem, you may check the “Queued” box in the Options tab of the report. That way, the report will run in the background and it will write to the user directory rather than to the session.

Continue reading

Can anyone help with BIRT reports that print work orders?


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?

Continue reading

IV88857: TRIRIGA 3.5.1.1 BIRT report stack error


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.

Continue reading

How do you configure highly customizable notifications?


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.]

Continue reading

Getting a failure with an extra root path in BIRT reports in 3.5.1


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:

C:/tririga_install/userfiles/C:\tririga_install\userfiles\birt\resources\reportABC.rptdesign

[Admin: This post is related to the 08.09.16 post about seeing a duplicate path in BIRT reports.]

Continue reading