Rockwell-automation FactoryTalk Report Expert User Guide Manual de usuario descargar pdf (Pagina 143)

Administering Report Expert Chapter 9

Rockwell Automation Publication RPTEXP-UM001H-EN-P-June 2014 143

Use this setting: To modify:

from reading or writing data. Writing data by other

transactions does not block a “snapshot” transaction from

reading data. Before you can use the Snapshot isolation

level, in Microsoft SQL Server Management Studio, set the

ALLOW_SNAPSHOT_ISOLATION to ON.

Performance note: You may want to change isolation

levels if you are experiencing issues with timeouts while

running data collection.

UseShortName From where report work cell names are taken. They can be

taken either from the work cell short name (defined in the

Configuration Console) or from the activity area (defined in

the plant model and displayed in Report Expert Plant Model

parameter).

If this setting is set to 1, the work cell names are taken from

the OEEConfigWorkcell.sShortName field.

If this setting is set to 0 (default value) or another number

other than 1, the work cell names displayed in the reports

are taken from the FDMActivityArea.sActivityAreaName

field.

Tip: You can modify both short (reporting alias) names and

activity area names through the Configuration Console. For

information, refer to the FactoryTalk Metrics User Guide.

TIP

To define color values in the color-related settings (ColorBest,

ColorBeyond, ColorNormal, and ColorLow) use either hexadecimal color

values (e.g. #FF0000) or standard HTML color names (e.g. "Red").

To modify default settings:

1. Launch Microsoft SQL Server Management Studio for

Microsoft SQL Server.

2. Using the user name and password that you used to log in to

your DNS connection, log in to the Microsoft SQL Server

instance that contains the FactoryTalk Metrics database.

3. In the Object Explorer, go to Databases > <FactoryTalk

Metrics database name> > Tables.

Modifying the RptSetting

Table

1 2 ... 138 139 140 141 142 143 144 145 146 147 148 ... 181 182

Sin comentarios

Rockwell-automation FactoryTalk Report Expert User Guide Manual de usuario Pagina 143