topic Re: create complex filter in information map in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/create-complex-filter-in-information-map/m-p/8816#M2477 <HTML><HEAD></HEAD><BODY><P>Let us take a example,</P><P></P><P>There is a table called products, It consist of dataitem Product_id,Product_name,QTY</P><P>and another table sales_fact, Consist of Sales_Id,Sales_person,Product_ID</P><P></P><UL><LI>Inner Join above two table with product_id</LI><LI>add dataitem only related to products table in the information map selected items.</LI><LI>Create a prompt 'Name of the Sales person' and apply to Sales_person in the SALES_FACT table</LI><LI>Save the Infomap.</LI></UL><P>Hope this will resolve your issue</P></BODY></HTML> Sun, 14 Oct 2012 19:56:15 GMT AkilanR 2012-10-14T19:56:15Z create complex filter in information map https://communities.sas.com/t5/SAS-Enterprise-Guide/create-complex-filter-in-information-map/m-p/8815#M2476 <HTML><HEAD></HEAD><BODY><P>I want to create a filter, e.g. " product_id in (select product_id from sales_facts where ....&nbsp; )", with prompt. Is it able to create such filter in Information map?</P></BODY></HTML> Tue, 21 Feb 2012 15:11:42 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/create-complex-filter-in-information-map/m-p/8815#M2476 DogCat 2012-02-21T15:11:42Z Re: create complex filter in information map https://communities.sas.com/t5/SAS-Enterprise-Guide/create-complex-filter-in-information-map/m-p/8816#M2477 <HTML><HEAD></HEAD><BODY><P>Let us take a example,</P><P></P><P>There is a table called products, It consist of dataitem Product_id,Product_name,QTY</P><P>and another table sales_fact, Consist of Sales_Id,Sales_person,Product_ID</P><P></P><UL><LI>Inner Join above two table with product_id</LI><LI>add dataitem only related to products table in the information map selected items.</LI><LI>Create a prompt 'Name of the Sales person' and apply to Sales_person in the SALES_FACT table</LI><LI>Save the Infomap.</LI></UL><P>Hope this will resolve your issue</P></BODY></HTML> Sun, 14 Oct 2012 19:56:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/create-complex-filter-in-information-map/m-p/8816#M2477 AkilanR 2012-10-14T19:56:15Z