Print Page - Cascading Prompt with Static values

Title: Cascading Prompt with Static values
Post by: msv on 08 May 2007 11:13:12 AM

Hi,

I have a requirement w.r.t to cascading prompts(static values).Find below the details:

Prompt 1.

Will Select the Unit of Measure('Units'/'Dollars')

Prompt 2.(Should cascade on Prompt 1)

When 'Units'is selected in Prompt 1 then Prompt 2 should display 'CSU' and 'Physical'
When 'Dollars' is selected in Prompt 1 then Prompt 2 Should display 'CAD' and 'USD'

All the above values are Static values.

I tried creating a Variable for Prompt 2 to choose the Static values based on Prompt 1 Inputs,but some how its not working.

Thanks,
msv

Title: Re: Cascading Prompt with Static values
Post by: COGNOiSe administrator on 10 May 2007 06:58:12 PM

Create a Query based on static SQL.

Title: Re: Cascading Prompt with Static values
Post by: msv on 11 May 2007 05:03:50 PM

Thanks,I used Tabular SQL to get the static values.

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: msv on 08 May 2007 11:13:12 AM