Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: twister on 28 Apr 2014 10:38:34 AM

Title: Set up a parameter value based on another parameter
Post by: twister on 28 Apr 2014 10:38:34 AM
Hi guys, How do I set up a parameter value based on another parameter in a prompt page?

I have 2 parameters param1 and param2. Based on the param1 value, I need to set up param2 value. I am trying to overocme a limitation in DQM and I need to do it this way to make it work.

Say for example,
If (?param1?='Total')
then ('A')
else ('B')

Any suggestions?

Thanks.

I need to
Title: Re: Set up a parameter value based on another parameter
Post by: Raghuvir on 28 Apr 2014 10:42:34 AM
can u use cascading prompts ?

Regards
Title: Re: Set up a parameter value based on another parameter
Post by: twister on 28 Apr 2014 10:55:56 AM
It is bit difficult to use cascading prompt. Reason is, the second prompt is completely derived from first prompt's value and the user shouldn't see the second prompt at all. The second prompt value will be used for some processing.Any other way?
Title: Re: Set up a parameter value based on another parameter
Post by: MFGF on 28 Apr 2014 12:37:30 PM
Quote from: twister on 28 Apr 2014 10:55:56 AM
It is bit difficult to use cascading prompt. Reason is, the second prompt is completely derived from first prompt's value and the user shouldn't see the second prompt at all. The second prompt value will be used for some processing.Any other way?

If the second prompt is never visible and is simply used for other processing, why does it have to be a prompt? Why not just a filter expression?

MF.
Text only | Text with Images