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
