Focal Point
[SOLVED] Shut off prompting of global variable in master file

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7587097476

February 19, 2015, 04:41 PM
TeePee
[SOLVED] Shut off prompting of global variable in master file
I have a master file that has some global variables defined for use in some compute fields.
VARIABLE NAME=&&CNST_PI, USAGE=D12, DEFAULT='200000', $

I've then created a reporting object from this master file for use with InfoAssist. When I create a new report using this reporting object and include one of my compute fields, when I RUN the report is displays or prompts me for the value of this global variable.

I have turned off 'Prompt for Parameters' on the reporting object procedure in my content folder.

Does anyone know how I can suppress this prompt window when I run my InfoAssist report?

Thanks,
Trevor

This message has been edited. Last edited by: TeePee,


WF 8.0.08
February 20, 2015, 03:48 AM
Ram Prasad E
Check in Admin Console Client Setting Parameter Prompting - IBIF_wfdescribe. You can change value for this to OFF.


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
February 20, 2015, 03:49 AM
Ram Prasad E
You can also try changing Client Settings - Managed Reporting - Change value for IBIMR_prompting to OFF.

Either of these should help you.

Thanks,
Ram


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
February 20, 2015, 08:46 AM
Tom Flynn
TeePee,
Add this to the IA program
-DEFAULTH &&CNST_PI = ''
or
Add to site.wfs and initialize it there.

Ram,
Both of your suggestions will turn off prompting for everything, including other IA programs...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
February 20, 2015, 09:44 AM
j.gross
The problem might stem from the Master file:

quote:
VARIABLE NAME=&&CNST_PI, USAGE=D12, DEFAULT='200000', $


USAGE must be alpha (Ann), since amper vars are simply character strings:

Syntax:
First assign the variables names after the FILE declaration in the Master File:
VARIABLE NAME=[&&]var, USAGE=Aln, [DEFAULT=defvalue,] [QUOTED={OFF|ON},] $
where:

var
Is the name you are assigning to the global variable. ...
ln
Is the maximum length for the variable value.

defvalue
Is the default value for the variable. If no value is set at run time, this value is used.


If you correct the Usage, the Default might kick in.


- Jack Gross
WF through 8.1.05
February 21, 2015, 08:19 AM
Ram Prasad E
Tom Flynn,

Thanks for your insight. Yes, my solution will disable all auto prompts.

Teepee,
To disable only that of specific master file, Tom's and Jack's solution will help you.

-Ram


WebFOCUS 8.1.05
Windows
http://ibiwebfocus.wordpress.com
https://www.facebook.com/groups/ibi.webfocus/
February 22, 2015, 07:28 AM
eric.woerle
You Can Also Use A -DEFAULTH IN THE Site PROFILE For THE AMPER variable. That's what I do. Just beware that when using reportcaster, it skips the client and goes directly to the reporting server. If reportcaster is a concern, then maybe try setting it with defaulth using the mfd profile.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
February 23, 2015, 10:37 AM
TeePee
[QUOTE]Originally posted by Tom Flynn:

Add this to the IA program
-DEFAULTH &&CNST_PI = ''

-------------------------------
Tom,

Where would I add this line? I'm going directly from my synonym to a reporting object in the content folders.

Thanks,
TP


WF 8.0.08
February 23, 2015, 11:47 AM
Tom Flynn
Right-click the focexec, edit in TEXT, and, add it above the other DEFAULTH code generated by IA...





Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
February 23, 2015, 11:55 AM
TeePee
Tom,

I don't get the option to edit in TEXT with my reporting objects. I opened the focexec in the Reporting object tool then edited the Preprocessing Other group and added it there.

Seems to be working now!! Thanks.


WF 8.0.08