mi12ft metrics pick and choose lab

1、FactoryTalk Metrics Pick and Choose Lab Lab 4 Editing Collected DataFor Classroom Use Only!Important User InformationThis documentation, whether, illustrative, printed, “online” or electronic (hereinafter “Documentation”) is intended for use only as a learning aid when using Rockwell Automation appr

2、oved demonstration hardware, software and firmware. The Documentation should only be used as a learning tool by qualified professionals.The variety of uses for the hardware, software and firmware (hereinafter “Products”) described in this Documentation, mandates that those responsible for the applic

3、ation and use of those Products must satisfy themselves that all necessary steps have been taken to ensure that each application and actual use meets all performance and safety requirements, including any applicable laws, regulations, codes and standards in addition to any applicable technical docum

4、ents.In no event will Rockwell Automation, Inc., or any of its affiliate or subsidiary companies (hereinafter “Rockwell Automation”) be responsible or liable for any indirect or consequential damages resulting from the use or application of the Products described in this Documentation. Rockwell Auto

5、mation does not assume responsibility or liability for damages of any kind based on the alleged use of, or reliance on, this Documentation.No patent liability is assumed by Rockwell Automation with respect to use of information, circuits, equipment, or software described in the Documentation.Except

6、as specifically agreed in writing as part of a maintenance or support contract, equipment users are responsible for:properly using, calibrating, operating, monitoring and maintaining all Products consistent with all Rockwell Automation or third-party provided instructions, warnings, recommendations

7、and documentation;ensuring that only properly trainednel use, operate and maintain the Products at all times;staying informed of all Product updates and alerts and implementing all updates and fixes; andall other factors affecting the Products that are outside of the direct control of Rockwell Autom

8、ation.Reproduction of the contents of the Documentation, in whole or in part, without written permission of Rockwell Automation is prohibited.Throughout this manual we use the following notes to make you aware of safety considerations:Identifies information about practices or circumstances that can

9、cause an explosion in a hazardous environment,which may lead toal injury or death, property damage, or economic loss.Identifies information that is critical for successful application and understanding of the product.Identifies information about practices or circumstances that can lead to damage, or

10、 economic loss. Attentions help you: identify a hazard avoid a hazard recognize the consequenceal injury or death, propertyLabels may be located on or inside the drive to alert people that dangerous voltage may be present.Labels may be located on or inside the drive to alert people that surfaces may

11、 be dangerous temperatures.FactoryTalk Metrics Pick and Choose Lab 4 Editing Collected DataContentsBefore you begin5About this lab5Tools & prerequisites7Getting Started8Starting the VMWare Image at the proper Snapshot8Updating the FTMetrics Database8Starting the FactoryTalk View SE Project11Open and

12、 Run the FactoryTalk View SE Project11Start Data Collection13Production Simulation in FactoryTalk View SE15Lab Objectives19Creating the data that will be edited20Generate Event data20OEE Calculations25Review the Configuration of Events26out the data that will be edited35Editing Part Counts36Examine

13、the effects of the change in Part Count data43Editing Event Data45Edit an Event Value and Event Name45Examine the effects of the change in Event data54Split an Event56Examine the effects of the change in Event data65Effect of Availability and Running Performance Parameters on Editing Events70Importa

14、nt things to know about editing data in Report Expert80Editors must be members of FTMetricsEditors803 of 88Some Editing capabilities were not shown in the lab80Configuration of workcells and events has an impact on editing80You cant edit data that is being updated80Considerations with editing Monito

15、red Value Events81No overlapEvents81You cant fill in data where there was no collection81Not all Report Expert parameters are supported in the Editor screens81No audit trail81Custom User Interfaces for Editing82You can create entries in the Report Explorer for the Editor85Summary884 of 88Before you

16、beginFactoryTalk Metrics is a solution for optimizing production efficiency by monitoring equipment downtime causes, part counts, bottlenecks, and other production events. For each workcell in your facility, FactoryTalk Metrics monitors Overall Equipment Efficiency (OEE), which is a measure of avail

17、ability, production rates, and quality. OEE is one of many key performance indicators that FactoryTalk Metrics provides to help you evaluate your manufacturing performance.FactoryTalk Metrics is not just an “OEE Product”. Its most powerful capabilities allow you to configure data collection andrepor

18、ting on production events of any kind, including but not limited to downtime events, with greatand granularity. Thised data helps you identify the root cause of process inefficiencies and to prioritize improvement efforts forum impact.About this labFactoryTalk Metrics is designed to collect data aut

19、omatically from a control system, including PLCs and HMIs, with little or no human interaction. This ensures that data is collected consistently, data is accurate, and information presented on reports is timely. The FactoryTalk View SE project and SoftLogix controller used in this lab is a typical,

20、although simulated, example. Our example has more operator interaction than usual the operator (you) must initiate all machine faults and stops on the HMI in a real system many of these would be triggered automatically by the production equipment. The operator (you) also chooses Reason Codes for som

