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 Inner Join above two table with product_id add dataitem only related to products table in the information map selected items. Create a prompt 'Name of the Sales person' and apply to Sales_person in the SALES_FACT table Save the Infomap. Hope this will resolve your issue
... View more