New in the Community? Get started here

Schneider Electric Exchange Community

Discuss and solve problems in energy management and automation. Join conversations and share insights on products and solutions. Co-innovate and collaborate with a global network of peers.

Register Now
Resource Advisor - Performance Analytics Forum
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Commander

Disaggregation error in PAM with Calculated Measurements that use RAMetric()

Synopsis:

When the Total Type is set to anything other than "Average", the resulting metric won't work at any shorter time period than the frequency of the data stream without some special handling in the calculated measurement expression.

There are two ways to change that:

  1. Change the Total Type for the metric to 'Average'.
  2. Edit your Calculated Measurement expression and change the RAMetric() reference to explicitly allow disaggregation by adding a directive.  Either put [[DisaggregationMethod=>Constant]] or [[DisaggregationMethod=>LinearInterpolate]] in front of the RAMetric().
    1. 'Constant' will repeat the metric value unaltered at any smaller time interval.
    2. 'LinearInterpolate' will divide the number by the time fraction, so the value for each month would be divided by the number of days in that month if shown as a daily value.


When referencing metric data in a calculated expression in PAM using the RAMetric() function, there are two settings that influence how it is treated, the Frequency and Total Type.

     Administration/Manage Data Streams/(Your Data Stream)/Setup Tab/Frequency

and

     Administration/Manage Data Streams/(Your Data Stream)/Details Tab/Advanced Configurations/Base Level/Total Type

Frequency can be one of:

  • Monthly
  • Quarterly
  • Semi Annual
  • Annually
  • Constant
  • Versioned

Base Level/Total Type can be one of:

  • Average
  • Max
  • Min
  • Most Recent
  • None
  • Sum

When the Total Type is set to anything other than "Average", the resulting metric won't allow disaggregation to any shorter period than the frequency of the data stream without modifying the calculated measurement expression.

So if you have a Monthly metric and its Total Type is set to 'Sum', and you try to view that at daily resolution in  a Trend card in PAM, you'll get a disaggregation error.