21、e events from a list this is common.Even in a system that collects its data automatically, there are occasions when it is desirable to be able to edit the automatically- collected data after the fact. Examples include:Scrap counts cannot be determined in real timeReason codes for events cannot be en

22、tered by the operator until the event is over Events are not captured accurately by the control system.FactoryTalk Metrics version 10.50 contains some new capabilities for editing collected after the fact. Report Expert has been enhanced to add a new user interface for editing data. In this lab you

23、will explore these new editing capabilities, and will:Edit part counts to add scrap Edit event data, includingo Changing event nameo Split an event into two eventsObserve the data synchronization behavior that is part of the data editing process and preserves data integrityIt is expected that you ha

24、ve some experience with and knowledge of FactoryTalk Metrics configuration, reporting, and the datam.This lab takes approximately 60 minutes to complete.5 of 88This lab uses one VMWare image. The software installed on the image ised in the next section. Listed here is useful information about the im

25、age that may be required during the course of the lab.VMWare image name: Base-Server 2008 R2 SP1 Standard x64Computer name:W2K8xPOC2Windows Administrator username/password: Administrator/rockwellFactoryTalk username/password: Admin/AdminFactoryTalk Metrics administrator username/password: Administra

26、tor/rockwellSQL Server login/password: Administrator (Windows authentication) or FTMUser/FTMUser (SQL Server Authentication)SQL Server database name: FTMetricsSystem DSN name: FTMetricsFactoryTalk Tranion Manager configuration name: FTMetricsLab files location: C:Lab FilesFactoryTalk Metrics Pick an

27、d Choose Lab6 of 88Tools & prerequisitesThis lab uses the currently-shipFactoryTalk Metrics 10.50, which includes Report Expert 3.0. It also uses FactoryTalkVantagePoint EMI 4.5. Products may include patches.This lab utilizes one VMWare image using VMWare Workstation 9.0.0. The following software is

28、 installed on the image:Microsoft Windows Server 2008 R2 SP1 Standard Edition (64-bit) Microsoft Internet Explorer 8.0Microsoft SQL Server 2008 R2 Standard EditionMicrosoft Reporting Services 2008 (included with SQL Server 2008 R2) RSBizWare10.50 software, which includes FactoryTalk Metrics 10.50 Re

29、port Expert 3.0FactoryTalk VantagePoint EMI 4.5 Microsoft Office 2010FactoryTalk Services Platform 2.60.00 (CPR 9 SR6) FactoryTalk View SE version 7.00SoftLogix5800 version 20.01.00RSLogix 5000 version 20.01A configured FactoryTalk Metrics application and database A FactoryTalk View SE project calle

30、d MetricsVAAn RSLogix 5000 program called FTMetrics.acdActivation licenses for appropriate software.7 of 88Getting StartedStarting the VMWare Image at the proper SnapshotThe image used in this lab is also used for other FactoryTalk Metrics labs and contains two snapshots. First we need to confirm th

31、at the image is at the appropriate snapshot for this lab, which is called Start Labs.1.Expose the VMWarebar by moving your mouse to the very top of the screen.2.Click on VM in thebar and select Snapshot and then Snapshot Manager.3.There will be an icon in the Snapshot manager labeled You Aere. Check

32、 the name of the snapshot thatprecedes it and ensure it is called Start Labs. If it is, do nothing and click on.4.If the snapshot is not correct, click on the Start Labs snapshot and then click on the Go To button. Click Yes in the subsequent confirmation dialog box. Your VMWare image will re-boot.U

33、pdating the FTMetrics DatabaseThe FTMetrics database, as included on this image, contains several days of FactoryTalk Metrics data that was collected in the past. We want to take this data and bring it up to the current date, so we can look at data prior to that collected during the lab itself. To d

34、o that, we will run a SQL script in a file called UpdateDatabase that is provided in the Lab Files. This script takes the data in the database in the past and changes the dates to the days immediately prior to the current date. The script is run duringthe lab because the results will be different on

35、 every day.1.Run SQL Server 2008 Management Studio. Start All Programs Microsoft SQL Server 2008 R2 SQL Server Management Studio.Microsoft SQL Server Management Studio will open.Click Connect to connect to the SQL Server instance.8 of 882.Select File Open File.3.Navigate to C:Lab FilesFactoryTalk Me

36、trics Introduction and open UpdateDatabase.sql.Click the Execute button to execute the stored procedure. .9 of 884.When it finishes, there will be messages in the lower window, but there should be no errors (which will be in redtext).Microsoft SQL Server Management StudioThe FTMetrics database now c

37、ontains several days of historical data, ending with yesterday. In the next section we will begin FactoryTalk Metrics data collection, which will collect data for the current time.10 of 88Starting the FactoryTalk View SE ProjectThe image includes a FactoryTalk View SE project and an RSLogix 5000 pro

38、gram running in a SoftLogix controller. This control system serves two purposes:There is a traditional HMI, displaying data in the controller, relaying information about the running operations and providing an interface mechanism for controlling production.It is a simulation of a manufacturing proce

