Each Column in a Report represents the data from one Analog Tag recorded to the ODBC Analog Tag Log. Shift, Daily and Monthly versions of the report use the same Tags, columns and Data.
Different calculations (Average, Total, Min, Max, Last Value) can be performed in the Shift, Daily and Monthly Reports. These are specified under the Tag Property Button for each report.
The Titles of the Columns for the Reports are specified in the Tag Property for each report (a column represents one Tag’s data). The three reports can have different Titles for each column or share the Titles based on another report (e.g. import Shift Report Titles to Daily, or Daily into Monthly).
To Configure the Daily Report Tag Properties:
1. Add a Scheduled Report or select Update from the Scheduled Report List (Figure 21.10).
2. Click the Tag Property button listed under Daily Report.
3. The Daily Report Tag Property page opens.
Figure 21.14 Shift Report Tag Property
4. There can be up to 12 Columns per report (twelve tags).
5. You can import Title information, if another version of this report (Shift or Monthly) has already been configured with Tag Property.
a. From the pull down list next to Title, the choices are
i. User Input - Title information entered or edited manually here.
ii. Import from Shift – will import the Titles from the Shift Report version (if configured).
iii. Import from Monthly – will import the Titles from the Monthly Report version (if configured).
b. You can edit the Titles with Import from Shift or Import from Monthly selected; this will not change the Daily or Monthly reports.
c. Selecting User Input will return to the Titles last saved using the Submit button. Once you press submit, the User Input version becomes the current titles displayed.
d. If you can’t import, then manually enter the Header Title information for each Column of the Report. There are 4 text lines per header on each column. See Shift Report for an example of Column Headers.
6. Display Methods defines a calculation for the data collected the tag (Average, Minimum, Maximum, Last Value or Total). This defines how each “cell” in the report calculated from the records in the ODBC Log database.
e. Average is the simple average of the values (Total / no. of records) for the One (1) Hour interval this row represents.
f. Maximum and Minimum are for the One (1) Hour interval this row represents.
g. Total is the simple sum of all records for the One Hour (60 minute) interval this row represents. You must consider the engineering units of the tag, the Log to ODBC Frequency, the deadband, the number of samples recorded because of the deadband, and the Factor for this report to make this a meaningful total.
Average is the easier way to calculate Total. The easiest way to make sure your Totals are meaning full is to use:
Average and a Factor convert the time units of Tag’s Engineering Units to one hour.
This makes the Total independent of the Log To ODBC frequency, the Deadband for the Tag and the number of sample actually recorded in the ODBC Log.
For example, if the tag’s engineering units are Gallons / Minute, a Factor = 1/60 minutes (0.0167) results in a Total value if Average is used, regardless of the Log to ODBC Frequency. (I.e. the Total Flow over 1 hour period is the same as the Average Flow Rate / Hour for the one hour period).
h. Last Value is the last value recorded for the tag during this recording interval. This is typically used for closing inventory on Tanks or meters.
The calculation for each cell applies to all records found in the ODBC log for the One Hour Interval (60 minutes) this row represents. Daily Reports are always a One Hour period for each row of the report. The user should ensure this period is greater or equal to the ODBC record frequency for the tag.
7. Factor is a multiplier used for units and time conversion. For example, if the tag engineering units are gallons / per minute and your total is for a one hour interval, you need a multiplier of 0.0167 (1/60). The result of the Average, Minimum, Maximum, Total or Last Value calculation is multiplied by this factor.
8. Decimal Places defines how many digits after the decimal point (e.g. tenths, hundredths, thousandths) will be displayed in the report.
9. Report Summary defines the rows at the bottom of each column. Summary Data at the bottom of each Column can be calculated: Maximum, Minimum, Average, Last Value and Total for the column.
10. Press Submit to save these entries.
Download to the SCADA Node to make these changes effective.