For example, production volumes can be expressed in number of units, number
of "production lots/Batches", number of shipment packs..
There are two ways to handle this requirements:
- Have one field carrying the lowest granular unit of measure (like units
of production), and have additional fields to carry the conversion factor
between the granular unit of measure and higher units of measure (like
12 when the unit of measure is 'dozens'). As the OLAP gets populated from
the data warehouse, the conversion factors can be applied to calculate
the measures in different units OR the calculation can be done on the
runtime basis.
- Have one field carrying the lowest granular unit of measure (like units
of production), and have additional fields to carry the measures in other
units (like 1000 dozens against 12000 units of production).
|
