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

Chapter 9 Administering Report Expert
138 Rockwell Automation Publication RPTEXP-UM001H-EN-P-June 2014
The Report Expert settings are stored in the FactoryTalk Metrics
database in the RptSetting table. To modify the settings, use
Microsoft SQL Server Management Studio. Some settings can be
modified on the Report Expert Administration page.
NOTE
Modify the settings with care because their modifications may have a
significant impact on Report Expert performance and will affect all
Report Expert users.
The following table lists Report Expert settings that you can modify:
Use this setting: To modify:
CacheExpirationTime The cache that populates all of the unique values in Report
Expert Filtering and Plant Model parameters (see "Using the
Filtering Parameter (page 91)" and "Using the Plant Model
Parameter (page 90)"). It is the wait time in seconds from
the moment Report Expert is launched and the cache is
automatically populated until the cache is updated again
from the database. As a default, this is set to 300 seconds.
Performance note: Refreshing the cache is a global
process that takes place at the server level. This is a
time-intensive process responsible for the initial delay when
Report Expert is launched. Increase this value if Report
Expert launches too slowly, though the launch process time
will shorten with a subsequent client launch. If the cache is
refreshed infrequently, the latest data values may not
appear in the Filtering or Plant Model parameters lists. This
is the trade-off with less frequent refreshes.
ColorBest The color used in the OEE% chart. This color will signify a
high value of OEE%, above the number set in the
ThresholdNormalBest field, but below
ThresholdBestBeyond.
ColorBeyond The color used in the OEE% chart. This color will signify a
very high value of OEE%, above the number set in the
ThresholdBestBeyond field. Default setting is the same as
the ColorBest setting.
ColorLow The color used in the OEE% chart. This color will signify a
low value of OEE%, below the number set in the
ThresholdLowNormal field.
Configuring Report Expert
Settings