About the Wonderware Data Historian activity

Manufacturers often collect data from monitored machines/equipment during production and then store the data in a Wonderware Historian SQL database. The collected data identifies the machine and date and time, but doesn't include the unit UID.

Before a unit is processed by monitored machines, a validation should be done to ensure the conditions are suitable. Once a unit is validated, the conditions it experiences as it is processed through or past the monitored machines can be recorded in the unit’s build history in FactoryLogix as sampled data. 

The Wonderware Data Historian activity in the NPI Process Definition window allows you to configure and collect sampled measurement data so you can identify data trends during production runs. The Wonderware Data Historian activity is available for serialized production processes or serialized operations within hybrid processes.

Configure Wonderware database connection details

Before you can add the Wonderware Data Historian activity to a process definition in NPI, you need to configure the connection details for the Wonderware database. This configuration includes four settings found in the System Configuration > Settings area of NPI, under the Option Type: Wonderware Historian Activity in the Process Planning category of the Global Options tab.

Specify the appropriate Wonderware information for each of these options:

Add the Wonderware activity to a process definition in NPI

If you didn't configure the Wonderware database connection details in NPI Settings (see the previous topic), you will see this message:

When the Wonderware Data Historian activity is added to a process definition in the NPI Process Definition window, the process designer can do the following:

• Author the instructions for the shop-floor operator related to this activity.
• Indicate whether the activity is required or optional.
• Identify zero or more validation parameter tags to be validated before a unit can be processed (see Point A in the following illustration).
• Identify zero or more trending measurement tags whose values are recorded against a unit while the unit is being worked on. To reduce the volume of data recorded in FactoryLogix, the process designer will specify the number of measurements to be recorded (between Point A and Point B in the following illustration).
• Identify zero or more final value measurement tags whose values are against a unit in FactoryLogix.
  
  
  
  

What happens in Production?

After you configure the Wonderware Data Historian activity for a process definition in NPI, here's what happens in Production:

When the Wonderware Data Historian activity is displayed for a serialized unit in Production, the instructions authored in NPI are displayed to the operator and an Activity is Completed? check box and a Start button are displayed:



When the shop-floor operator selects the Start button, the activity uses the validation parameters to validate that the latest value for each tag recorded in the Data Historian data is within the acceptable range as defined in the activity configuration in NPI. If the validation parameters pass their validation, the Start button is disabled/dimmed. The unit (now at Point A in the previous illustration) is ready to be processed through the monitored machines.

When the unit has been processed through the monitored machines, the shop-floor operator selects the Activity is Completed? check box. At this point the activity (now at Point B in the previous illustration) is complete.

If the Start button is disabled and the operator pauses the WIP transaction, when the WIP transaction resumes—either by the same operator or a different one—upon entering the activity, the Start button is disabled.

When the activity is recorded as Completed, the activity queries the Wonderware Data Historian for the data to record the trending measurements. Further, if any final value measurements were defined, the activity queries the Wonderware Data Historian for the data to record those measurements.

How does the query for trending measurements work?

The query to retrieve data for trending measurements returns all values recorded to the specified tags in the Wonderware Data Historian from the time the validation parameters were validated through the time when the operator marked the activity as Completed.

Since the volume of data may be significant, it is not desirable to record all the data in FactoryLogix. The query includes a parameter to specify the number of measurements per tag to be returned to help manage the data collection.

The query to retrieve the data for the final value measurements will return the last measured value recorded for each tag identified.

Each value returned by these queries is recorded as a FactoryLogix parametric measurement:

• The Type is the parameter name.
• The Value is the value returned by the query for the parameter.
• The Activity is Wonderware Data Historian.
• The Measurement Date Time is the date/time returned by the query.

Configure the Wonderware activity in NPI

When configuring the Wonderware Data Historian activity in NPI, process designers need to define the following on the Activity Details tab of the Settings dialog:

• Validation Parameters
• Trending Measurements

• Final Value Measurements
  
  Use the Add Item , Edit Item  , and Delete item  buttons on the Activity Details tab to enter, edit, and/or delete parameters and measurements related to the Wonderware activity.
  
  

  Note:

  All tag values must be of type Float.

  

Validation Parameters

You can configure zero or more Validation Parameters on the Activity Details tab of the Settings dialog:

• Wonderware Tag Name - The tag name recorded in the Wonderware Data Historian database
• Minimum Value - The minimum validation value
• Maximum Value - The maximum validation value

Trending Measurements

The activity configuration allows you to define zero or more of these Trending Measurements on the Activity Details tab of the Settings dialog:

• Wonderware Tag Name - The tag name recorded in the Wonderware Data Historian database
• FactoryLogix Measurement Name - The tag name to be recorded in FactoryLogix
• Sub Interval Count - An integer value with a minimum value of 1
  
  The processing uses the reporting window (Point A to Point B in the following illustration) and returns a measurement for each sub-interval plus one.
  
  Example: If the reporting window was from 1:00 PM to 2:00 PM and 4 measurement sub-intervals were requested, then 5 measurements will be recorded (the tag values at 1:00 PM, 1:15 PM, 1:30 PM, 1:45 PM and 2:00 PM).
  
  
  

Final Value Measurements

The activity configuration allows you to define zero or more of these Final Value Measurements on the Activity Details tab of the Settings dialog:

• Wonderware Tag Name - The tag name recorded in the Wonderware Data Historian database
• FactoryLogix Measurement Name - The tag name to be recorded in FactoryLogix

Querying the Wonderware Data Historian

Validation parameters

This query returns the most recently recorded value for each of the identified tags.

SELECT TagName, Value

FROM Live

WHERE TagName in ('<TagName 1>[,<TagName 2>…]')

Trending measurements

This query returns all values recorded for the identified tag within the specified time window.

SELECT DateTime, TagName, Value

       FROM History

WHERE TagName = '<TagName>'

       AND DateTime >= '<Start of time window>'

       AND DateTime <= '<End of time window>'

       AND wwRetrievalMode = 'Cyclic'

       AND wwCycleCount = '<SubIntervalCount>'

For each row returned by this query, a parametric measurement will be recorded in the FactoryLogix database against the unit that was worked on:

* These are the column names displayed on the Parametric tab in the Trace window in Production.

Final value measurements

This query returns the last recorded value within the specified time window for each of the identified measurements recorded.

SELECT DateTime, TagName, Value

FROM Live

WHERE TagName in ('<TagName 1>[,<TagName 2>…]')

For each row returned by this query, a parametric measurement will be recorded in the FactoryLogix database against the unit that was worked on:

* These are the column names displayed on the Parametric tab in the Trace window in Production.