3 Replies Latest reply: Aug 5, 2014 10:45 AM by Oswaldo Vasquez RSS

    Items with no Product Line

      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.

        • Re: Items with no Product Line

          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.

            • Re: Items with no Product Line

              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???