Rockwell Automation FactoryTalk Metrics User Guide - Manual (Page 243)

Advanced Reporting Topics Chapter 7
To create detailed derived fields:
1. On the Configure menu in the Configuration Console, click
Reporting > Report Data Sources, Objects, and Filters.
The Configure Report Data Sources, Report Objects, and
Filters dialog box appears.
2. Under Report Data Sources, click Add.
The Report Data Source Configuration wizard appears.
3. Click Next.
The Report Data Source Name page appears.
4. In the Report Data Source Name box, type Workcell Detailed
Derived Fields Example.
5. Click Next.
The Choose a Database Table or View page appears.
6. Select (Local Server Database) in the list.
7. Clear the Show Tables check box to display only the database
views.
8. Select the OEEQWorkcell view.
The selected database view is the view used by the standard
FactoryTalk Metrics Workcell History report data source.
9. Click Next.
The Column Selection page appears.
10. Under Columns in Table or View, press and hold Ctrl, and
click the sDescription, tStart, sPartId, dTotalParts, and
dIdealCycleTime columns.
11. Click .
The selected columns are moved under Columns in Report
Data Source.
Create Detailed Derived
Fields
Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014 243