Changing the Default (Normalized) Units of a Dimension

You can change a dimension's default units, offsets, and multipliers.

The default Weight attribute uses the Mass/Weight dimension with the default units set to grams. If your company uses the Weight attribute representing a different unit, you have these options:

After applying a dimension, you can only change the default units of measure before any user enters any data for the attribute. After values are stored in the as entered field, you cannot change the default units of measure.

  1. To set a new default unit, execute these these MQL commands:

    modify dimension NAME modify unit UNITNAME multiplier 1 offset 0 default;
    where:
    • NAME is the name of the dimension you want to change the default units for
    • UNITNAME is the name of an existing unit defined for that dimension that you want to make the default

  2. For all other units. run this command:

    modify dimension NAME modify unit UNITNAME multiplier MULTIPLIER offset OFFSET;
    where:
    • NAME is the name of the dimension you want to change the default units for
    • UNITNAME is the name of an existing unit defined for that dimension that you want to make the default
    • MULTIPLIER is the value to multiply the default value for this unit
    • OFFSET is any required offset

    For more information, see Dimensions.