Technical FAQs

Ask a Question

How to change the units of a custom quantity in Power Monitoring Expert 8.0?

A custom quantity has been assigned the incorrect units and needs to be modified.

Product Line
Power Monitoring Expert 8.0

SQL Server Management Studio

*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

The following SQL query removes the incorrect unit and associates the custom quantity with the new unit. For a list of standard units, please refer to FA279791.

-- Delete the existing relationship with the Incorrect Unit "unit/perunit"
DELETE [ION_Network].[dbo].[TS_Triples]
    [ION_Network].[dbo].[TS_Triples] t
    [ION_Network].[dbo].[TS_Resources] subject
    ON subject.[Hash] = t.[Subject]
    [ION_Network].[dbo].[TS_Resources] object
    ON object.[Hash] = t.[Object]
    subject.[Name] = N'Cstm-Msmt'  -- The name of the Custom Measurement goes here.
    AND object.[Name] = N'unit/perunit'  -- The name of the Incorrect Unit goes here.

-- Create the New Unit "New Unit" and associate it with Custom Measurement "Cstm-Msmt"
EXECUTE [ION_Network].[dbo].[spTS_StandardRelationship_Add] N'Cstm-Msmt', N'unit', N'New Unit', 'Q'

For instructions on assigning a custom unit, refer to FA209765.
Was this helpful?
What can we do to improve the information ?