IV97814: triTaskResourceFact and triDimTaskStatusTX have changed


When running an ETL Job in IBM TRIRIGA 3.5.2, we see the following error, because the T_triTaskResourceFact table, triTaskResourceFact BO, has changed, and the triDimTaskStatusTX field is no longer a locator:

ERROR [com.tririga.platform.workflow.runtime.taskhandler.ETL.KETTLE](triTaskResourceFactETL - Insert into triTaskResourceFact) Insert into triTaskResourceFact - org.pentaho.di.core.exception.KettleException: Error inserting row into table [T_TRITASKRESOURCEFACT] with values: ...
Error inserting/updating row ORA-00904: "TRIDIMTASKSTATUSTXOBJID ...

The status dimension data was not populating for the task resource metric table. Moving forward, we needed to make changes to populate the data correctly.

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

Continue reading

Advertisements

How do you use drawing labels for international measurements?


We manage properties globally so some of our locations are measured in Imperial and some are in Metric. What is the best way to manage this type of scenario so that our drawing and graphics section labels are not incorrectly sized when they are viewed from other global geographies?

The best way to address this situation is to have 2 sets of labels for your drawings, and 2 sets of labels for your TRIRIGA graphics section. You will need to adjust the height of the label elements to work for both situations. We are considering an enhancement to automatically scale according to the drawing units.

[Admin: To see other related posts, use the Graphics tag or the Labels tag.]

Continue reading

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

IV97310: Pie chart labels are cut off in smallest portal section


The pie chart labels should actually be hidden, and not appear at all for the smallest portal section. Users should rely on tooltips for the smallest portal section. The reason labels were always meant to be hidden is because they make many pie charts unusable in the smallest portal section, due to labels bunching together in the small space. The smallest portal section should always hide the pie chart labels.

The hiding of the pie labels for the smallest portal section broke when AnyChart was upgraded in TRIRIGA 3.5.0. Moving forward, we resolved a metric report and chart report issue, where pie chart labels were chopped off in the smallest portal section. This fix hides pie chart labels when the TRIRIGA component that displays the chart falls below a height of 280px and a width of 280px, such as the smallest portal section. Pie labels become unusable when pie charts get too small. So users should rely on pie chart tooltips for the chart details, when the labels are hidden.

[Admin: This post is related to the 04.14.16 post about changing the AnyChart label settings. To see other related posts, search “Pie Chart“.]

Continue reading

Is there a way to modify columns of popup report in metric report?


I am wondering if it is possible to modify the columns of the popup report, when we click on the graph of a metric report. It would seem the popup report doesn’t exist “physically” in the TRIRIGA database, rather it seems hard-coded and created on-the-fly when we click on the graph, reusing the existing graph data. Could anyone verify this assumption?

You are able to control the display columns on the report that is opened when clicking on the chart, just as you would a normal (i.e. non-chart) report in TRIRIGA. So from your chart details on the General tab > Options sub-tab, then on the Columns tab > Display Columns sub-tab, you can select fields, order, and change the default label to how you would like it presented when clicking into the chart.

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

Continue reading

Why aren’t tasks always showing up in tabular metric reports?


Our client’s tabular metric reports, which are set to show the tasks of service requests, seem to have some issues. Although the tasks are found by the report, they don’t always show up or aren’t displayed on the list.

Here are two examples below: (1) In the first case, 6 tasks are found, but only 2 of them show up. (2) In the second case, 3 tasks are found, but none is displayed. Any ideas on what could be happening?

[Updated 05.03.17]

It seems that the user’s language (set in his profile) and the existence of a contract for the tasks affect their visibility one way or another on the tabular report. Here’s an example below: (1) When the user’s language is set to EN (English), all of the tasks show up fine. (2) When the user’s language is set to FR (French), only tasks which have a contract show up (in this case, only 1) even though all 8 are found…

Continue reading

How do you display a stacked bar chart in TRIRIGA?


Does anyone have any extra documentation on chart queries? The user guide is terrible. It just says to pick a chart. I know the bar charts follow the first thing you “Group By”. But I am not sure what to do with stacked bar charts, and I’m thinking that’s the view my customer needs. I’m curious what the setup on the query needs to be for the stacked bar option.

You need to use the “Metric” option for the type, instead of “Chart”. Also, if you are on TRIRIGA 3.5.1, there is an existing issue with stacked bar charts, where sometimes the bars display incorrectly.

[Admin: This post is related to the 04.05.17 post about displaying a mix of bars and stacked bars, and the 03.04.16 post about displaying a stacked bar chart.]

Continue reading