As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.
New TIBCO Community Coming Soon
In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch.
What You Need to Know about Our New Community
We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion.
During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
Suppose I have proc1, proc2, and proc3 and they all exist on the same dashboard. Each have bar charts. I would like to be able to click a bar in proc1 and then the data in proc2 and proc3 will update to reflect the selection/click made in proc1. How can this be done?
When I researched this, all I get are references to DRILLMENUITEM. I definitely do not want to do this, as DRILLMENUITEM presents the user an interface to drill to either report, but I want to drill to both.
I'm able to drill/filter one of the reports using something like:
...but I can't seem to figure out how to use the same logic/code to also filter proc3.
Another approach I was thinking of is to update the variables in proc1 when a bar is clicked, and then to refresh the whole dashboard. Is this the route I should be taking?This message has been edited. Last edited by: FP Mod Chuck,
One of the hyperlink drill down options is 'Refresh BI Portal' when this selection is made one drill will refresh all the other reports on that portal page as long as all reports have the matching parameters referenced.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005
Change all the filters to Simple with Optional checked in the reports/charts that are to be refreshed. Make sure you use the same variable names in your Refresh portal.
One other way I think you might get the same effect is to create a visualization using InfoAssist+ which has multiple charts and reports. You can lasso any part of a chart and the filters will take effect on all charts.
WebFOCUS 8206, Unix, Windows
Posts: 1853 | Location: New York City | Registered: December 30, 2015