What are the different chart-type and metric-type reports in TRIRIGA?


In TRIRIGA, I can see only 4 main types of chart reports: (1) pie, (2) bar, (3) lined, and (4) stacked bar, and these are two-dimensional. Are there any other chart type reports apart from these? And how can we report on multi-dimensional (more than two-dimensional) chart reports?

TRIRIGA ships with the following chart types in the table below. TRIRIGA also integrates with the BIRT and Crystal Reports engines, which have very robust reporting options. Note that as of the TRIRIGA 3.5.0 platform, anything that says “linear gauge”, will render as a circular gauge.

Name/Description Type
3D Doughnut Pie
3D Pie Pie
Bubble Bubble
Circular Bar Gauge Circular Gauge
Circular Gauge Circular Gauge
Doughnut Pie
Horizontal Grouped Bar (%) Bar (%)
Horizontal Grouped Bar Bar
Horizontal Linear Bar Gauge Linear Gauge
Horizontal Linear Tank Gauge Linear Gauge
Horizontal Stacked Bar Bar
Line/Vertical Grouped Bar Combo Line-Bar Combo
Line/Vertical Stacked Bar Combo Line-Bar Combo
Line Line
Pie Pie
Pyramid Pyramid
Spline Line
Vertical Grouped Bar (%) Bar (%)
Vertical Grouped Bar Bar
Vertical Linear Bar Gauge Linear Gauge
Vertical Linear Tank Gauge Linear Gauge
Vertical Stacked Bar Bar
Circular Bar Gauge (%) Circular Gauge (%)
Circular Gauge (%) Circular Gauge (%)
Horizontal Linear Bar Gauge (%) Linear Gauge (%)
Horizontal Linear Tank Gauge (%) Linear Gauge (%)
Vertical Linear Bar Gauge (%) Linear Gauge (%)
Vertical Linear Tank Gauge (%) Linear Gauge (%)

[Admin: The “Metric” type offers more options in addition to the “Chart” type. This post is related to the 04.17.17 post and 03.04.16 post about displaying a stacked bar chart, and the 04.05.17 post about displaying a mix of bars and stacked bars.]

Continue reading

Advertisements

How do you upgrade TRIRIGA with Crystal Server dependencies?


We understand that sometimes with new TRIRIGA platform and application version releases, a new version of Crystal Server will be required (tested by IBM and supported) in order for our existing Crystal Reports to function. Deviation from the tested and supported version of Crystal Server identified in the compatibility matrix is considered to be a significant risk.

From what we have been told, the version of TRIRIGA is tightly coupled with the supported version of Crystal Server.We are looking for a better understanding of how clients who may be using a shared Crystal Server across their enterprise handles upgrades to the TRIRIGA platform. Because our business recommended the use of their enterprise Crystal Server with our existing TRIRIGA application, we would like to understand the issues and risks of going with using a shared server where the upgrade schedule (annually) differs from our TRIRIGA upgrade schedules (2 years for platform, 5 years for combined application/platform).

Are there other clients of IBM who use a shared enterprise Crystal Server? When they want to upgrade TRIRIGA, do they always have the appropriate supported Crystal Server version paired with TRIRIGA? If not, what are other accepted (if risky) solutions? Potentially, if we went with the enterprise Crystal Server, it would likely often be further ahead than the version recommended by our platform.

[Admin: To see other related posts, use the Crystal tag.]

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

How do you set FRONT_END_SERVER in the TRIRIGA application?


Customers may encounter the following issues, if the FRONT_END_SERVER property of the TRIRIGA application is not properly set:

  • 1. Application is accessed, but the resources do not load.
  • 2. BIRT reports or Crystal Reports do not render correctly.
  • 3. Gantt charts are not being displayed.

First, check the FRONT_END_SERVER property in these locations: (1) TRIRIGA Admin Console > System Manager > TRIRIGA Web, (2) TRIRIGAWEB.properties file. Note that the value should exactly match the URL that is used to go to TRIRIGA in the browser.

Second, if you use something like http:// tririga.samplelink.org/ to go to TRIRIGA, then the FRONT_END_SERVER should be tririga.samplelink.org. [Admin: This is actually incorrect. The protocol is no longer optional.]

Third, if you use a port to access TRIRIGA, that must be included as well.

[Admin: This post is related to the 12.14.15 post about using the FRONT_END_SERVER setting, and the 07.27.15 post about the FRONT_END_SERVER protocol being a requirement.]

Continue reading

Why doesn’t Crystal Reports run after upgrading IBM TRIRIGA?


We have upgraded IBM TRIRIGA and we discovered that executing SAP Crystal Reports (either query or direct connection type reports) throws errors in the server log. On several occasions, our whole application was frozen or brought down by executing Crystal Reports. The following sample shows the error messages printed out in the server.log file…

[Admin: To see other related posts, use the “crystal report” search phrase.]

Continue reading

What are the default ports for the TRIRIGA Application Platform?


These are the default ports when installing WebSphere Liberty and TRIRIGA 3.4.2+. Note that there are 3 entries from application/process server to each database type. Your installation will only use 1 of those default ports. Any of these ports is configurable in their respective configuration. The purpose of this wiki page is to show the default ports, not to detail how to change them. Refer to the installation and configuration documentation of that particular tier on how to change the ports.

  • Client Browser > Web Server > http on port 80
  • Client Browser > HTTPS Web Server > https on port 443
  • System Admin’s Browser > Application Server > http on port 8001, for direct access to the TRIRIGA System Admin Console
  • System Admin’s Browser > Process Server > http on port 8001
  • Web Server > Liberty Application Server > http/proxy on port 8001
  • Application Server > Oracle Database Server > jdbc on port 1521
  • Application Server > MSSQL Database Server > jdbc on port 1443
  • Application Server > DB2 Database Server > jdbc on port 1521
  • Application Server > BIRT Process Server > birt on port defined in TRIRIGAWEB.properties
  • Application Server > Crystal Server > rpt on port 1566
  • Application Server > Brava > http on port 8080
  • Process Server > Oracle Database Server > jdbc on port 1521
  • Process Server > MSSQL Database Server > jdbc on port 1443
  • Process Server > DB2 Database Server > jdbc on port 50001
  • Process Server > Outgoing Mail Server > smtp on port 25
  • Process Server > Incoming Mail Server > pop3 on port 110
  • Process Server > Incoming Mail Server > imap on port 143
  • Process Server > Incoming Mail Server > imaps on port 944

Continue reading

How do you use the FRONT_END_SERVER setting?


How is the FRONT_END_SERVER setting used? Does it affect all browsers for TRIRIGA 3.4.2.1? I know that workflows and the Associations tab use it, but is it used for standard forms? Do all browsers need to have this set correctly? Or only IE?

I’m not familiar with it being needed for the Associations tab. In general, the main use of FRONT_END_SERVER is for BIRT reporting, Crystal reporting if applicable, and possibly workflow notifications. Maybe Gantt too, but it’s hard for me to tell. Famously, we had to use the FRONT_END_SERVER property in order to address the Microsoft update issue here.

However, this requirement as far as I know only extends to 3.4.1.x and earlier; 3.4.2.x should no longer need this requirement. Maybe someone can confirm this? Multi-browser support starts at 3.4.2, so I think the FRONT_END_SERVER requirement is only for IE and only for 3.4.1.x and earlier releases.

[Admin: This post is related to the 03.13.15 post about the Workflow Builder alert, and the 07.27.15 post about the FRONT_END_SERVER requirement.]

Continue reading