I want to create a filter, e.g. " product_id in (select product_id from sales_facts where .... )", with prompt. Is it able to create such filter in Information map?
Let us take a example,
There is a table called products, It consist of dataitem Product_id,Product_name,QTY
and another table sales_fact, Consist of Sales_Id,Sales_person,Product_ID
Hope this will resolve your issue