Buildings that support occupant happiness and productivity sound great. So what’s the catch? Occupant well-being and happiness is much harder to quantify compared to environmental factors such as energy efficiency. Also, there aren’t yet well-recognized rating systems, although the International WELL Building Institute is making some headway. But the bigger puzzle for the smart building ecosystem to solve is: How much do building conditions really contribute to occupant happiness? How should building investments be balanced with other areas such as IT?
I know that TRIRIGA SaaS comes with predefined ETL jobs, and one of them is energy log fact. I have some energy logs on some buildings. However, all of my attempts to run the ETL job for energy logs have failed. Is there any missing parameter for me to add to make this work? I did try adding triEnvEnergyItem as a BO name, but no luck.
The ETLs each require different inputs depending on the ETL. Since, in general, ETL processing is a background process and runs through the scheduler, you would need to look in the server.log to see what the ETL needs if you are running it directly from the ETL Job form. You would also need to make sure that you have a license that allows you to run the ETLs, which would be a license that grants privileges to “Technology Metrics”.
Maybe this link will help: ETL and Metric Query Troubleshooting.
[Admin: To see other related posts, use the ETL tag.]
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.]
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.
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.
|Circular Bar Gauge||Circular Gauge|
|Circular Gauge||Circular Gauge|
|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|
|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.]
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.
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.]