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
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
Released for: Schneider Electric USA


Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales inquiry online and an expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Center
Find support resources for all your needs, in one place.