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 |