Facts with different unit of measure
2 posters
Page 1 of 1
Facts with different unit of measure
I am trying to model a retail sales process in which the grain is a line item in the sales transaction. The items on the transaction could be of different unit of measure like units, Kilos, lbs, boxes...
Should I use one column for quantity in the fact table and have a FK to a UOM dimension with conversions to other units? If I do this though, then this quantity will contain a mix of weights and quantities. Is that a problem?
Or should I create two columns: Quantity and Weight and have 2 FK's to UOM.
Should I use one column for quantity in the fact table and have a FK to a UOM dimension with conversions to other units? If I do this though, then this quantity will contain a mix of weights and quantities. Is that a problem?
Or should I create two columns: Quantity and Weight and have 2 FK's to UOM.
arowshan- Posts : 23
Join date : 2011-10-18
Location : Vancouver, Canada
Re: Facts with different unit of measure
Generally speaking in retail, UOM usually comes into play when selling bulk goods (meat, fruit, etc...) otherwise, it is usually just an 'each'. One UOM should be enough, associated with the quantity. If someone buys 2 packages of ground beef, for example, its going to show up as 2 lines in the POS log, each with a different weight. I don't see a need to have both quantity and weight in the fact.
If this is a web retailer, then it would make sense to capture shipping weight as a separate measure.
If this is a web retailer, then it would make sense to capture shipping weight as a separate measure.
Similar topics
» Unit of Measure (UoM)
» How to make Quality Assurance and unit tests for a DW/BI project?
» Identify the facts and facts grain
» Unit Price Fact Table
» Multiple Facts or Single Facts and Status Table?
» How to make Quality Assurance and unit tests for a DW/BI project?
» Identify the facts and facts grain
» Unit Price Fact Table
» Multiple Facts or Single Facts and Status Table?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum