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

Chapter 7 Advanced Reporting Topics
18. Under Supported Formats, select one of the following
options that best describes your database table or view:
Select this option: If:
Table is not in a time-series format. Your table does not contain any
time-series data. This setting will
disable the time-series analysis and
FactoryTalk Transaction Manager
time-series data collection for the report
data source.
Narrow Format. All Reporting Tags in a
single column. The reporting tag values are stored in a
single column of the table.
Wide Format. Each Reporting Tag in
separate column. Your table has a separate column for
each reporting tag.
Compression. Your table contains compressed
time-series data that has been collected
using the FactoryTalk Transaction
Manager Compression engine.
19. Click Next.
NOTE
If you have selected the Table is not in a time-series format
option, the wizard skips to the last step of the procedure.
The Match Time-series Columns page appears.
20. Specify the role of each database field in the time-series
analysis:
If you have selected this
option:
Specify:
Narrow Format • The field that contains the reporting tag ID.
• The field that contains the timestamp.
• The field that contains the value.
Wide Format • One or more fields that contain the
reporting tag values.
• The field that contains the timestamp.
1. Under Time-series Use, click a table cell.
2. From the list, select a role for the cell.
21. Click Next.
240 Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014