Technical FAQs

Ask a Question

PME 7.2/8.x: How to determine the measurement's TopicID when configuring the Billing Report Rate.xml file?

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
EcoStruxure Power Monitoring Expert (PME) 7.2.x, 8.x

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
Was this helpful?
What can we do to improve the information ?