How to achieve a sub query having Prompt in webi
I have a requirement where a column value(Vendor.Setid) of a main query is populating from a sub query (containing prompt).
Vendor.Setid =(Select Control.Setid from Control
Where Control.Setcntrlvalue =Prompt
Or Vendor.Setid IS NULL
Can anyone please help me with the solution.
Thanks in advance!!