Focal Point Banner


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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Parameter Prompting

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Parameter Prompting
 Login/Join
 
Platinum Member
posted
Hai

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
Ron

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS AppStudio 8.2.04
WebFocus Datamanagement Console 8.1M
DMC
 
Posts: 115 | Registered: August 29, 2014Report This Post
Platinum Member
posted Hide Post
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, 2017Report This Post
Platinum Member
posted Hide Post
Hai Deb

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.


WebFOCUS AppStudio 8.2.04
WebFocus Datamanagement Console 8.1M
DMC
 
Posts: 115 | Registered: August 29, 2014Report This Post
Virtuoso
posted Hide Post
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 :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Platinum Member
posted Hide Post
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?


WebFOCUS AppStudio 8.2.04
WebFocus Datamanagement Console 8.1M
DMC
 
Posts: 115 | Registered: August 29, 2014Report This Post
Virtuoso
posted Hide Post
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 :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Parameter Prompting

Copyright © 1996-2020 Information Builders