December 7, 2012 at 9:27 am
In our business system we have our customer part numbers stored in a table with its primary keys as: our part number, customer part number, customer location and customer number. I have a customer and a part number dimension already. Would I just create a dimension with customer and part number foreign keys in them or should I create a separate dimension that have some of the customer and part number information in that dimension and the attributes in the business system table. Some of the reports they are looking for are: What part numbers are loaded for a customer and Sales by customer part number. Has anyone modeled similar data before? How did you accomplish this?
Thanks in advanced.
December 28, 2012 at 7:34 am
Sounds like you need a Fact table for Parts Inventory and 2 dimensions, Customer and Parts, that are conformed to the Sales fact table.
Check out Kimball's website for more ideas about a snapshot fact table for inventory.
Thomas LeBlanc, MVP Data Platform Consultant
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply