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
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