Add a new numeric set

Open the measConfig tool.

Log in to CONNECT. For more information, refer to Sign in to CONNECT.

Go to the Select Table tab.

Double-click numericSetDesc to open the tab and navigate to it.

Set the module to CD_PROJECT.

If the CD_PROJECT module is not in the module dropdown, select New Module to add it.

Select Insert.

A new row will appear.

Create or update the numericSetDesc with the new numeric set.

For example, the voltage numeric set would look like this:

• numericSetCode — 888

• numericSetName — Voltage

• numericSetAbbrev — volt

• description — Electrical Voltage

• inUnitConvMatrix — N

• inPrecisionMatrix — N

• minDecimalPlaces — 0

• maxDecimalPlaces — 15

• numericSetDefine — NSD_VOLTAGE

Optional: You can introduce unit conversion and precision columns to unitConvMatrix and precisionMatrix tables in the EFM database.

1. If you would like to do this, set the inUnitConvMatrix and inPrecisionMatrix columns to Y in the numericSetDesc definition added in the previous step.

2. You also need to insert the following three entries into the tableColumnDesc for the CD_PROJECT module:

• For volta, enter the following in the listed field:

  • tableColumnCode — 651

  • tableDesc:tableName — unitConvMatrix

  • columnName — volta

  • problemName — volta

  • columnAlias — VOLTA

  • generateMacros — Y

  • description — voltage multiplier

  • SQLDataTypeName — T_doublePrecisionType

  • CDataTypeName — double

  • numericSetDesc:numericSetName — Voltage

  • columnOrder — 100

  • inHMI — N

  • hmiName — Volts

  • aggregationName - None

  • availToRealTime — N

• For voltb, enter the following in the listed field:

  • tableColumnCode — 652

  • tableDesc:tableName — unitConvMatrix

  • columnName — voltb

  • problemName — voltb

  • columnAlias — VOLTB

  • generateMacros — Y

  • description — voltage multiplier

  • SQLDataTypeName — T_doublePrecisionType

  • CDataTypeName — double

  • numericSetDesc:numericSetName — Voltage

  • columnOrder — 101

  • inHMI — N

  • hmiName — Volts

  • aggregationName - None

  • availToRealTime — N

• For voltp, enter the following in the listed field:

  • tableColumnCode — 653

  • tableDesc:tableName — unitConvMatrix

  • columnName — voltp

  • problemName — voltp

  • columnAlias — VOLTP

  • generateMacros — Y

  • description — Voltage precision

  • SQLDataTypeName — T_tinyintType

  • CDataTypeName — char

  • numericSetDesc:numericSetName — Voltage

  • columnOrder — 100

  • inHMI — N

  • hmiName — voltp

  • aggregationName - None

  • availToRealTime — N

    Note: The required tableDesc entries are in the default AVEVA Measurement Advisor configuration.

You will need to define the unitBaseDesc as described below before adding units:

• Go to the Select Table tab.

• Double-click unitBaseDesc to open the tab and navigate to it.

• Set the module to CD_PROJECT.

• You will need to decide what the base unit will be, and select Insert to create a new entry for unitBaseDesc.

  Consider the following example of using Volts as the base unit for Voltage:

  • unitBaseCode — 888

  • unitBaseName — Volts

  • physicalProperty — voltage

  • description — base unit for Voltage

  • unitBaseDefine — UBD_VOLTS

The units will have to be added to the file as described in Add new units to a numeric set.

Note: The new configuration will be loaded after you have created and loaded the associated units.