Follow

What is a Retrieved Measure?

Retrieved Measures are used to collect data from the data sources you have connected to your Flow System. These measures are responsible for collecting, summarizing and storing data from the “outside world” in your Flow System.

When you configure a measure as a Retrieved measure, the Retrieval section of the Measure Editor looks similar to:

ModelOverview-MeasureEditor-RetrievedConfig-WithoutFilterTag.png

The following properties may be configured:

  • Aggregation
This determines how the detailed data (i.e. high-resolution data) should be summarized into the interval of the measure (e.g. hourly, shiftly, etc.) for reporting purposes.  By default, Flow uses the Average aggregation method.
  • Tag
The Data Source tag for which summary data is retrieved (this is usually populated during a drag n’ drop action of a tag from the Data Source Namespace, but it can be added and/or modified manually if required, or another tag can also be dragged over and dropped onto this textbox).
  • Scaling Factor
This is a factor that the resultant summarized value is multiplied by in the case where scaling is required (e.g. simple unit of measure scaling).
  • Filter Tag
When retrieving data from a Data Source, Flow can use the value of another tag (or the same tag) to filter out unwanted detailed data. Flow will use the values in the Filter Tag and compare against the filter condition to determine whether the detailed data should be used in the calculation or not.

Where a Data Source supports the use of Filter Tags, if you include a Filter Tag in the Retrieval Section, the following properties become available for configuration.

ModelOverview-MeasureEditor-RetrievedConfig-WithFilterTag.png

  • Filter Comparator
This is the comparator part of the filter condition.
  • Filter Value
This determines how the detailed data (i.e. high-resolution data) should be summarized into the interval of the measure (e.g. hourly, shiftly, etc.) for reporting purposes.  By default, Flow uses the Average aggregation method.
  • Filter Default
This is used by Flow if all the detailed data is filtered out of a time period.  Flow will use this default value for the measure value for that time period.

 

Most Flow Data Source types represent tag-based time-series data.  But there are also Data Sources which contain transactional data, and against which queries need to be executed to retrieve the required data.  For a transactional-type Data Source, where the concept of a tag does not exist, the Retrieval section of the Measure Editor appears similar to:

ModelOverview-MeasureEditor-RetrievedConfig-TransactionalDS.png 

  • Query
The Data Source query that must be executed to return the summarized data for the interval with which this measure is configured.  The query may also return all values for the interval (similar to how a time-series type Data Source would) and one of Flow's aggregation methods may be configured to summarize the detailed data.
  • Aggregation
This determines how the detailed data (i.e. high-resolution data) should be summarized into the interval of the measure (e.g. hourly, shiftly, etc.) for reporting purposes.  By default, Flow uses the Average aggregation method.

 

Flow has defined a number of aggregation methods to standardize how detailed data is summarized into Flow.

Note that Flow does not replicate the detailed data from your data sources in the Flow System. It will only store the summarized information in the Flow System.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments