How to handle items that do not belong to a product line and not part of inventory. These items are called memo item and are created on the fly when entering order . Since they are not part of inventory they are not listed in item dimension or product line dimension but are needed to calculate the total orders. My current analysis where orders are linked to items and product lines do not show these order line items.
My issue is i need to load into items dimension table based on the sales detail table for which no item exists in the item dimension. Memo items in sales detail table do not exist in item dimension and hence the join created by QV between sales detail and item dimension based on item field will not return all records in sales detail.
Should i be using resident load for this. If so how would i add into item dimension table all the memo items in sales detail table???