COGNOiSe.com - The IBM Cognos Community

Hi,

I have a value prompt in the report page itself(no prompt page). I need to give this value prompt a default value using query Item.
For example, I have drop down which populates country names using [Country] and I need this value prompt to have default value from [My Country].

I tried macro function in filter as below.
[Country] = #prompt ('param_country','token','[My Country]')#

Thanks,
Pradeep