Rockwell Automation FactoryTalk Report Expert User Guide - Manual (Page 142)

Chapter 9 Administering Report Expert
142 Rockwell Automation Publication RPTEXP-UM001H-EN-P-June 2014
Use this setting: To modify:
ColorBest setting changes into the color from the
ColorBeyond setting on the OEE% chart.
ThresholdLowNormal The limit of the OEE% value, after which the color from the
ColorLow setting changes into the color from the
ColorNormal setting on the OEE% chart.
ThresholdNormalBest The limit of the OEE% value, after which the color from the
ColorNormal setting changes into the color from the
ColorBest setting on the OEE% chart.
TransactionIsolationLevel The transaction isolation level to be used by DPE when
executing a set of SQL commands. Following are the
definitions of possible transaction isolation level values
supported by Report Expert:
Read Committed (0). Read only transactions that have not
been modified by other transactions and are committed.
Data can be changed by other transactions between
individual statements within the current transaction, but
the resulting data cannot be read again until such changes
are committed.
If you type 0 or leave this setting blank, this default isolation
level is used.
The behavior of Read Committed depends on the Read
Committed Snapshot database option set in Microsoft SQL
Server.
Read Uncommitted (1). Transactions running at the Read
Uncommitted isolation level do not use shared locks to
prevent other transactions from modifying data read by the
current transaction. This isolation level allows uncommitted
rows that have been modified to be read, therefore data can
be modified and rows can appear or disappear. To use the
Read Uncommitted isolation level, set the
TransactionIsolationLevel setting to 1. You may want to use
this option if a report times out due to uncommitted data
and therefore cannot display a subreport.
Snapshot (2). This isolation level specifies that data read
by any statement in the transaction will be consistent with
the data at the start of the transaction. Data modifications
made by other transactions after the start of the current
transaction are not visible in the current transaction. The
Snapshot isolation level does not prevent other transactions