Which measurements are used by the Energy Cost and Load Profile reports?

Search FAQs

Issue
The Energy Cost and Load Profile reports require that data is logged to specific measurements in order to run.

Product Line
ION Enterprise 6.0 SP1
Struxureware Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.0

Environment
Web Applications Reports

Cause
The Energy Cost, and Load Profile reports have a list of possible measurements that it looks for in a specific order. The default order is indicated below, but note that the order can be configured or additional measurements can be added via a SQL query or by editing the view directly in Management Studio. This list of measurements is read from the database its an entry in vCFG_ConfigItems (a view in ION_Network)

Resolution
Energy Cost Report:

kWh:
Active Energy Delivered-Received - ID135
Active Energy Delivered+Received - ID198
Active Energy Delivered ID129
Active Energy Received Rate A ID130
Active Energy Delivered Interval ID134
Active Energy Received Interval ID144

MeasurementID	Labels Mapped To This Measurement
135	kWh del-rec kWh net Real Energy Signed Real Energy
198	kWh del+rec kWh tot Real Energy Absolute
129	kWh del, kWh imp, kWh kWh tot del Real Energy into the Load
130	kWh del A kWh del tariff 1
134	kWh del int kWh imp int Real Energy Delivered Interval
144	kWh rec int kWh exp int Real Energy Received Interval

kVARh:
Reactive Energy Delivered-Received ID97
Reactive Energy Delivered + Received ID191
Reactive Energy Delievered ID91
Reactive Energy Received Rate A ID92
Reactive Energy Delivered Interval ID96
Reactive Energy Received Interval ID106

Measurement ID	Labels Mapped To This Measurement
97	kVARh del-rec kVARh net Reactive Energy Signed Reactive Energy
191	kVARh del+rec kVARh tot Reactive Energy Absolute
91	kVARh del kVARh imp kVARh Reactive Energy Into the Load
92	kVARh del A kVARh del tariff 1
96	kVARh del int kVARh imp int
106	kVARh rec int kVARh exp int

kVAh:
Apparent Energy Delivered + Received ID63
Apparent Energy Delivered-Received ID740
Apparent Energy Delivered ID489
Apparent Energy Delivered + Received Rate A ID2659

MeasurementID	Labels Mapped To This Measurement
63	kVAh kVAh del+rec kVAh tot Apparent Energy
740	kVAh net kVAh del-rec
489	kVAh del kVAh imp
2659	kVAh tariff 1

kW:
Active Power Sliding Window Demand Delivered-Received ID107
Active Power Sliding Window Demand Delivered+Received ID738
Active Power Sliding Window Demand Delivered ID116
Active Power Thermal Demand Delivered-Received ID117
Active Power Sliding Window Demand Received ID739

MeasurementID	Labels Mapped To This Measurement
107	kW sd del-rec kW swd kW tot swd kW Dmd del-rec Demand Real Power Sliding Demand Real Power
738	kW sd del+rec
116	kW demand kW sd del kW tot SD
117	kW td del-rec Demand Real Power - Thermal
739	kW sd rec

kVAR:
Reactive Power Sliding Window Demand Delivered Received ID69
Reactive Power Sliding Window Demand Delivered+Received ID735
Reactive Power Sliding Window Demand Delivered ID78
Reactive Power Thermal Demand Delivered-Received ID79
Reactive Power Sliding Window Demand Received ID737

MeasurementID	Labels Mapped To This Measurement
69	kVAR sd del-rec kVAR swd kVAR Dmd del-rec Demand Reactive Power Sliding Demand Reactive Power
735	kVAR sd del+rec
78	kVAR demand kVAR sd del kVAR tot SD
79	kVAR td kVAR td del-rec Demand Reactive Power - Thermal
737	kVAR sd rec

kVA:
Apparent Power Sliding Window Demand Delivered+Received ID37
Apparent Power Sliding Window Demand Delivered-Received ID736
Apparent Power Sliding Window Demand Delivered ID573
Apparent Power Thermal Demand Delivered+Received ID47

MeasurementID	Labels Mapped To This Measurement
37	kVA sd del+rec kVA swd kVA Dmd Demand Apparent Power - Sliding
736	kVA sd del-rec
573	kVA demand kVA sd del kVA tot SD Demand Apparent Power
47	kVA td

Load Profile Report:

Active Demand:
Active Power Sliding Window Demand Delivered-Received ID 107
Active Power Sliding Window Demand Delivered+Received ID 738
Active Power Sliding Window Demand Delivered ID 116
Active Power Thermal Demand Delivered-Received ID 117
Active Power Sliding Window Demand Received ID 739

MeasurementID	Labels Mapped To This Measurement
107	kW sd del-rec kW swd kW tot swd kW Dmd del-rec Demand Real Power Sliding Demand Real Power Panel-Main Demand Real Power
738	kW sd del+rec
116	kW demand kW sd del kW tot SD
117	kW td del-rec Demand Real Power - Thermal
739	kW sd rec

Reactive Demand:
Reactive Power Sliding Window Demand Delivered Received ID 69
Reactive Power Sliding Window Demand Delivered+Received ID 735
Reactive Power Sliding Window Demand Delivered ID 78
Reactive Power Thermal Demand Delivered-Received ID 79
Reactive Power Sliding Window Demand Received ID 737

MeasurementID	Labels Mapped To This Measurement
69	kVAR sd del-rec kVAR swd kVAR Dmd del-rec Demand Reactive Power Sliding Demand Reactive Power
735	kVAR sd del+rec
78	kVAR demand kVAR sd del kVAR tot SD
79	kVAR td kVAR td del-rec Demand Reactive Power - Thermal
737	kVAR sd rec

Apparent Demand:
Apparent Power Sliding Window Demand Delivered+Received ID 37
Apparent Power Sliding Window Demand Delivered-Received ID 736
Apparent Power Sliding Window Demand Delivered ID 573
Apparent Power Thermal Demand Delivered+Received ID 47

MeasurementID	Labels Mapped To This Measurement
37	kVA sd del+rec kVA swd kVA Dmd Demand Apparent Power - Sliding KVA SD
736	kVA sd del-rec
573	kVA demand kVA sd del kVA tot SD Demand Apparent Power
47	kVA td kVA td del+rec Demand Apparent Power - Thermal

Power: for devices that don't do SWD
Active Power ID193
Reactive Power ID187
Apparent Power ID544

MeasurementID	Labels Mapped To This Measurement
193	kW tot kW total Real Power Total
187	kVAR tot kVAR total Reactive Power Total
544	kVA tot kVA total Apparent Power Total