Our Brands

Impact-Company-Logo-English Black-01-177x54

Schneider Electric USA Website

Welcome to our website.
		
How can we help you today?
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

Schneider Electric USA

Attachment(s)
TopicID_QuantityID.sql [406 Bytes]
Explore more
Range:
Users group

Discuss this topic with experts

Visit our community and get advice from experts and peers on this topic and more
Explore more
Range:

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.

  • Products Documentation
  • Software Downloads
  • Product Selector
  • Product Substitution and Replacement
  • Help and Contact Center
  • Where to buy
  • Get a Quote
  • Find our Offices
  • Careers
  • Company Profile
  • Report a misconduct
  • Accessibility
  • Newsroom
  • Investors
  • EcoStruxure
  • Job Search
  • Blog
  • Tech Support: 877-342-5173
  • Privacy Policy
  • Cookie Notice
  • Terms of use
  • Change your cookie settings