Setting Global Parameter values for Cognos Reports

[jayatu]

Hi,

Is it possible to set a Global parameter value in Cognos.

Suppose I have 10 reports & all of these reports have one or more prompts in common (like some threasholds). So is it possible to set a global value for these common parameter instead of setting the values in each & every report, i.e. setting the value in one place would get reflected in all the reports.

Jayatu

[cognostechie]

You can use a Prompt macro in your model which will be inherited by every report using that table/query subject. The macro allows to set default values so the prompt will become part of the report but not mandatory. If the user does not provide a value then it will pass the default value in the filter.

Ex:

#prompt('Threashold Value','integer','1')#

                             OR

#prompt('Threashold Value','string','''1''')#

1st parameter is the prompt name, 2nd is the data type and the 3rd is the default value