39、ss, generating events for starting/completing manufacturing operations (changeovers, etc.) and for other system events (downtime, blocked, starved, etc.). As such it is the source of data forFactoryTalk Metrics.Before we examine FactoryTalk Metrics reports, you will start production in the simulated

40、 factory by running the FactoryTalkView SE project. Then youll start FactoryTalk Tranion Manager data collection, which will collect production data and eventsfrom the SoftLogix controller and will pass this data to FactoryTalk Metrics, which will record the information in the FTMetrics database.Ope

41、n and Run the FactoryTalk View SE Project1.From the Desktop double-click on MetricsVA.cli, which is a shortcut to the FactoryTalk View SE can select Programs Rockwell Software FactoryTalk View FactoryTalk View Site Edition. Or you. Ifyou choose this option you must choose MetricsVA.cli from the next

42、 screen. If you get a FactoryTalk Security login dialog, enter Admin/Admin as the username/password.11 of 882.You will see an HMI screen that is used for all of the workcells. Click on the L11Filler button at the bottom of the screen to show data for that workcell. The screen for L11Filler is displa

43、yed, showing an overview of the status for the first machine in Line 1. We will come back to this screen and explain it in a moment.12 of 88Start Data CollectionNow that the factory (that is, the FactoryTalk View SE project) is initialized, you can begin collecting data for FactoryTalk Metrics.Tag d

44、ata in the SoftLogix controller and FactoryTalk View SE project is collected by FactoryTalk Tranion Manager, whichpasses that data to FactoryTalk Metrics. To begin the data collection process, you will need to start the FactoryTalk Tran Manager configuration using the Configuration Console, which is

45、 the configuration program for FactoryTalk Metrics.ion1.From the Windows StartConsole.select All Programs Rockwell Software RSBizWare Configuration2.If prompted, login using the default FactoryTalk Metrics administrator User: Admin Password: Admin: Server: localhost (a keyword for the current machin

46、e); you could also use the IP address or name of the computer. Click Login.3.Click theize button () toize the Configuration Console if it is notized aly.13 of 884.Start the FactoryTalk Tranion Manager configuration, which collects data from the simulated factory inFactoryTalk View SE. Select Tools F

47、actoryTalk Tranion Manager Manage FactoryTalk Tranion ionManager Configurations from the. Alternatively, you can click on the Manage FactoryTalk TranManager Configurations link on the main Configuration Console screen.5.Highlight the FTMetrics configuration (stoplight) and click the Start button. It

48、 may take a minute or so to start theFactoryTalk Tran turn green.ion Manager configuration. After FactoryTalk Tranion Manager starts the stoplight will6.Clicktothe FactoryTalk Tranion Manager Configurations dialog box. Data is now beingcollected by FactoryTalk Tranion Manager from the running Factor

49、yTalk View SE project and SoftLogixprogram and is being logged in the FTMetrics database. There is also data in the database that goes back into the past a few days ending with yesterday. There will be a gap between sometime yesterday and the current time where there is no data in the database.14 of

50、 88Production Simulation in FactoryTalk View SE1.Return to the FactoryTalk View SEwindow. Make sure you are seeing the L11Filler screen.2.You are looking at a display that shows the status of one of the 12 work cells in our simulated factory. Unlike some previous simulations that have been used in l

51、abs where the work cells automatically cycled through various simulated modes for downtime, changeover, etc., this simulation is completely manually controlled. If you dont change anything on this screen, it will just continue to simulate producing product in a normal manner. So in order to obtain s

52、ome “interesting” current data for the lab for editing, you will invoke some of the eventsthat are defined here.First we will look at the various parts of the screen.15 of 883.At the bottom of the screen are a set of buttons to navigate to the screens for the other work cells in the simulation. Ther

53、e are two lines defined, and each line contains 6 work cells. Line 1 contains the machines whose names begin with “L1”, and Line 2 contains machines whose names begin with “L2”. FactoryTalk Metrics is collecting data from each of these 12 work cells, as well as composite information at the Line leve

54、l. The work cell names suggest a filling line, but that is just an example. The screens are identical for each work cell, although each screen applies to a different machine.4.At the top of the screen you will see most of the data values collected by FactoryTalk Metrics. They include:Cycle Time (sec

55、) this is the ideal cycle time for this machine to make one unit of production. This can be changed if desired, but it typically does not change unless the Part Id being produced also changes. Ideal Cycle Time is a key component of the OEE calculation.Part counts Total, Good, and Scrap. These are au

56、tomatically incremented by the simulation. Good parts are produced at the rate shown in the “Percentage Good Parts” field, which can be changed. To the right is a button that will reset the part counts. Note: this resets part counts on the HMI screen only. FactoryTalk Metrics will continue to collec

57、t part counts normally if the counters are reset.The list of fields on the right of the screen can be thought of as “Context Fields.” These fields are collected by FactoryTalk Metrics and used for reporting and filtering the resulting data. We will use the Work Order field later in thelab. On the screen, these are-form inp