Analytics Software

Hi,

I am new to discoverer and have a doubt.I have a query within it is subquery. I want to use parameter in subquery.
Can anybody please help what is the procedure to add 'prod' parameter in desktop.

select * from promotion
where id in(select id from source where prod=:prod);