How do you report a triProperty with more than one triBuilding?


I have a few questions from our customer about TRIRIGA reports:

  • Question 1: We want to create a report to show the triProperty which has more than one triBuilding as children. By using an association filter, we can only show the triProperty which has at least one triBuilding. By using a summary report, we can group by triProperty to show the number of triBuilding it has, but we can’t add another criterion based on the “Number” column. So, both two solutions above don’t work.
  • Question 2: How can we do something like a “left join” in a multiple-BO report? We have noticed that the behavior of multiple BOs in a report acts more like an “inner join” query. The filter based on the secondary BO will also impact the primary BO result. Do you know any way to get a “left join” result in TRIRIGA?
  • Question 3: How can we share a list of reports with users who are members of a specified security group? Our customer doesn’t want to grant the access of the “My Report” application for those groups, and they would like a solution that is more dynamic than adding those reports into the portal of the user. I don’t know if there is way to do this. Can the Admin user define a favorite list for the end users?

[Admin: To see other related posts, use the Reports tag or My Reports tag.]

Continue reading

Advertisements

IV96845: Ability to bypass security and use unauthorized functions


Testers found that they had the ability to add reports to the My Reports page in TRIRGA, even though the links for New, Copy, Delete, Copy as Community Report, and Share Report were not present for the read-only users.

Moving forward, an privilege escalation issue in Report Manager has been resolved.

[Admin: To see other related posts, use the Vulnerability tag or CVE tag.]

Continue reading

IV96326: Title is shown even if the REPORT_HEADER_COLUMN is “Name”


When a report is executed from “My Reports”, the title is shown as the header, even though we have changed the REPORT_HEADER_COLUMN property to “Name” in the TRIRIGAWEB.properties.

We needed to remove the REPORT_HEADER_COLUMN property since it is no longer being used. It was used in the out-of-support TRIRIGA 2.7.x platforms and older. Moving forward, the deprecated REPORT_HEADER_COLUMN property has been removed from the TRIRIGAWEB.properties file since it has not been used since the TRIRIGA 2.7.x platform releases.

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

Continue reading

ValuD: How do you locate a specific report in IBM TRIRIGA?


Your IBM TRIRIGA system can provide you with a wealth of information, if only you know where to look. For instance, did you know that the TRIRIGA system offers you over 12,000 reports? Reports play an important role in helping you make accurate and timely business decisions. But locating a report from this mine of information can be a tricky affair.

Let’s say that you want to access and edit a particular report. The flexibility offered by the IBM TRIRIGA system allows you to access the report in several, different ways, some of which you might already be aware. But if you are wondering if there is a quicker and easier way to locate the report, then take a look at our “clip-tip” below to learn how…

[Admin: This post is related to the 03.29.17 post about another ValuD “clip-tip”.]

Continue reading

IV92427: Unexpected Excel counts cause issues with pivot tables


Go to My Reports and select the report named “triPeople – Filter – Active Users”. Run the report and export to Excel. In Excel, highlight the blank fields. In the lower-right corner, if you are using TRIRIGA 3.5.0.3, you will not see a count. But if you are using 3.5.1.2, you will see a count. The count that gets displayed is throwing off pivot tables when they are created from an exported report.

Continue reading