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.]
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.]
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.]
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”.]
IV95219: Section 508 compliance for TRIRIGA login page
Visually impaired users dependent on Section 508 compliance to use TRIRIGA may run into a problem in the login page. They might have difficulty in navigating to enter the ID and Password.
IV95289: Section 508 compliance in Projects page
Keyboard access, style sheet dependence, language, page titles, and images for Section 508 compliance fail test on Projects tab.
IV95290: Section 508 compliance in My Reports page
Keyboard access, web forms have invalid HTML, web links, and user controls. Images have no description in plain text.
[Admin: This post is related to the 10.17.16 post about multiple APARs on Section 508 compliance.]
For some reason, when I click on the “Popup Query” action on a form in Form Builder, TRIRIGA immediately signs me out. However, if I run a query using My Reports, it works absolutely fine. This happens even with the out-of-the-box (OOB) forms and queries. The platform is TRIRIGA 22.214.171.124. I have also increased the transaction timeout in WebSphere Liberty Profile (WLP). Any help is appreciated.
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 126.96.36.199, you will not see a count. But if you are using 188.8.131.52, you will see a count. The count that gets displayed is throwing off pivot tables when they are created from an exported report.