Units of Measurement (UOM)

A user can add their own units of measurement to the data they are loading.

Perform the following steps to change the units of measurement for your data:

  1. Create a file(s) using the format outlined below in sections -.

  2. Specify the directory containing the file(s) in the .limrc file using the environment variable XMIM_LOCAL_UNITS.

  3. Load the units of measurement by running the command units_measure_load.

Create the Units of Measurement File

the section called “MimicUM_Units” - the section called “MimicUM_Currencies” below describe: the file name, a unit of measurement description, format of the entries (note that the entries must be separated by tabs), then an example.

MimicUM_Units

Filename: MimicUM_Units 

Description: The file designates what each relation and column is quoted in.

File Format:

Relation       Column       Units 

File Example:

XUPEZ99       Close       USD/MGW

MimicUM_CategoryUnits

Filename: MimicUM_CategoryUnits

Description: The file designates what each category and column is quoted in.

File Format:

Category        Column         Units

File Example:

SOUR       Close       USD/BBL

MimicUM_RelColConversion

Filename: MimicUM_RelColConversion

Description: The file designates a specific relation and column and the conversion formula for the specified units.

File Format:

Relation        Column        Unit        Unit        Conversion Formula

File Example:

PYBRB00        Index        BBL        MT         7.685

MimicUM_Conversions

Filename: MimicUM_Conversions

Description: The file contains the conversion formulas from one measurement to another.

File Format:

Unit         Units        Conversion Formula

File Example:

BBL        GAL         1/42

MimicUM_Currencies

Filename: MimicUM_Currencies

Description: File contains the conversion formulas from one currencies to another.

File Format:

Currency          Currency          Conversion Formula

File Example:

NOK         DKK         (1/(Close of NORP_DKK_NOK))