Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Maybe ypu can rty using an excel file and concatenate to your fact table and check them with a field FLGMemoItem =1, something like this:
Orders:
Load
OrderID,
ProductLineID,
DateOrder,
Zone;
SQL
Select * ordertable;
MemoItems:
Load
OrderID,
ProductID, //Created on the fly or if you have itin excel file just load it.
DateOrder,
Zone,
1 as FLGMemoItems
From MemoItems.xls;
Best regards.
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???
Hi,
Can you share an example of your two tables? (XLSX File if it's possible).
Best Regards.