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.
Join the TIBCO Community TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.
In InfoAssist you can add parameters for data selection a run-time. When you add a parameter, it becomes a field container into which you can add one or more measures and dimensions. See page 66 InfoAssist+ 8.2.04
To be able to use this functionality, one should adapt ‘Managed Reporting’ in the Administration Console/Parameter Promping. Give it the value 'Run with default values'.
But then a lot of existing reports/fexes are hit. Asking for a parameter value.
Is there a way of setting this parameter only for specific reports, so it won't effect other things?
regards RonThis message has been edited. Last edited by: FP Mod Chuck,
Ron, I'm not really sure what you are asking. Only reports that use the parameter should prompt for it. If you are using the Page Designer, it will put the parameters at the top for all the reports on the page, but it will only affect the reports that reference that parameter (amper variable). Does that help?
--Deb
WebFOCUS 8.2.03 (production), 8.2.06 (testing) AppStudio, InfoAssist Windows, All Outputs
Posts: 183 | Location: Indiana | Registered: December 05, 2017
no, that is not what I mean. When we change the general setting of 'Managed Reporting’ suddenly a lot of existing fexes/reports/dashboards behave differently. Asking for parameter input. That is not what we want.
Strictly speaking, autoprompt prompts for uninitialized parameters. Usually, those are signs of code problems. My advise is to take a good look at those reports that now suddenly prompt for parameters, as you may have code issues there.
Unfortunately, autoprompt is not smart enough to detect unreachable code, which (at least in our case) is often the reason parameters remain uninitialized. We either comment such code out, or split it off to a separate file.
The other frequent culprit is -READFILE, which "creates" new parameters on the fly. There again, autoprompt is not quite smart enough. Adding -DEFAULTH for those parameters (after -READFILE) hides them from autoprompt. That gets messy with dynamically generated TABLE requests though.
Making autoprompt smarter about such cases will very probably slow it down significantly - but even then - some of those cases cannot be detected without actually executing the code in between.
Finally, autoprompt prompts get funky when you initialize a parameter after its first use. It for input, but still manages to put a value in the field for that parameter. Those cases can be hard to find, but they are actual uninitialized parameters and therefore bugs.
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :
Ok, so when you have (like we) I very large install base, it is very complicated to start using parameter containers in InfoAssist (to be used in the new InfoApp) because it is hard to find out which existing programs will behave differently once 'Managed Reporting' is changed?
If you have a large install base and you start changing settings, that is always the case.
quote:
once 'Managed Reporting' is changed
I have no idea what this means, but perhaps someone at IBI does. You should probably open a case anyway.
WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010 : Member of User Group Benelux :