Hi ,
In Query studio , if user pulls column like "Operating Unit Name" for filter , i want to pass the "Operating Unit ID" . Is there as way to achieve this ? The same functionality we have in Report Studio where we pass USE VALUE as Operating Unit ID from Prompt while Operating unit name as DISPLAY VALUE
The modeler of your package has Prompt Info properties for each data item where the display, filter, and use references can be specified. Otherwise you'd be best served by moving to Workspace Advanced since Query Studio is going bye-bye.
Thanks Lynn.. Your suggestion helps :)