***************************************************** ***************************************************** ***************************************************** ***************************************************** ***************************************************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** This Confluence article was automatically generated from Asciidoc. Any changes you make to this document will be overridden! If you want to change the content, consider leaving a comment. You can edit the content directly here: https://gitlab.pricefx.eu/training/pricefx-knowledge-base/-/tree/dev/public/content/docs/reference/data-analytical/data-source-unit-of-measure ***************************************************** ***************************************************** ***************************************************** ***************************************************** ***************************************************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING ********************** ********************** WARNING **********************
The uom table is used for automatic conversion of the Quantity field between different units of measure (UOM) in Datamart.
This table contains only the common conversions for units which are the same for all the products, e.g. kg → lb, in → cm, etc.
If you need product specific conversions (e.g. 1 package of product X == 20 pieces), you can implement them, for example, via a data enrichment task (i.e. Calculation Data Load).
Here are some rules for records in the uom Data Source table. You should always have records which will convert:
From all UOMs found in Datamart rows into the the Base UOM of the Datamart in which you will use it.
1:1 for Datamart’s BaseUOM (e.g. EA → EA).