I have a problem with results from a many-to-many relationship. Right now I have a fact table called fact_FillRate that contains a PurchaseOrder_ID and Item_ID. It also contains measures such as Qty Ordered, Qty Received, Origination Date,
and Completion Date. Because items may tie to more than one purchase order I set up a many-to-many relationship. The fact_FillRate table is tied by PurchaseOrder_ID to Dim_Purchase Orders which contains the PO_Nbr and PO_Type. That table
is tied to a bridge table called factless_PurchaseOrders which contains the keys for PurchaseOrder_ID and Item_ID. That table is then tied to the ItemMaster which contains the Item_ID. Everything processes without any issue, and the data itself
looks correct until I drill down to a purchase order. Then the Qty_Ordered for each item is identical and is a sum of all items ordered. What I need is for each item to have the correct Qty_Ordered and not a sum of the three items. What am
I missing on many-to-many relationships?
View Complete Post