Issue
User wants to determine the correct TopicID to use when creating a Billing report for a device that is logging a particular measurement.

Product

Power Monitoring Expert 9.x

Power Monitoring Expert 2020

Power Monitoring Expert 2021

Power Monitoring Expert 2022

Power Monitoring Expert 2023

Power Monitoring Expert 2024

Environment
Billing Report

Cause
By default, the billing report will use pre-set TopicID's that are associated with default QuantityID's, while the device may be logging the measurement using another QuantityID and therefore using a different TopicID.

Resolution
*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.*

1) Open SQL Server Management Studio and connect to the instance used by PME for data logging purposes.
2) Execute the query below:

SELECT
t.TopicID,
q.ID AS QuantityID,
t.Description as TopicDescription,
q.Name as QuantityName,
dst.Description as DataSourceTopicDescription
FROM
ApplicationModules.CommonDataModel.Topic t
JOIN ApplicationModules.DataSourceBus.DataSourceTopic dst ON t.topicID = dst.TopicID
JOIN ION_Data.dbo.Quantity q ON dst.DataSourceRepresentation = q.name
ORDER BY
q.ID

An example of the table returned:



Refer to FA277059 on how to edit the rate .xml file to add desired Topic ID

Released for: Schneider Electric USA