Cascading Prompt with Static values

[msv]

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

[COGNOiSe administrator]

Create a Query based on static SQL.

[msv]

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