Home

Expert Tools - User's Guide

1. Specifies the field to search Enter your search criteria If wildcards are to be used the Wildcard match search type must be enabled Only locate records where the case matches If checked each record found during the search is marked At the end of the search all marked records can then be copied to the clipboard or saved to a file Find the search string anywhere in the field Only find fields where a stand alone word matches the search string Only find fields that start with the search string Use this type if wildcards are to be used in the search Multiple character wildcard is and single character wildcard is Wildcards can be combined like Com s which will find Compose Compass but not Composition Note that although the Find dialog stays on top when you switch between the different tables the Find dialog remembers the settings specified for each table This means that the search settings do not have to be re entered when switching between the opened tables The Find settings are only remembered as long as the table is open With the sort function it is possible to sort the records in the table The Sort Table dialog can be opened by selecting the menu item Table Sort Page 21 of 64 AlarmInsight Expert Tools Basic Operations Sort Table x Available fields Fields to sort A Y O a Description Event est Sector ld Tagname Priority 2 P
2. Number of times the parent alarm were found in the record set These fields identify the child candidate The columns shown are equal to the field s selected when setting up the analysis If more fields were selected more columns would be shown here Number of times the child was found within the Max child alarm delay time window Shows when the parent alarm occurs how often the child alarm followed ChildMatch Count Total number of times the child candidate was found in the record Set Shows when the child alarm occurs how often the parent alarm preceded ChildMatch ChildTotal Grid presentation parent details 3BEL303466R0101 Page 49 of 64 Pesulk Parent details Messages Sli ae e essere Tapes osc Poe AlarmInsight Expert Tools Quick Access Functionality By doubleclicking on record in the result view details for the parent child pair will be 12 01 2007 19 05 34 070 _PI24048A Seal vent prnide IP 1 50 bar g Zu a il 12 01 2007 19 05 34 070 PI240514 Seal vent pr de IF 1 50 barg E 1201 2007 19 05 35 1106 FAL24048 Sealvent pr nde lF Alarm 12 01 2007 19 05 35 106 PALZ4051 Seal vent pr de IP Alarm Child 29 01 2007 10 44 25 4352 PI240405 Seal vent pr nde IF 1 50 bar q Parent El 29 01 2007 10 44 27 4265 PAL24046 gt ealventprodelP Alarm El 29 01 2007 104427426 PAL240571 Seal vent pr de IF Alarm Child E 11 02 2007 16 36 35 4322 PI24040505 Seal vent pr nde IF 1 50 barg Fa
3. Ack Filter Critical ack DO Priority field J lt Not Used Time scope 2004 10 37 10 10 00 gt 2004 10 31 25 09 59 Figure 7 12 Unique fields The analysis must pair together records returned from the two selected filters For that purpose one or more reference fields that makes the event unique is needed Many system vendors have a 3BEL303466R0101 Page 43 of 64 AlarmInsight Expert Tools Quick Access Functionality Tagname or Objectname reference that will be sufficient but in some cases additional selections are required Priority A priority field is not needed for the analysis but can be useful information when looking at the analysis result Long response times on warnings might be acceptable while long response times on critical alarms can be a serious problem Data limitation Alarm filter Ack Filter Time scope Specifies the filter that identifies the alarm on conditions Specifies the filter that identifies the operator acknowledgements This shows the actual time scope that will be used for the analysis Refer to section Limiting the analysis period for information on changing the analysis period Pressing the Execute button starts the analysis and the final result will we be presented in a data grid and as a graphical presentation as shown below Grid presentation Events Fesult Chart SS g 1 KRT BDY 1124 00 50 10 2004 10 51 17 46 09 2004
4. Edit Table Opens the SQL Query dialog Opens the SQL Sort dialog Opens the Time View dialog Tools Opens the Database Alias Manager tool a Merge Opens the Table Merge dialog Options Opens the Options dialog Shows miscellaneous information about the current WTS settings Refer to section WTS Information a Mat functionality as explained in section Alarm Management Window Tile Vertical Tiles all open tables vertically Cascade all open tables Minimized main window Quick access to all currently opened tables If a table is minimized it will automatically be maximized Help User s User s Guide Shows this User s Guide in PDF format Registration Opens the registration dialog Shows the credits and the release version 3 2 Opening a table The Open Table dialog can be opened from the menu item Fi e Open or the associated toolbar button Only available if SmartLogger is installed on the same PC Only visible if Expert Tools is the special version for Windows Terminal Services and Citrix Only visible if Expert Tools is unregistered 3BEL303466R0101 Page 8 of 64 AlarmInsight Expert Tools Basic Operations Open Table Database alias Table list filter LOGDATA i TablesMiews Cache data to TEMPDATA alias Single column list Sort descending SIM220r1 0w EDE Initial SOL settings Query field Tagname F ZKSK Advanced 2G Sort field Pricirity bl D
5. PaperSizel 210mm 297mm Status Ready y A query is a powerful tool for extracting useful information from tables It can for example be used to Locate menu item Exclude irrelevant records Find out how often certain items have performed a specific action Find out how many times a specific entry occurs a specific event Table Query The query dialog is used to set up the query definition and can be opened by selecting the Page 16 of 64 AlarmInsight Expert Tools Basic Operations Query Definition Criteria AMC NotUsed PO Reset All Text wildcards 5 ingle char Multiple chars Criteria list 0 Pseudo code T agname EPH 15 1 304 Tagname 4 ES EP 1 304 AND Propertp Count1 00 Tagname 54 1 PUMPA1 23 We Caze sensitive Figure 3 8 Query Definition Criteria One AND criteria is composed by up to 6 field criteria s AND ed AND together This AND criteria can be added to the criteria list Criteria list The criteria list holds a number of AND criteria s that at the time the OR query executes are combined to one SQL statement Criteria If a field is a numeric field a small criteria button will be visible buttons between the field name and the edit box This button can be used to specify a range of numerical values When it is pushed it toggles between lt gt and lt gt Case If checked only text that exactly matches the query criteria is sensiti
6. Priority Show Color ld field in table grid Y Dontuse shared colors Show text in memo fields not just MEMO Color Setup Figure 4 2 Grid Layout Show Toggles the millisecond presentation on off in time fields milliseconds Show grid lines Toggles the table grid lines on off Grid color Color of the grid lines Background color Color of the background behind the records Use alternating If checked every second record in the grid has a different color that can be specified here This option is especially useful when there are no grid lines shown Use Color Id If enabled Expert Tools uses a technique called Color Id mapping mapping See also description below Color Id When Color Id mapping is enabled it must be specified which fieldname field in the table that should be used for Color Id mapping Show Color Id Specifies if the table field used for Color Id mapping should be field Shown in the table grid Don t use shared Normally Expert Tools shares the color definitions with the 3BEL303466R0101 Page 24 of 64 AlarmInsight Expert Tools Maintenance colors SmartLogger application If this option is checked the colors set up in Expert Tools will not affect the SmartLogger and the other way around Show text in Normally the content of memo fields are not shown in the table memo fields grid since the columns then would have to be very wide If this setting is enabled the cont
7. Top 10 Top 20 etc e Alarm frequency calculated per object one object can generate many different alarms e Alarm type frequency position errors feedback error etc e Alarm distribution between process areas In general an analysis will analyze what is seen in the table view This means that any filtering or time scope set for the table view is automatically applied to the analysis This can be one or all of the following e BaseTime SQL set when opening the table view e Time View limitations e SQL Query limitations If either Time View or SQL query settings are changed while the analysis dialog is open this change will automatically be applied to the analysis when it is run the next time 7 1 1 Evaluating the analysis result The analysis result view has up to four different views tab sheets Events Result Chart Messages Ba lt lt gt li dey e Alarm Rate analysis for 12320041015 2004 10 15 00 00 00 gt End of table es a ee es ee ee ee es ee ee HA A A res ea A Ni A ka De ge oes ade na oes A A Ne aes a o il A a laon Ll o J Llb 2 A Alarm Count E A A p IE ee ee 00 0001 30 03 10 04 50 06 30 08 10 09 50 11 30 13 10 14 50 16 30 18 10 19 50 21 30 23 10 Chart period 1 day from 2004 10 15 Page 1 1 Figure 7 1 3BEL303466R0101 Page 37 of 64 7 2 AlarmInsight Expert Tools Quick Access Functionality e Events view Shows the ev
8. 10 31 10 36 19 0 a 2 KRT BDY 1124 00 41 24 2004 10 31 16 01 25 2004 10 31 16 42 49 1 E a KVWS KCW S3055 00 38 30 2004 10 31 14 33 10 2004 10 31 15 11 40 4 M 4 KRT BDY 1124 0 OO 33 29 2004 10 51 18 40 05 2004 10 31 19 13 37 0 Al 2 KRT EsCiw 05943 00 12 14 2004 10 51 11 08 06 2004 10 31 11 20 20 1 E BRA SOS 00 06 57 2004 10 31 11 31 35 2004 10 51 11 40 32 a p T KRT ESDY 85945 00 07 25 2004 10 31 10 18 12 2004 10 31 10 25 37 0 T A KVWS KOW S 3055 00 06 54 2004 10 31 13 10 16 2004 10 31 13 17 10 o 9 KRT EsC w 05943 00 06 27 2004 10 31 11 23 22 2004 10 31 11 29 49 1 Figure 7 13 3BEL303466R0101 Column descriptions Id Sequential number lt TAGNAME gt This field is equal to the field s selected when setting up the analysis If more fields were selected more columns would be shown here Response Time between alarm time and acknowledgement time Time Alarm Time Time when the alarm occurred If empty no corresponding alarm was found Acknowledged Time when the alarm was acknowledged If empty no corresponding acknowledge event was found Shows how many times the alarm was repeated before it was acknowledged Repeated Each row in the grid represents an alarm with a corresponding acknowledgement action Page 44 of 64 AlarmInsight Expert Tools Quick Access Functionality 7 6 Reaction Time analysis For transmitters and controlling loops the time from a H1 alarm to a H2 alarm can be described as the Operator
9. 4 Graphical presentation Events Result Chart Messages gt 8 lt lt gt gt EM a i Alarm Rate analysis for UG Data 2006 03 01 00 00 00 gt End of table Alarm Count 00 00 0200 0400 0e 00 08 00 10 00 12500 14 00 16 00 18 00 20 00 22400 00 00 Chart period 1 day from 2006 03 01 Page 1 31 Fixed y axis Setta lia Figure 7 5 3BEL303466R0101 Page 39 of 64 7 3 AlarmInsight Expert Tools Quick Access Functionality The graphical presentation shows the alarm rate compared to the recommended EEMUA rate which is shown as a thin red line y According to EEMUA publication 191 the recommended average alarm rate during normal conditions should not exceed 1 alarm per 10 minutes Alarm Priority Distribution analysis The alarm priority distribution analysis is used to benchmark or verify the alarm distribution for the available priority levels EEMUA recommend a 80 15 5 distribution which means that the alarm distribution should be about 80 warnings 15 alarms and 5 critical alarms As for the other analysis types this analysis can be used for other purposes as well depending on the initial set up This could be e Alarm distribution between plant sections e Alarm distribution within specific modules or type circuits by filtering on module and analysing on alarm type The following shows a typical set up for an alarm priority distribution analysis gt Z Analysis set
10. Reaction Time I e the time from a pre warning before a more serious alarm occur It is important that the H1 alarm comes in time so that the operator has the necessary time to perform relevant corrections and preventive actions The recommended minimum reaction time varies from process to process and from loop to loop For generic analyses it would typically be in the area from 2 to 5 minutes The AM Reaction Time analysis can be used to evaluate the reaction times and help to locate e Tags with identical set points e Tags with high rate of too short reaction times e Tags with scattering alarms in H2 mode In the following figure the Operator Reaction time is shown as delta t at At In order to execute the Reaction Time analysis a pre warning filter and an Alarm Trip filter must be defined eS 78 Analysis settings Data limitation Unique field s MES ws S Fre warning Filter le warnings G g lt Not Used Y Alarm Trip Filter H2 Alarms y Ole Extra field lt Not Lised gt Time scope 2004 10 15 00 00 00 gt End of table Figure 7 14 Analysis settings Unique The analysis must pair together records returned from the two selected fields filters For that purpose one or more reference fields that makes the event unique is needed Many system vendors have a Tagname or Objectname reference that will be sufficient but in some cases additional selections are required Extra field T
11. an Analyze Time result file can be re opened The same actions can be performed with this old analysis as with an analysis just executed The result table can also be opened and viewed like any other table The result table will like other SmartLogger tables contain a LogDate field For all entries in the result table the LogDate field will contain the Date Time when the analysis was started 3BEL303466R0101 Page 58 of 64 AlarmInsight Expert Tools Alarm Management 8 CONCURRENT USER MODE WTS Expert Tools can be installed a single user version and in a concurrent user version The concurrent user version is often refered as Windows Terminal Service WTS mode and require a Windows Server with Terminal Services or Citrix enabled If the Concurrent User version is installed a number of supporting tools are installed as well WTSAdmin exe Tool for configuring default settings and license registration WTSLicense exe License provider service that will grant licenses to users in accordance with the selected license file 8 1 WTSAdmin configuration tool When running in Concurrent User mode there is a number of settings and options that is managed by an administrator These settings are e License registration e Database connections alias s e Default settings for new users e Locked settings settings that cannot be changed by users Figure 8 1 shows the main view of the WTS Administrator program ll SmartCli
12. number of records to max 30000 using queries and or Time View before the LoadAllRecords mode is activated 9 2 Desktop versus Server databases This section describes some important differences between the two types of databases 9 2 1 Desktop databases Paradox Desktop databases do not have a real SQL engine supplying remote clients with data matching specific SQL queries The client therefore has to retrieve all records from the remote Desktop database and then parse the records locally This means that all records are transferred over the network from the database to the client even though maybe only 1 record matches the query For Desktop databases the network speed is crucial to how fast a query executes Desktop database restrictions It is recommended that tables are kept relatively small e less than 150 000 entries This ensures reasonably performance for the Expert Tools when executing sorting and querying operations 3BEL303466R0101 Page 63 of 64 AlarmInsight Expert Tools Appendix For speed considerations it is also recommended to enable incremental fetching refer to section Database 9 2 2 Server databases Oracle or MS SQL Server Server databases contain a real SQL engine which enables them to process SQL queries locally and then only send the query result set to the client For Server databases the network speed will be of less importance since it is possible for the client to limit the
13. of 64 Ve ae AlarmInsight Expert Tools Utilities The table list is never cached This will increase network traffic as the table list is fetched directly from the database server every time it is requested The table list is cached the number of minutes specified 5 3 2 Standard alias operations Create an alias The following describes the procedure for creating a new standard alias Press the New button Type in the name for the new alias Set driver type to STANDARD Select the database path using the controls browse button Save the alias Modify an alias To modify an alias select the desired alias and change the settings applicable to that driver type To store the changes press the save button If the settings are disabled it is because the alias is currently in use and can therefore not be modified This can also be verified by looking above the database alias where a red text with Active appears If the database driver has to be changed you will have to create a new alias and delete the old one Delete an alias To delete an alias select the alias and press the delete button If the delete button is disabled it is because the alias is in use and can therefore not be deleted W Aliases that are currently in use cannot be modified or deleted 5 3 3 Remote aliases It is possible to let aliases point to locations on other computers in a network and thereby accessing databases located on rem
14. of records fetched from the table when it is initially opened When BaseTime SQL is not applied all records are fetched from the table when it is opened When BaseTime SQL is applied only records that fall within the specified time scope are fetched from the table Any further data manipulation like queries and analysis will only be performed on these records 3 2 3 Filter The filter is used to reduce the number of tables shown in the table list When working with Oracle tables the filter has an extra feature If the filter control is cleared and the Refresh button is pressed then all tables available to the current user will be shown not just the tables owned by the current user Tables owned by other users will be shown as lt user name gt lt table name gt in the table list and can be opened like any other SmartLogger table Filter example A filter with the value ESD will list the tables ESD_PROD19990200 and ESD19981100 A 3 2 4 Advanced Options For server based databases it is possible to be more specific about which tables that Should be listed in the table list 3BEL303466R0101 Page 10 of 64 AlarmInsight Expert Tools Basic Operations Depending on the chosen list type tables belonging to the listed users will be included or excluded Figure 3 2 Advanced Options Shown in the table list Mw Tables views owned by current user only i Tables Views Short table names Filter tables views owned by these
15. refresh function Table area Status bar 1 1 Conventions and definitions W Important note Alias Database alias specifying database parameters like path and database driver AM Alarm Management BDE Borland Database Engine A set of DLLs and support files that allow programs to access databases Control The term control is used when describing the user interface A control is a common name for edit boxes push buttons and other items on a dialog 3BEL303466R0101 Page 5 of 64 Introduction Dataset Dialog Event Field MDI PDF Record SQL WTS 3BEL303466R0101 A collection of records fetched from the database server or the local database A dialog is a window designed for user input A common name used in the process industry for an occurrence which is reported to an operator and or a printer An event in the SmartLogger terminology means a sequence of characters normally sent to the printer followed by a carriage return A field corresponds to a column in a database table Multiple Documents Interface Adobe Portable Document Format This is the format used for the online User s Guide A record is one row of data one event in a database table Structured Query Language Standard language for accessing databases Windows Terminal Services Used in connection with the Expert Tools version supporting WTS and Citrix servers Page 6 of 64 2 2 1 2 2 AlarmInsight Expert Tools Instal
16. time scope Stop Date Time Specifies the stop date and stop time of the desired time scope Please note that under certain circumstances Expert Tools may force a date time format different from the Windows settings as shown in the table below Windows setting Expert Tools forced format 12 hour clock AM PM 24 hour clock 2 digit year 00 99 4 digit year Space as time separator Space as date separator as date separator The Time View can be enabled disabled from the on off tool button located next to the table navigator on the toolbar in the main window Find Record In addition to the query function there is a faster way to locate a specific field value The Find Record function can locate information found in any one of the table fields It supports search facilities like Starts with Whole word only Substring case sensitivity and wildcards The Find Record dialog can be opened by selecting the menu item Edit Find 3BEL303466R0101 Page 20 of 64 3 8 3BEL303466R0101 Figure 3 14 Find Record Search field Find what Match case Keep selections Substring Whole word Starts with Wildcard match SQL Sort AlarmInsight Expert Tools Basic Operations Find Record 1C5_DEMO x Search type f Substring f Whole word searcn held Tagname Find what E Starts with Match case Keep selections End Hest Wildeard match 7 and 4 x Cancel
17. users Filter type C Include Exclude Username Add Excluded users sys SYSTEM Delete MOS y s CTSS INFORMATION SCHEMA dbo y Ok x Cancel Advanced Options Tables views owned Tables Views Short table names Filter tables views 3 3 Save View As If checked only the tables owned by the user currently logged in is shown Otherwise all tables available to the current user is shown in the form lt Table owner gt lt Table name gt If checked available tables are shown If checked available table views are shown If checked only the string after the last in the full table name is Shown I e if a table is called MYUSER SYSTEM VALVESTAT only the name VALVESTAT is shown in the table list Include Only tables and views owned by the specified users will be shown in the table list Exclude All tables and views owned by the specified users will not be shown in the table list The Save View As dialog can be opened from the menu item File Save View As or from the associated toolbar button 3BEL303466R0101 Page 11 of 64 3 4 AlarmInsight Expert Tools Basic Operations Table Save As Paradox only E Database allas Table name JUGDEMO y NEWTABLE Currenttables Figure 3 3 Database alias Specifies the destination database alias Note that only Paradox aliases are listed here Table name Specifies the name of the new table Current tables Co
18. 0 00 00 00 00 00 00 00 00 0 0 Possible identical setpoints H 23 F ZT 3530506 00 02 00 1 100 00 00 00 00 00 00 00 00 00 0 0 Possible identical setpoints El 23BPT30025 00 02 00 1 100 00 00 00 00 00 00 00 00 00 0 0 Possible identical setpoints 23 BLT35349 00 02 00 19 89 47 00 00 00 00 01 07 00 11 36 25 1 89 is below recommended reaction time Figure 7 16 The summation tab summarizes all alarm pairs for each individual tagname Only completed alarm pairs where both a pre warning and an alarm trip event were found are included in the calculation lt TAGNAME gt This field is equal to the field s selected when setting up the analysis If more fields were selected more columns would be Shown here Recommended Shows the Recommended minimum reaction time used for this analysis The value can be changed from the analysis options dialog refer to section AM Options Count Number of alarms pairs found for this tag Below Number of alarm pairs in percentage where the reaction time was below the recommended minimum time Minimum The minimum reaction time found Average The average reaction time for all alarm pairs Maximum The maximum reaction time found W repeats The total number of pre warnings found A low W Repeats Count ratio indicates improper alarm set points A repeats Number of alarms in Alarm Trip mode repeating H2 alarms A high A repeats Count ratio indicates scattering alarm in Alarm Trip mode Comment Sup
19. 0 23F TE 353511 00 28 20 O 23 03 2006 10 44 35 25 05 2006 19 12 55 30 23 F TE 35351 1 00 22 43 0 03 03 2006 01 52 12 03 03 2006 02 15 01 E 205 2392413400 00 19 02 O 23 03 2006 12 56 19 23 03 2006 13 17 22 E 204 23BPT3016 2 00 12 10 3 23 03 2006 12 52 10 23 03 2006 13 04 21 p 400 23 BLT35349 00 11 36 1 31 03 2006 13 16 19 31 03 2006 13 27 55 p 193 58 4130197 00 11 00 O 23 03 2006 10 47 53 23 03 2006 10 50 55 p 234 23BFPT30162 00 10 56 O 23 03 2006 16 33 51 23 03 2006 16 44 49 p 220 25 B_Al30197 00 09 00 1 23 03 2006 15 25 46 23 03 2006 15 37 46 E 12 236 4130197 00 08 59 1 01 03 2006 13 20 29 07 05 2006 13 37 28 F 166 23 F LIT 351501 00 08 54 1 19 03 2006 14 32 41 19 03 2006 14 41 35 p 24 235_AT38197 00 07 00 3 02 03 2006 11 10 56 02 03 2006 11 17 56 Figure 7 15 Column descriptions Id Sequential number lt TAGNAME gt This field is equal to the field s selected when setting up the analysis If more fields were selected more columns would be shown here Reaction Time between pre warning time and trip alarm time If more pre Time warnings were found time is calculated from the latest pre warning Repeats Number of pre warnings occurred before alarm trip occurred TS Time when the pre warning occurred If empty no corresponding pre PreWarning warning was found TS Alarm Time when the alarm trip occurred If empty no corresponding alarm was found Grid presentation summation 3BEL303466R0101 Page 46 of 64 AlarmInsig
20. 0101 Page 62 of 64 AlarmInsight Expert Tools Appendix 9 APPENDIX 9 1 Grid modes The table grid works in two different modes dependent of the operation chosen by the user The different modes are described in this section 9 1 1 Normal Mode This is the default mode of the grid when a table is initially opened Only the records visible in the grid are loaded into memory When scrolling through the table the records that become out of sight are removed from memory and new ones are loaded 9 1 2 LoadAllRecords Mode Some of the more advanced features like Print Grouping Mode and Quick Sorting Mode require that all records in the current dataset are loaded into memory When needed Expert Tools automatically shifts to this LoadAllRecords mode LoadAllRecords mode overrides the use of incremental fetch which means that all records matching the current query or Time View settings will be fetched As this mode is slower than the normal grid mode it is only activated when required by one of the features mentioned above When Expert Tools activates this mode the message shown in Figure 9 1 will be displayed while the records are being loaded Activating Load llRecords mode Please wait Els El Figure 9 1 Expert Tools will stay in LoadAllRecords mode until a table is refreshed or a new dataset is fetched with for example SQL Query or SQL Sort Due to the loading time it is highly recommended to limit the
21. 101 When this option is checked the first line in the copy will contain the field names Some functionality requires the grid to be in LoadAllRecords mode refer to section LoadAllRecords Mode Switching to this mode may take a while if the dataset contains many records If the number of records exceeds the limit specified here the user is given a warning When incremental fetching is enabled the total number of records in the dataset is unknown If this option is enabled a warning is issued when LoadAllRecords mode is about to be activated This is to inform the user that a lot of records might be loaded if the user continues When enabled all table windows are maximized when opened If checked there will be an extra button on the toolbar in the table windows This is used for detailed information about the current table and the SQL statements used to get data Page 27 of 64 AlarmInsight Expert Tools Utilities 5 UTILITIES 5 1 Table Export The export utility makes it possible to export an entire table or part of it to another format than a database table Expert Tools supports four different formats as explained in the following y The export utility operates on current the table view e only records matching the active query sort and time view settings are exported 5 1 1 Text Export From the export dialog the text format can be customised to match any user requirements The Text Export dia
22. 1234 Stopped X Cancel Figure 7 28 e Specify the object name Export Pump e Select which one of the records that should be used as the ON criteria in this case the one already selected e Press OK It is possible to add an unlimited number of objects to an analysis as long as they all use the same fields I e it is not allowed to have one object using the fields Tagname and EventTexti and another using the fields Tagname and EventText2 W The ON OFF criteria s are case sensitive i e an event containing EventTexti Running is not considered the same as EventTexti running 7 9 2 Running an analysis When all objects are defined the template can be saved and the analysis can be executed During execution of the analysis an Execution Status dialog as shown in Figure 7 29 will be presented From this dialog the progress of the analysis can be monitored and the analysis can be stopped at any time by clicking the Stop button The Close button shown in Figure 7 29 will change to a Stop button during the analysis Analyze Time Results for Aniz TimeUsg Object list AS O a eS Export Pump 1 00 00 03 00 00 03 00 00 03 00 00 03 Main Export Valve 0 00 00 00 00 00 00 00 00 00 00 00 00 S Print th Preview I view On Off y EETA Template 4nlz Timellsc l Analysis started at 2000 01 01 21 10 25 Ss Print source Alias UGDEMO source Table ANLZTIME Analyzing object Expor
23. 15 2004 10 15 00 00 00 gt End of table Heo a es eae AL GLA Ne Uae Alana Total 3070 Different 336 Top 10 30 Top 20 50 Top 50 65 a a Sa A A Sal lt Click on barto see field values gt Page 1 12 Figure 7 11 The graphical presentation shows the chosen Top XX alarms The number of bars to be shown per page can be selected from the drop down control on the toolbar Clicking on a bar will show the object the bar represents The textbox to the right shows a number of benchmark figures Total The total number of alarms found in the data source Different Number of different alarms found Top 10 Alarm load in percent from top 10 alarms Top 20 Alarm load in percent from top 20 alarms Top 50 Alarm load in percent from top 50 alarms Operator Response Time ORT analysis The operator response time is defined as the time from an alarm arises until the operator performs an acknowledgement The Operator Response Time analysis measures the response times for all alarms over a certain period of time If there are many situations where the operator has too long response times this indicates a potential alarm management problem In order to execute the ORT analysis an alarm filter and an acknowledgement filter must be defined Operator Response Time analysis for 4M_Samples P O er Analysis settings Data limitation Unique field s TAGNAME Alarm Filter Critical alams 7 Gi 7 lt Not Used gt
24. 27 05 2011 14 09 04 651 B 27 10 2010 42 E 27 05 2011 14 09 06 651 27 10 2010 1 E 27 05 2011 14 09 08 650 a 27 05 2011 14 09 10 650 A Ez 05 2011 14 08 12 1650 BCCne 4 KRT ESD 85945 0 Shutdown Fuel Gas OAM PUMP 24576 R Mezz Oil Pump HSA SOS WWUL P 6002 KRT BD 11 24 OAM PUMP 245 76 KRT BDY 1124 0 OPS PUMP 2356 R KRT ESD 85943 KRT BDY 11 24 0 HSA 53095 OPS PUMP 236 F PLI LSL 34567 KRT ESD 85943 0 KRT ESDYW 85943 KRT BD 1124 Prod Drain valve Centrifuge Pump Turbine Blowdown Mezz Oil Pump Turbine Blow doyn West Water Pump Shutdown Fuel Gas Turbine Blowdown Prod Drain Valve West Water Pump Drain Tank Shutdown Fuel Gas Shutdown Fuel Gas Turbine Blow don 2 gt Opening 12 Run 2 Open 16 Running 2 Opening 12 Running 2 Open 12 Run 2 Open 2 Closing 2 Closed 12 Failure T Alarm 2 Closing 2 Closed 2 Closed B04 Valve 986 Pump 944 Valve 412 Pump 203 Valve 556 Pump T34 Valve 286 Pump 561 Valve 761 Valve 44 Valve 800 Pump 132 643 Valve 579 Valve 513 Valve we Fetched 4031 Records OOOO OO LU g Figure 1 1 Please refer to section Menu overview for an overview of the menu layout Toolbuttons for fast access to the most common functions Menu Application Toolbar Child Toolbar Table navigator for moving around the active table and On Off buttons for the Query Sort and Time View functions View area for open tables Shows the status for the auto
25. 31 30 2 Standard allas 0 Pei Ul ONS AAA 33 S3 REMOS alas ES a AAA AE ines 33 6 QUICK ACCESS FUNCIONA Mati a is 34 GT CODY to clUPbDOadurdd ad 34 6 2 Held Customisation Panel uri a 34 6 3 Export Selected Al Records ita it 34 6 4 Prnt Preview Selected Alicia aia 35 672 lt GFOUDING MOGG a A A 35 6 60 QUICK O FUN Modistas 35 67 QUICKEN asc a ei 36 Z Alarm ManaGement vivescansicecidntscsscennccascenscocscccscvassavcasassevinvesconssuacvecsesescautavesvanteces 37 7 1 Before using the alarm management analySiS cece eect cece eeeeeeee eee eeeeeeeeenegs 37 3BEL303466R0101 Page 3 of 64 Z1 Evaluating the analysis FesUlltiucisainaddii ea a aa a aai 37 A2 Alam Rate analys S ai asa 38 Lao Alarm Prority DISUHOULION analysis pa 40 TB Alar Frequency ANAIVSIS ui A SA 41 7 5 Operator Response Time ORT anNalySiS ccccccccccccccccnnnnnncnnnnnnnnnn nn 43 Ab Reaction TINE analy SIS da 45 LaS PAFents CHANG LANAIVS S a 48 FeO COMMON AM CGO INS ers ts td ds 50 Tot EMNE TAC ANALYSIS Pero arca 50 7 02 Limiting The aN alVSIS Gata ini A AAA Aa 50 o AM ODUONS orara ee re eee ee ee ea ere eee eee 51 RIE POV Ze Tio ra 53 A91 DESIGNING an ANGIVSIS ssctcndsiatiaunsiatteuisietteatsdai bea eed tewtncalinansdetiantabetfeeesgatiantens 54 FOZ RODANO AVAL YSIS aa adas 56 135 EXPORINO resultan 58 7 94 Loading an analysis FesUlE cis 58 3 Concurrent User mode WES imss 59 8 1 WISAdmi contiguration LOO iuris AA is 59 Oiled ME
26. 4 5 Export directories Text export Default destination directory for Text exports MS Excel export Default destination directory for MS Excel exports HTML export Default destination directory for HTML exports XML export Default destination directory for XML exports 4 1 5 Miscellaneous Options Database Grid layout Export directories Miscellaneous Table refresh Enable automatic refresh NA W Goto last record after refresh Other Include field names in copy to clipboard Load llRecords records warning limit 20000 E We Always show Load llRecorde warning when incremental fetch iz enabled Always open table in maximized window M Show button for detailed SQL and database information Figure 4 6 Miscellaneous Table refresh Automatic refresh When enabled all tables currently opened will be automatically Refresh int refreshed using the interval specified in Refresh interval 3BEL303466R0101 Page 26 of 64 Go to last AlarmInsight Expert Tools Maintenance If checked the table cursor is moved to the last record after a refresh manual or automatic has been executed This operation Should be used carefully when viewing large tables as it may take some time to perform Miscellaneous Other Include field names LoadAllRecords records warning Always show LoadAllRecords Always open table Show button for 3BEL303466R0
27. Alarminsight Release 3 0 Expert Tools Version 4 0 Users Guide NOTICE The information in this document is subject to change without notice and should not be construed as a commitment by ABB ABB assumes no responsibility for any errors that may appear in this document In no event shall ABB be liable for direct indirect special incidental or consequential damages of any nature or kind arising from the use of this document nor shall ABB be liable for incidental or consequential damages arising from use of any software or hardware described in this document This document and parts thereof must not be reproduced or copied without written permission from ABB and the contents thereof must not be imparted to a third party nor used for any unauthorized purpose The software or hardware described in this document is furnished under a license and may be used copied or disclosed only in accordance with the terms of such license Copyright 2013 ABB AS All rights reserved AlarmInsight Release 3 0 Expert Tools Release 4 0 Document number 3BEL303466R0101 Last updated January 2013 TRADEMARKS Registrations and trademarks used in this document include Windows Registered trademark of Microsoft Corporation Microsoft Registered trademark of Microsoft Corporation Visual Studio Registered trademark of Microsoft Corporation NET Registered trademark of Microsoft Corporation Acrobat Reader Registered trademark of Adobe S
28. Bren Acai E mn pipans a y SRA PORA 30 12 2004 23 56 27 PRES n 30 12 2004 23 57 27 bla 30 12 2004 23 58 27 PropCikount E 30 12 2004 23 59 27 E 31 12 2004 00 00 07 ESA BURT 31 12 2004 00 01 27 LogDate v 500 Records A Figure 6 1 The Field Customisation Panel can be used to hide show or rearrange the fields in the grid This is especially useful when irrelevant fields should be excluded from a printed report The panel can also be used for specifying the DateTime field used for misc time operations as explained in section Supported tables This is relevant when a table contains more than one DateTime field W Fields can be dragged and dropped from the table grid to the panel and the other way around 6 3 Export Selected All Records This feature is basically the same as the Table Export feature described in section 5 1 except that e Only the selected records are exported if Export selected is chosen e TAB characters are always used as field separators for the Text export e To select more than one record do one of the following e Press and hold down the SHIFT key while pressing the up down key e Press and hold down the CTRL key while selecting records with the mouse 3BEL303466R0101 Page 34 of 64 6 4 6 5 AlarmInsight Expert Tools Quick Access Functionality e Select a record with the mouse hold down the SHIFT key and select another record All records in between t
29. NUVOVE VI o 59 Sekt NEO KCC SSUES a 60 S License Provido it is 60 22 WES MOMA O Nere a E a a 61 9 ADPONO Dr Aa 63 SEE Grd MOS aos 63 Ott Nermal ON 63 S242 HOaGAIIRCCOFUS Mode ia 63 9 2 Desktop versus Server databaseS cccccccccnorcccccnconncaaannnnnn rre rr n rr rra rra rra 63 9 2 1 Desktop databases Paradox ccccccocccccccnnnnnnrocncnn rra rr rr rr 63 9 2 2 Server databases Oracle or MS SQL Serve cccccccsecueeeueeesseuseeueeetseuueuneesneeags 64 3BEL303466R0101 Page 4 of 64 AlarmInsight Expert Tools Introduction 1 INTRODUCTION AlarmInsight Expert Tools x File Edit Table Tools Alarm Management Window Help Hm Sa BA 20210 m LOGDATA SIM2010WE43 Ajat lt gt a Blr HCH Er ES No query activer na 2r 10 2010 12 an a F ALERT KRT ESD 55943 O Shutdown Fuel Gaz 2 Onenini sn Valve 01 x 27 10 2010 1 E x 27 10 2010 1 gt TAE lt ES gt a a i H C E REE 27 10 2010 4 Boano E 153 E 27 10 2010 1 E 27 05 2011 14 08 42 5653 B 27 10 2010 4 E 27 05 2011 14 08 44 653 g 27 10 2010 1 E 27 05 2011 14 08 46 653 27 10 2010 1 E 27 05 2011 1405 48 652 27 10 2010 1 E 27 05 2011 14 08 50 6523 E 37140 201013 E 27 05 2011 14 08 52 652 B 27 10 2010 17 E 27 05 2011 14 08 54 652 27 10 2010 1 27 05 2011 14 08 56 652 27 10 2010 1 F 27 05 2011 14 08 58 651 27 10 2010 1 27 05 2011 14 09 00 6 51 27 10 2010 1 a 27 05 2011 14 09 02 651 27 10 2010 11
30. Specifies the filter to be used on the data sources If no filter is selected the complete data source is analyzed Refer to section Limiting the analysis data for creating or modifying filters Time scope This shows the actual time scope that will be used for the analysis Refer to section Limiting the analysis period for information on changing the analysis period Pressing the Execute button starts the analysis and the final result will we be presented in a data grid and as a graphical presentation as shown below Grid presentation 3BEL303466R0101 Page 38 of 64 AlarmInsight Expert Tools Quick Access Functionality Events Result Chan Messages hm wt PercaFrom ____ AlamCount 15 10 2004 15 10 2004 00 10 00 15 10 2004 00 20 00 15 10 2004 00 30 00 15 10 2004 00 40 00 15 10 2004 00 50 00 15 10 2004 01 00 00 15 10 2004 01 10 00 15 10 2004 01 20 00 15 10 2004 01 30 00 D M moo oo QU Bl Figure 7 3 Each record in the data grid represents the alarm count for one resolution period KPI summary When selecting the KPI tab different alarm KPI will be shown Result KPI Chart Messages By 3D mar 16 02 2007 144 1 day 2 5 10 minutes 2 25 01 17 02 2007 144 1 day 174 15 1 2 10 minutes 2 14 6 18 02 2007 144 1 day 428 57 3 0 10 minutes 2 27 8 19 02 2007 144 1 day 561 49 3 9 10 minutes 2 51 4 20 02 2007 144 1 day 455 23 3 2 10 minutes Z 43 8 Figure 7
31. Unique fields Determines the fields to be analyzed Data limitation Alarm filter Specifies the filter to be used on the data sources If no filter is selected the complete data source is analyzed Refer to section Limiting the analysis data for creating or modifying filters Time scope This shows the actual time scope that will be used for the analysis Refer to section Limiting the analysis period for information on changing the analysis period Pressing the Execute button starts the analysis and the final result will we be presented in a data grid and as a graphical presentation as shown below Grid presentation Result Chart Messages Moa a Ba Recld_ Tagname Count Percentage B 2 P0020 173 5 4 E 3 AL20091 173 5 64 E 4 slri 145 4 02 E 5 FIT4127b 102 3 32 E 6 147041 g7 5 16 E FL LIC10004 al 2 64 E a FIT105045 fa 2 41 E 4 al42716 FO 2 20 E 10 14 207 ED 1 95 E 11 PIT141213 40 1 56 Figure 7 10 Each row in the result grid represents one unique alarm or alarm type depending on the analysis settings For each row the total number of occurrences count and the percentage load from this item is shown The percentage load is calculated as Count divided by Total alarms 100 Graphical presentation 3BEL303466R0101 Page 42 of 64 7 5 AlarmInsight Expert Tools Quick Access Functionality Result Chart Messages 8 6 i gt Frequency analysis for 125 200410
32. X General Analysis Frequency Default presentation interval Default graph onentation Vertical ll Alarm rate Recommended alarm rate alarms 10 min 2 Default resolution fio minutes Operator response time I F multiple alarms calculate time from first alarm Recommended maximum response time 00 02 00 T 1 Reaction time i F multiple pre warnings calculate time from last pre warning Recommended minimum reaction tine 00 02 00 Parent Child Default maximum alarm delay sec 2 Default child predictability miniran a Default child significance minimum a Default parent count minimum X Cancel Figure 7 25 Frequency amp Alarm rate Default Default selections used when the corresponding analysis is opened Operator Response Time If multiple Should normally be checked alarms Recommended For future use maximum Reaction Time If multiple pre Determines which pre warning to use in case of multiple pre warnings warnings Should normally be checked Recommended Used for alarm summation calculations Alarm pairs with reaction minimum times less than recommended minimum reaction time are included in the Below value Refer to section Reaction Time analysis for more details Parent Child Default Default selections used when the corresponding analysis is opened 7 9 Analyze Time Analyze Time is a tool for calc
33. ability greater than selected value Filters the output list to records having significance greater than selected value Filters the output list to records having minimum the selected number of parent alarm occurrences Pressing the Execute button starts the analysis and the final result will we be presented in a data as shown below The Parent Child analysis might take long time 1 60 minutes to process Y depending on the number of records to process Increasing the Max child alarm delay will also increase the analysing time significantly Grid presentation child candidate Result Parent details Messages By Bow ah Parent alarm Child candidate 15 EMU303014 18 FIT40410 ia 20 FI vvO0106 Figure 7 19 GEN A Weather De On Flow ProdvvtrBoopmp 110 00 rm3 h ellbay ESDY Platim 10 00 3 PBU30301_RES a Inh No Reset Alarm 100 0 100 0 11 FIC40410 Piy Min flow ctrl 110 00 m3 h 11 100 0 13 84 6 4 FIW00106 Wellbay Area ESDV On 4 100 0 5 80 0 Column descriptions Recld Parent lt Tagname gt lt Descrip gt lt Prop Text gt Count Child lt Tagname gt lt Descrip gt lt Prop Text gt Child Match Predictablility Child Total Significance Sequential number These fields identify the parent alarm The columns shown are equal to the field s selected when setting up the analysis If more fields were selected more columns would be Shown here
34. able list is never cached This will increase network traffic as the table list is fetched directly from the database server every time it is requested The table list is cached the number of minutes specified MS SQL Server 2005 MSSQL driver MS SOL Server SOL Server name Table list cache time min flocsnv01 i Default username nancy M AutoCommit enabled Database name SMARTLOG Figure 5 6 SQL Server The registered name of the SQL Server where the database is name running Using the MS SQL Server Enterprise Manager this registration can be performed Default user The default user name that is used if automatic database login is name disabled Database name The name of the database containing the SmartLogger tables Table open list Defines how long the table list is cached in memory A new table list cache time is not fetched from the database server before the cache time expires AutoCommit If enabled the BDE automatically commit records to the table after enabled each post If disabled the application decides when to commit the records Please note that this setting is only relevant for applications that actually write to the database like SmartLogger or SmartTranslator Possible cache time values 1 The table list is cached as long as the program is running This should only be used for static databases where no tables are added after the program is started 3BEL303466R0101 Page 32
35. arent Child analysis su al Alarm Filter lt No Filter Ol Childs predictability minimum 80 Description E Time scope 2006 10 01 00 00 07 gt End of table Childs significance minimum 80 JE ventText 5 Parent count minimum Refresh Result Grid air Max child alarm delay sec PropertyT ent e Ignore duplicate alarms a 1 e Figure 7 18 Analysis settings Unique fields Determines the fields that in combination makes the alarm record unique Data limitation Alarm filter Specifies the filter to be used on the data sources If no filter is selected the complete data source is analyzed Refer to section Limiting the analysis data for creating or modifying filters Time scope This shows the actual time scope that will be used for the analysis Refer to section Limiting the analysis period for information on changing the analysis period Max child Determines the time windows where an alarm is treated as a child alarm delay alarm Increasing this parameter to 60 or 120 seconds will 3BEL303466R0101 Page 48 of 64 Ignore duplic alarms Data output Childs predict minimum Childs signif minimum Parent count minimum AlarmInsight Expert Tools Quick Access Functionality increase the analysing time significantly If checked then multiple child alarms within the Max child alarm delay will be ignored Filters the output list to records having predict
36. ars to the right of the text in the field header as shown in Figure 6 3 3BEL303466R0101 Page 35 of 64 AlarmInsight Expert Tools Quick Access Functionality a E 1997 07 01 23 56 59 052 EXLOG1 LOW LEVEL SLUG CA Off a 1997 07 01 235715048 EWYLOG LOW LEVEL SLUG CA Off E 1997 07 01 23 57 35 029 EVLOGI L LEVEL SLUG CA Off Ree 1997 07 01 23 57 55 023 EVLOGI LOW LEVEL SLUG CA Off O a 1997 07 01 23 50 08 040 EWLOG2 COMPRESSOR ALARM 1997 07 01 23 49 23 008 EVLOG2 COMPRESSOR ALARM 1997 07 01 23 486 38 062 EVLOG2 COMPRESSOR ALARM 1997 07 01 23 493 05 066 EWLOGZ COMPRESSOR ALARM Fetched 199 Records Query Active me Figure 6 3 To sort by more than one field hold down the lt SHIFT gt button on the keyboard and click on additional field headers with the mouse To remove the sorting of a field hold down the lt CTRL gt button on the keyboard and click on field header that should be removed from the sorting Even though all sorting is removed the data in the grid doesn t revert back to the state it had before the sorting began To show the data in the order it was before the sorting began press the Refresh button in the toolbar W Quick Sorting requires the grid to be in LoadAllRecords mode refer to section LoadAllRecords Mode 6 7 Quick Filter This feature allows the user to quickly filter data based on a specific field value without opening the SQL Query
37. caching This alias specifies where the cached tables should be placed Table caching is explained in section Opening a table Enable caching specifies if table caching should be chosen as the default option when opening a table from the Table Open dialog When using different databases with different users password this option must be disabled 3BEL303466R0101 Page 23 of 64 AlarmInsight Expert Tools Maintenance Incremental record fetching When a table is opened only one packet of records is fetched from the table instead of all records as normal This significantly shortens the time it takes to open a table When scrolling through the table new packets are fetched from the database when required Unless working with small local tables it is recommended to enable this option as it improves the execution times for sort query and table open operations When incremental record fetching is enabled the number of records shown in the lower left corner of the table window will show Fetched xxx records instead of xxx records This number xxx will then be the number of records fetched so far and not the total number of records in the table 4 1 2 Grid Layout Options x Database Grid layout Export directories Miscellaneous Show milliseconds in DateTime fields Show grid lines Grid color MMM Background color Use alternating background color Color Id fieldnarne
38. ccess the more advanced alias settings the BDE Administrator tool has to be used The BDE Administrator can be started by selecting Settings Control Panel BDE Administrator from the Windows start menu The Alias Manager dialog is opened from the menu item Tools Alias Manager and it is divided into two sections The upper part as shown in Figure 5 3 is common for all database types The lower part contains individual settings for a specific database driver and is described later in this section Only filters that match the table structure in the first chosen table will be shown If for example merging twelve month tables into one year table then the January table should be placed at top of the list box then the February table etc That way the records in the new merged table will be listed in the correct date time order 1 Only Paradox databases are supported as destination table To use this functionality the number of fields in the source tables must be less than the maximum number of allowed fields 3BEL303466R0101 Page 30 of 64 AlarmInsight Expert Tools Utilities Database Alias Manager E Database allas JUGDEMO y O New X Delete Driver type ante A Save STANDARD Figure 5 3 Alias Manager controls Database alias Lists all aliases supported by the Alias Manager Driver type Lists all database drivers available W It is recommended to always use the STANDARD Paradox driv
39. cter is used as single character wildcard I e if you want to locate all Tagnames starting with HA T and HA S but want to exclude Tagnames starting with HA DX the criteria should be HA _ When using the wildcards as literal characters a backslash must be placed in W front of the wildcard I e to locate all Tagnames starting with HA_ the criteria should be HA _ 3BEL303466R0101 Page 19 of 64 AlarmInsight Expert Tools Basic Operations 3 6 Time View 3 7 The Time View function is used for setting up a view for a desired time period While active only records matching the Time View settings will be shown in the table window The Time View dialog can be opened by selecting the menu item Table Time View x lara IME PETTE C M Adjust to scope after table refresh Stark date Stop date 01 01 2007 01 01 2007 Start time Stop time 00 00 00 e3595 X Cancel Figure 3 13 Time View Predefined time Offers a number of pre defined time scopes scope Adjust to If checked the date time settings will be adjusted every time a scope table is refreshed I e the date time settings will be adjusted to the current date time of the PC Refresh button Is only available when the time scope differs from User defined When pushed the date time settings are adjusted to match the current time scope setting Start Date Time Specifies the start date and start time of the desired
40. d set of data However it is possible for the user to clear or modify this query after the initial opening of the table The dropdown list with fieldnames and the edit field for the query criteria is known as the initial query controls Advanced The same as the initial query except that a more advanced query query button can be specified For information about the query builder refer to section SQL Query Sort controls Works the same way as the query controls mentioned above Except that here it is possible to specify a sorting field for the initial query when opening the table The sorting can be changed after the table has been opened Refer to section SQL Sort BaseTime SQL settings Use BaseTime Check to limit the time scope when the table is initially opened SQL BaseTime SQL Only visible if Use BaseTime SQL is enabled Refer to the settings description in section BaseTime SQL 3 2 1 Supported tables Expert Tools can be used against any table and not against the ones created by the Smart applications only There are however a few limitations e Features like BaseTime SQL and Time View will only be available if a DateTime field is present in the table Expert Tools will use the first DateTime field found unless otherwise specified by the user as described in section Field Customisation Panel e The maximum number of allowed fields in a table is 30 3 2 2 BaseTime SQL The BaseTime SQL is used to limit the number
41. dialog The default filter values are set equal to the corresponding field values of the current selected record Quick Filter a a x AAA Pieldwalue o E Gjem Text wildcards _ Single char wMlultiple chars Figure 6 4 When changing the fieldname the default field value will be changed accordingly The filter will be added to any existing SQL filter and must be modified removed via the SQL Query dialog refer to section SQL Query 3BEL303466R0101 Page 36 of 64 AlarmInsight Expert Tools Quick Access Functionality 7 ALARM MANAGEMENT Alarm KPI reports and alarm visualizations are not sufficient when executing alarm rationalization projects Alarm engineers must be able to take a step deeper in order to analyze alarm trends and patterns properly The Alarm Management option in Expert Tools include the necessary analysis tools needed for such drill down alarm analyses 7 1 Before using the alarm management analysis The different AM analyses have many configuration possibilities and can be used for many purposes To obtain both flexibility and usability a number of advanced settings are auto configured as default It is therefore important to read this section carefully in order to understand the behaviour of the analyses and to explore the full potential Take the Alarm Frequency analysis as an example This analysis may seem quite straight forward but can in fact be used for many different analyses like e Alarm Event frequency
42. e analysis dialog This filter is optional except for the Operator Response Time analysis where the filters are used to determine the event types All filter controls have a New Filter and a Modify Filter button as shown in Figure 7 22 3BEL303466R0101 Page 50 of 64 AlarmInsight Expert Tools Quick Access Functionality Data limitation Alarm Filter Figure 7 22 When pressing either one of the two buttons the filter dialog will be shown Filter definition name Valve Open Description Demo filter for presentation Filter criteria list OR Pseudo code Tagname K S A Gw e AMO Prop A Open Figure 7 23 New Filter or Modify Filter Filter definition Filter name name Description Optional information about the filter Filter criteria list Pseudo code Lists the query definition in pseudo code Each line represents a filter criterion All filter criteria are OR ed together in the final SQL statement Fdit button Opens the standard SQL Query dialog for editing query definitions as described in section SQL Query Delete button Deletes the selected OR criteria from the pseudo code list Delete all button Deletes all criteria 7 8 3 AM Options By pressing the options icon on the AM toolbar options as shown in Figure 7 24 can be set 12 The filter name can only be set when creating a new filter It cannot be modified later on like the rest of the information set for t
43. ed Priority The priority value from the data source Count Alarm count for this period and priority Graphical presentation Events Result Chart Messages a Priority distribution analysis for MER sED 2005 03 15 00 00 00 gt End of table ALM O i Chart period 2005 03 15 00 00 00 gt End of table Page 1 1 Figure 7 8 The graphical presentation shows the different priorities in overview 7 4 Alarm Frequency analysis The alarm frequency analysis is usually used to locate the top most alarms within any specified time period Depending on the initial settings it can be used for other purposes as well e Object alarm frequency analysis see below e Alarm distribution in selected areas process sections event severities event types etc An alarm analysis typically looks at unique alarms But some objects like PID regulators might generate many different alarms and these alarms might not be found in a standard 3BEL303466R0101 Page 41 of 64 AlarmInsight Expert Tools Quick Access Functionality analysis By analysing only on the object name tagname another pattern could be found The following shows a typical set up for an alarm frequency analysis Pas Analysis settings Data limitation Unique field s Tagname y Alarm Filter ABB Alarms Ol EventType y Time scope 2004 12 30 00 00 00 gt End of table lt NotUsed gt y Figure 7 9 Analysis settings
44. ent WTS Administrator Fie Tools Help Figure 8 1 8 1 1 Menu overview File Synchronizes settings for all WTS clients Changes will take Clients 1 AA S the next time the clients are started Exit program Alias Manager Opens the Database Alias Manager tool Opens the Options dialog Opens the Advanced Options dialog Options 3BEL303466R0101 Page 59 of 64 AlarmInsight Expert Tools Alarm Management License Opens the Locked settings Provider Some settings can be locked by the administrator using the small lock icon right to the settings Locked settings means that users cannot modify these if locked by the administrator In the following example the Enable option for Limit number of records fetched from server is locked for the user The user can however still change the maximum number of reords to be fetched Limit number of records fetched from server MW Enable E basimumn number of records sooo0a A a TF Show warning when limit is reached License provider dialog Help Shows this User s Guide in PDF format Opens the registration dialoc 8 1 2 8 1 Shows the credits and the release version Locked settings Some settings can be locked by the administrator using the small lock icon right to the settings Locked settings means that users cannot modify these if locked by the administrator In the following example the Enable option for Limit number o
45. ent will be shown Color Id mapping This technique can be used when there is an integer field in the table containing values between 1 16 Each value is associated with a color thereby making it possible to show print records with individual colors How to set up the colors is explained in section Color Setup 4 1 3 Color Setup Customize Colors X Screen Color screen Color ocreen Color Screen Color screen Color D 0 E EA ES AA al Screen Color a Print Color ER Print Color Print Color z Frint Color Grid color Print Color Print Color Print Color Print Color X Cancel Figure 4 3 For each of the color Id s from 1 16 it is possible to specify which color should be used for the matching record on screen an on a printout To change a color simply select a Color Id in the grid and set the desired color It is possible to select from a number of standard colors but a user defined color can also be composed selected as shown in Figure 4 4 Screen Print mu gt BEEBE EEE BREESE A EHR mE f im pmm mini iE EA IA IA me A p MENA Y MODOOMNE L EHEHE DONA a E Custom Colors Custom Colors O 3BEL303466R0101 Page 25 of 64 AlarmInsight Expert Tools Maintenance Figure 4 4 4 1 4 Export directories Database Grid layout Export directories Miscellaneous F SmartLogiClient SCData Expor HTML F SmartLog Client SCData Export xML Figure
46. ents extracted from the data source and used for the analysis This view can be used to document the data that the result is based on e Result view Shows the result of the analysis This data can be used for subsequent examination export to Excel or similar e Chart Graphical presentation of the analysis result e Messages Trace messages and warnings related to the analysis This can be used for fault tracing and examination of unexpected results Alarm Rate analysis The alarm rate analysis is used to give an overview of the overall alarm rate compared to the EEMUA recommendation of 1 alarm per 10 minutes under normal conditions Although this is an alarm rate analysis tool it can also be used for other purposes as well Depending on the initial settings it can be used for e Alarm Event rate analysis e Alarm peek detection e Alarm rate analysis for specific process areas or process units The following shows a typical set up for an alarm rate analysis where the results can be compared to the EEMUA recommendation Alarm Rate analysis for 12520041015 gt 116 2 Analysis settings Data limitation Resolution fi 0 minutes y Alarm Filter Ol A Time scope 004 10 15 00 00 00 gt End of table Figure 7 2 Analysis settings Resolution Specifies the alarm count resolution If a 10 minutes resolution is selected then the number of alarms for each 10 minute interval is reported Data limitation Alarm filter
47. er unless it is explicitly required to use another database driver 5 3 1 Database driver settings Paradox 7 STANDARD driver Paradox Database path F1SmarLogiTables EE Figure 5 4 Paradox 7 settings Database path Defines the location directory where the tables are stored Oracle 8 ORACLE driver Oracle 0 Meti Service name Table list cache time min Maggie 0 Detault username Jscatt FP AutoCoramit enabled Figure 5 5 Oracle 8 settings Net8 Service Defines the Oracle Net8 service name Must be defined in advance name by using the appropriate Oracle tool Default user The default user name that is used if automatic database login is name disabled AutoCommit If enabled the BDE automatically commit records to the table after enabled each post If disabled the application decides when to commit the records 3BEL303466R0101 Page 31 of 64 AlarmInsight Expert Tools Utilities Please note that this setting is only relevant for applications that actually write to the database like SmartLogger or SmartTranslator Table open list Defines how long the table list is cached in memory A new table list cache time is not fetched from the database server until the cache time expires Possible cache time values The table list is cached as long as the program is running This should only be used for static databases where no tables are added after the program is started The t
48. escending Basel ime SOL settings W Use BazeTime SOL Scope Previous hour 4 ee From 13 10 2010 15 00 00 to 13 10 2010 15 59 59 Figure 3 1 Open Table Database alias A button Table list filter Refresh button Tables Views Cache data Sort descending Single column list Tables Query controls X cen Contains all available aliases Advanced options Please refer to section Advanced Options Filter input control used to restrict the number of tables shown in the table list Standard wildcards like and are accepted Refreshes the list of tables When checked all table records are cached to a local table before this table is opened All subsequent operations will be performed on the local table This feature is especially useful when requesting data via slow networks Toggles the sort order between ascending descending for the table views listed Enables disables the use of multiple columns in the table list Lists all available tables for the selected alias that matches the specified filter Initial SQL settings Instead of retrieving all records in a table it is possible to limit the This button is only visible for aliases connected to server based databases like Oracle or MS SQL Server 3BEL303466R0101 Page 9 of 64 AlarmInsight Expert Tools Basic Operations number of records initially returned All subsequent operations will be performed on this limite
49. et The layout of the worksheet will be the same as shown in Expert Tools table grid I e the order of the fields the field alignment and the size of each field will be as shown in the table grid The file can be read by all MS Excel versions from 4 0 and up 5 1 4 XML Export The records are exported to a XML XSL file 5 2 Table Merge With the Table Merge function it is possible to merge multiple tables with the same structure into one table This is useful if for example data is stored in monthly tables but an analysis covering the entire year is needed In order to perform a merge all source tables must have exactly the same table structure This means equal number of fields identical field names identical field sizes etc An exception is character fields where different field sizes are allowed The Table Merge dialog can be opened by selecting the menu item Tools Table Merge Table Merge Source database alias Merge filter USERDATA lt Ma fiter Available ValvesLeveli ValvesLevelb Destination table Table name USERDA TS Prodlevelalvez Add source table name as last field Open destination table after successful merge Figure 5 2 Table Merge Source Database Alias Specifies the location of the source tables 3BEL303466R0101 Page 29 of 64 AlarmInsight Expert Tools Utilities Merge filter Optional filter that can be applied to each table before it is merged Thereby on
50. etry figure Preview Cylinder Axisymmetic geometry figure Auto Calculate Preview Lines Preview Line coumt 1 Iv Grid Nodes Grid Group Footers Grid Flat CheckMarks Display CheckMarks as Text Title Properties Cancel Figure 3 6 3 4 3 Preview Shows how the actual report will look when printed All print set up dialogs can be accessed from the preview dialog including a few additional like the page background configuration Holding down the CTRL button and spinning the mouse wheel will zoom the print preview in out 3BEL303466R0101 Page 15 of 64 3 5 3BEL303466R0101 AlarmInsight Expert Tools Basic Operations Fa Print Preview File View Format Go 2150 5954 S80 BB A 100 oe Za Margins Left 20mm Top 20mm Rioht l 15 mm Bottom 20mm eader 10 mm Foeter 10 mm 10 x 31 12 2004 00 06 27 PLLLSL 34567 31 12 2004 00 07 27 HIO TAHH 1122 Surge Level 4 Page 3 of Figure 3 7 SQL Quer SmartClient Table Report Source Table LOGDATA AM_AR_ 500 Logba u Eent Tagname Description Procesor Propao Prop 022000927 fen woren een Pap S f DaS AEn EAO Turbine Blowdown A foe Closing i Closed Failure Closing Closed Closed Mormal BO Alarm H2 190 Alarm E EN EE 2 2 12 2 16 2 12 2 12 2 2 2 2 mm mo 4d Bay Boy Bay md 31 12 2004 00 08 27 1 20LALM WoA TAL 32177 L1 Production Slon Tank og Pages
51. f records fetched from server is locked for the user The user can however still change the maximum number of reords to be fetched Limit number of records fetched from server M Enable E blasimum number of records soo000 WA a FP Show warning when limit is reached License provider When Expert Tools is launched in concurrent version mode a license must be granted by the License Provider service The License Provider service keeps track on the licenses available and ensures that the number of licenses bought is not exceeded The WTS administrator can see all the users currently running Expert Tools and has the ability to revoke individual users licenses The interface is shown in Figure 8 2 3BEL303466R0101 Page 60 of 64 AlarmInsight Expert Tools Alarm Management ie License Provider OOOO y Tierereee eee Torre ee eee ee a ss Ka Eielresh Kim 2005 06 07 22 09 02 Granted lt AVeallable gt o Revoke lt Anallable gt lt 4 ailable gt lt Awallable gt fl Close Mo of licenses 5 Available 4 Connected a Figure 8 2 Refresh Refreshes the grid with information about connected SmartClient s Revoke Revokes the selected user s license This means that the license will be freed up for someone else Be careful when using this feature since the client cannot do anything other than closing his SmartClient application after a license has been revoked The License Provider set
52. hat filter 3BEL303466R0101 Page 51 of 64 AlarmInsight Expert Tools Quick Access Functionality Alarm Management Options X Figure 7 24 General Analysis Common options Enable Auto align time scope az default M Don t copy fetched events to local table This will increase performance but eliminate the possibility to examine the events within the Abl dialog e Show Messages tab Default held selections Unique field s Tagname Description hi Not Used x Priority field Pricority Estra field Common options Enable Auto align time scope as default If checked the Auto align time scope feature is enabled by default Don t copy fetched As default a copy of the fetched events will be stored locally in the TEMPDATA alias When working with a large amount of source data this setting can be used to increase performance When enabled the Events view as mentioned earlier will not contain any events Show Messages tab If enabled a Messages tab is shown containing all runtime messages for the analysis This should only be used in case of unexplainable errors in the analysis result Default field selections Unique field s Priority field Extra field 3BEL303466R0101 Default selections for analysis using these kind of fields Page 52 of 64 AlarmInsight Expert Tools Quick Access Functionality Alarm Management Options
53. hese two selections will now be selected Print Preview Selected All This feature is basically the same as the Print feature described in section 3 4 Grouping Mode This feature allows all the data in the table grid to be grouped by any field specified by the user aS shown in Figure 6 2 When grouping mode is activated a grouping panel becomes visible just above the table grid To group by any field simply drag the column header to this panel To remove a field from the grouping panel simply drag the header back to the table grid fa LOGDATA AM_AR_500 A K lt O gt ja mr O ventType logpate id Tauname Description ____ PropACoum E Procsec 6 E EventType ALM El Procsec 12 E EventType ALM El EventType EWT E Procoec 15 E EventType ALM i M B11220041 01 1427 85 WSA TAL 32177 L1_ Production Slop Tank B50fAlarm L1 E F 152 15 P 184 i 218 WSA TAL 32177 L1_ Production Slop Tank 217 i AE APA S an m Figure 6 2 WY Grouping requires the grid to be in LoadAllRecords mode refer to section LoadAllRecords Mode 6 6 Quick Sorting Mode This feature allows the user to sort the data in the grid without having to perform a SQL statement against the database server By clicking on the field headers data in that field is sorted in ascending order Clicking again reverses the sort order to descending When a field is sorted a small up down arrow appe
54. his setting is not required for the analysis but might add valuable information to the result lists If for example a Description field is available then this field can be chosen and informative texts will be added to the tagname references Data limitation Pre warning Specifies the filter that identifies the pre warning alarms typical H1 Hi filter or L1 Lo alarms Alarm Trip Specifies the filter that identifies the trip alarms typical H2 HiHi or 3BEL303466R0101 Page 45 of 64 AlarmInsight Expert Tools Quick Access Functionality filter L2 LoLo alarms Time scope This shows the actual time scope that will be used for the analysis Refer to section Limiting the analysis period for information on changing the analysis period Pressing the Execute button starts the analysis and the final result will we be presented in a data as shown below Grid presentation alarm pairs Alarm pairs Summation Histogram a M4 rl E eRe TS PreWarning TS Alam a 2 E a Pa 09 49 GPRS pe 29 3 03 2006 10 12 14 24 30 U3 2006 04 03 U3 50 SLIT e O tt st 7 23 EE 02 50 19 0 02 03 2006 10 53 03 02 03 2006 13 43 22 E 5 25BPT3016 2 01 39 36 0 01 03 2006 03 02 39 01 03 2006 04 42 78 g 207 23 F TE 353511 01 05 17 O 24 05 2006 00 57 56 24 03 2006 02 03 13 p 2744 23P PIT 353119 00 55 11 10 24 03 2006 00 16 48 24 03 2006 01 11 59 E 135 23 F TE 353511 00 33 58 O 17 05 2006 18 27 44 17 03 2006 19 01 42 E 26
55. ht Expert Tools Maintenance 4 MAINTENANCE 4 1 Options The Options dialog can be opened by selecting the menu item Tools Options 4 1 1 Database x Database l Grid layout Export directories Miscellaneous Database auto login Enable Username Password Limit number of records fetched fram server M3 50O Enable Maximum number of records E 000 WA Show warning when limitis reached Incremental record fetching Y Enable Record packet size 50000 VA Default alias for Table Open gt Enable Default alias LOGDATA Table caching Cache alias CACHEDDATA y Enable caching as default on Table Open dialog Figure 4 1 Database Database auto If enabled Expert Tools will attempt to log on to a database with login the specified user name and password This can be used to avoid a user name password dialog every time a table is opened Limit number of If enabled record sets from the SQL server will be limited to the records number of records specified This feature only works for MS SQL Server databases Incremental If enabled Expert Tools uses a technique where only a specified record fetching number of records are fetched upon request record packet size See also description below Default alias If specified then this alias will always be initially selected when the Table Open dialog is opened Otherwise the previously selected alias will be used Table
56. ht Expert Tools Quick Access Functionality Alarm pairs Summation Histogram l i lt P alli eu ll a ant Sao nnan Poss ecru nai e Tomren E IGF FT 35020 00 02 00 0 00 00 00 00 00 07 s below recommended reaction time 1 E 23F XT 353013 00 02 00 E 100 00 00 05 00 00 05 00 00 06 1 D A is below recommended reaction time K 23 F TE 353027 00 02 00 2 100 00 00 00 00 00 00 00 00 00 0 0 Possible identical setpoints E 23 F LT 500202 00 02 00 1 100 00 01 08 00 01 08 00 01 08 D 0 100 is below recommended reaction time E 23F LT 500302 00 02 00 27 100 00 00 01 00 00 03 00 00 50 2 7 100 is below recommended reaction time E 23AFT45051 00 02 00 1 100 00 00 00 00 00 00 00 00 00 0 0 Possible identical setpoints F 23 CTI16114 00 02 00 3 100 00 00 00 00 00 01 00 00 01 0 0 100 is below recommended reaction time E 23F PT 590503 00 02 00 11 100 00 00 01 00 00 04 00 00 15 2 0 100 is below recommended reaction time y 23 F PIT 353242 00 02 00 1 100 00 00 00 00 00 00 00 00 00 O O Possible identical setpoints gj 23F Fl v 670045 00 02 00 14 100 00 00 00 00 00 03 00 00 18 3 5 100 is below recommended reaction time E 23 F LT 410002 00 02 00 1 100 00 00 23 00 00 23 00 00 23 6 0 100 is below recommended reaction time E 23 F Z7 353025B 00 02 00 9 100 00 00 00 00 00 00 00 00 00 0 0 Possible identical setpoints i 23 F ZT 353025A 00 02 00 9 100 00 00 00 00 00 00 00 00 00 0 0 Possible identical setpoints E 23F ZT 353050A 00 02 00 9 100 0
57. ield Tagname in the analysis as this would also inadvertently include the Failure events You will then have to add an object to the analysis as shown in Figure 7 27 Add analysis object X Object name Export Pump ON criterials OFF criterials Tadgnarne Taqname xy 2 PUMP 1 234 xy Z PUMP 1 34 Evert Text Event Text Running stopped HOT USED HOT USED v OK X Cancel Figure 7 27 In this case we have given the pump XYZ PUMP 1234 the more explanatory object name Export Pump Example Add object by drag n drop An easier way to add objects is to drag two records an ON and an OFF criteria from the table and directly into the Analyze Time dialog When dropped onto the Defined objects list box a new object is automatically created Adding the same object with the same information as specified in the previous example would be performed like this e Select the 2 records that can be used as ON OFF criteria s in the table grid In this case we will use the same records as used in the previous example above e Drag these records to the Analyze Time dialog and drop them onto the list box A dialog as shown in Figure 7 28 should now appear 3BEL303466R0101 Page 55 of 64 AlarmInsight Expert Tools Quick Access Functionality Add analysis object x Object name Export Pump Selectthe record to be used as ON criteria G YZ PLIMP 1234 1 Running CY Z PUMP
58. lation and Set up INSTALLATION AND SET UP System requirements Computer A 100 IBM PC compatible computer with a Pentium III 500 MHz processor and 128 MB RAM 256 MB or more recommended Supports a screen resolution of 800x600 but 1024x768 or higher is recommended Operating system Windows 2000 2003 XP Windows7 Disk space 30 MB free space for system files and additional space for log tables Online User s Guide The online User s Guide is available from the menu item Help User s Guide To view this User s Guide you must have Adobe Acrobat reader 6 0 or higher installed on your system The Acrobat Reader software can be downloaded from http www adobe com Adobe Acrobat reader is copyright of Adobe Systems Incorporated Installation amp product registration Refer to the installation guide included in the software delivery package If no installation guide is available please contact your Expert Tools supplier 3BEL303466R0101 Page 7 of 64 AlarmInsight Expert Tools Basic Operations 3 BASIC OPERATIONS 3 1 Menu overview File Open Opens Opens the Opening a table dialog Opening a table dialog Open current SL Opens the currently active SmartLogger table tables Closes the active table Close All Closes all active tables and disconnects from all databases Opens the Save View As dialog Export Sub menu for exporting the active table to a Text Excel HTML or XML file Exit
59. log can be opened by selecting the menu item File Export Field separator Field delimiter Tabs a Commas Nothing C Sermi colons C Space aligned C Custom Custom separator Custom delimiter Include field names as first line C Custom Destination file F1SmariLog Client SCdatayExporty Text SCexportte E Export X Cancel Figure 5 1 Table Export Field separator The character used as separator for each field value in the exported text If Space aligned is chosen every field will be padded with spaces so that the length of the text always corresponds to the size of the field I e if the field size is 10 and contains the data Alarm the exported text would be Alarm 5 spaces added to the text Field delimiter The delimiter surrounding each field value Custom If the Custom button is selected it is possible to specify any sep delim character Include field If checked the first line in the export file will contain the field names names This line will be formatted the same way as the record lines Destination file Select the browse button at the right of the control to specify the location and name of the export file 3BEL303466R0101 Page 28 of 64 AlarmInsight Expert Tools Utilities 5 1 2 HTML Export The records are exported to one HTML file containing a table with all records 5 1 3 MS Excel Export The records are exported to an MS Excel workshe
60. ly specific records will be included in the merged table Refer to section SQL Query for a description of how to specify filters Available Lists all available tables for the selected alias Chosen Lists all tables selected for merge Up Down arrows Use these arrows to change the merge order The tables are merged in the listed order meaning that events in the first table will be positioned at the top of the destination table Destination table Table name Name of the new table to be created Pressing the small button to the right of the table name will call up the Table Save As dialog Add source table name as If checked the Merge operation will add an extra field to last field the destination table t This field will for each record contain the name of the source table Open destination If checked the Merge dialog is closed and the new table is opened immediately after successful merging 5 3 Database Alias Manager A database alias is needed in order to access a database It defines the database driver connection parameters and the destination path database type The Alias Manager can be used to add modify and delete aliases with the restriction that only the basic settings like database driver destination path database default user etc can be changed Normally the user only needs to access the basic settings as the Alias Manager automatically configures all advanced settings If it is required to a
61. ntains all available tables for the selected database alias The Save View As feature will save the active table view to a new Paradox table This means that only the records matching the active table s current sort query and time view settings will be saved to the new table This feature can be used to make subsequent analysis much faster since it is possible to store the relevant events in a separate table and perform the analysis on this new and reduced table instead Print Expert Tools uses an advanced printing system with a lot of advanced features This User s Guide only describes the use of the most essential parts on the printing system but the user is encouraged to experiment with all the other features it offers The Print dialog can be opened from the menu item File Print or from the associated toolbar button 3BEL303466R0101 Page 12 of 64 AlarmInsight Expert Tools Basic Operations 2 Print Printer Hame aa HF Laserjet 1200 Series PEL Properties Status Read Network Type HP LaserJet 1200 Series PCL Where IP 192 168 1 109 Comment Print to Eile nd Browse Page range Copies al Number of Pages Current Page Number of Copies C Pages Collate Copies Enter page number and or page ranges separated by commas For example 1 3 5 12 Print Styles e Preview Figure 3 4 W Printing requires the grid to be in LoadAllRecords mode refer to secti
62. number of records actually sent over the network 3BEL303466R0101 Page 64 of 64
63. o an analysis log when the analysis is finished The log file is named lt Analysis name gt atr The runtime messages can be printed using the Print button located to the right of the message window Analysis files The following files are generated during an analysis Filename Description _____ O o The analysis template The analysis log The analysis log S lt Name gt _RES db The results of the analysis database table lt Name gt _ALL db All ON OFF pairs of the analysis database table lt Name gt is the name of the template The template file is located in the lt Programpath gt AnalyzeTime directory while the other files are located in the directory specified by the ANLZTIME alias As default the ANLZTIME alias points to the lt Programpath gt AnalyzeTime Data directory W Do not edit modify or delete any of these files by yourself All configurations must be done with the Expert Tools s Analyze Time tool 3BEL303466R0101 Page 57 of 64 AlarmInsight Expert Tools Quick Access Functionality 7 9 3 Exporting results By right clicking with the mouse anywhere in the result grid it is possible to export some or all of the results to another format The results can be copied to the clipboard or exported to Text MS Excel HTML or XML files 7 9 4 Loading an analysis result It is possible to load view and or print an analysis performed earlier If the menu item Analyze Time Load Result is selected
64. on LoadAllRecords Mode 3 4 1 Page Setup Determines the layout of everything outside the data area like e Page sizes print orientation print order e All margins e Header footer texts e Report scaling 3BEL303466R0101 Page 13 of 64 AlarmInsight Expert Tools Basic Operations Da Page Setup SmartClient Standard x Style Mame Smartclent Standard Page Margins Header Footer Scaling Orientation Paper a Portrait Landscape RaEnyvelope 10 EdEnwelope BL Ra Envelope C5 Dimension Print Order width 210 00 mm ec C Down then over LEEF SE Height 297 00 mm H Bram Over then down Paper source srietliig automatically Select y Print using gray shading Figure 3 5 Ny To exclude fields from a report please refer to section Field Customisation Panel 3 4 2 Report Design Determines the layout of the report data like e What to show header footer grid bands e Colours grid header footer e All fonts used e Behaviours 3D effects graphics The report designer can be opened from the Preview dialog refer to section Preview 3BEL303466R0101 Page 14 of 64 Report Designer AlarmInsight Expert Tools Basic Operations Options Colors Fonts Behaviors Show Grid Miscellaneous cd Draw Mode Strict pus Preview J Bands Asymmetric shape v Headers T Footers ne m e Group Footers Axisymmetric geom
65. ote computers This feature is especially useful in configurations where multiple users must access the same event tables generated by the SmartLogger SmartTranslator The procedure for creating a remote alias is the same as for creating a local one Just use the browse button to specify a network path instead of a local path When using remote aliases with Paradox databases the following must also be ensured e The client computer must have full access to the network destination I e the directory specified in the destination path must not be write protected e All BDE programs SmartLogger Expert Tools must use the same NET DIR path This setting can be changed verified from Control Panel BDE Administrator Configuration tab sheet Drivers Native Paradox 3BEL303466R0101 Page 33 of 64 AlarmInsight Expert Tools Quick Access Functionality 6 QUICK ACCESS FUNCTIONALITY The quick access functionality is a menu that pops up when right clicking with the mouse anywhere in the table grid 6 1 Copy to clipboard The same functionality as described in section Copy selected records 6 2 Field Customisation Panel When selected a panel is shown to the left of the table grid LOGDATA AM_AR_500 o _ o x oi alt lt lt gt cE ma LogDate 30 12 2004 23 49 27 Id 30 12 2004 23 50 27 Ewent ype E 30 12 2004 23 51 27 Tagname 30 12 2004 23 52 27 Description 30 12 2004 23 53 27 LE ENE
66. plementary auto generated descriptions about possible bad actors Histogram for selected tag Pressing the Histogram li button a graphical presentation of the reaction times for the selected tag is shown 3BEL303466R0101 Page 47 of 64 AlarmInsight Expert Tools Quick Access Functionality Alarm pairs Summation Histogram S lt lt gt gt Reaction Time analysis for UG Sample Data 2006 03 01 00 00 00 gt End of table 1 I 1 1 I 1 1 I 1 1 I I 1 1 I 1 A 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 00 10 o a a o Phar Seana ena aL e T A a TN A a a a o as mg ae a al o a a o ct Get A 1 I I I I 1 I I 1 I I 1 I 1 1 I 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 I 1 1 2 al asa o e ls es el Page 1 2 OFB_AT36197 Figure 7 17 7 7 Parent Child analysis The Parent Child analysis is a powerfull tool to get a gross list of potential resulting alarms thus saving lots of engineering hours looking into endless alarms logs The Parent Child analysis scans through months of alarms and calculate two important indicators for each Parent Child alarm pair Predictability Shows when the parent alarm occurs how often the child alarm followed Significance Shows when the child alarm occurs how often the parent alarm preceded Alarm pairs with high percentage in both predictability and significance are must likely Subject for being a resulting alarm The following shows a typical set up for an P
67. rent 11 02 2007 16 36 36 46b FPAL24045 SealventprndelP Alarm 11 02 2007 16 36 36 466 PALZ4051 Seal vent pr de IP Alarm Child 11 02 2007 17 18 08 4722 PI24045045 seal vent pr nde IF 1 50 bar q Parent Figure 7 20 7 8 Common AM Options 7 8 1 Limiting the analysis period The selected time scope for the analysis is shown on the analysis dialog Alarm Rate analysis for PORT2_20050400 T To ES ri Analyze settings Data limitation Resolution fio minutes y Alarm Filter lea Time scope 2005 04 26 00 00 00 gt 2005 04 26 23 59 59 Figure 7 21 To change it go to the table view and change the current Time View for the table view In some cases the time scope shown on the analysis dialog will be slightly different than the Time View settings This is due to the auto scale functionality Y that will try to find the best time scope according to the selected resolution An adjustment will typically happen if the selected time scope starts or stops at an odd time like for example a start time at 00 11 53 The auto scale function will then change the start time to 00 00 00 Auto scaling can be enabled disabled on the analysis toolbar 7 8 2 Limiting the analysis data Any SQL queries applied to the data source will be automatically applied to the analysis To change a query go back to the table view and change the SQL Query settings refer to section SQL Query In addition to the standard queries an additional filtering can be applied from th
68. riteriats Tagname xYZ PUMP 1 34 Event Text Running NOT USED Ss AT Analyze Figure 7 26 7 9 1 Designing an analysis 1st field Tagname y end field Event Text y 3rd field NOT USED Add Modify Delete Tagname xYZ PUMP 1 34 Event Text OFF criteriats Stopped NOT USED ss X Cancel In order to perform an analysis the following must be specified 1 The fields to include in the analysis in order to make an event unique 3BEL303466R0101 Page 54 of 64 AlarmInsight Expert Tools Quick Access Functionality 2 Whether the analysis should be performed on the entire table or only on the records limited by any query or time view settings If the analysis must be performed on the entire table the checkbox labelled Apply query and time limitations must be unchecked 3 Any number of objects with corresponding ON and OFF criteria s Example Add object manually In the table below there are 4 events each with different properties in the fields Tagname EventTexti and EventText2 XYZ PUMP 1234 XYZ PUMP 1234 XYZ PUMP 1234 XYZ PUMP 1234 Stopped If you for example want to analyze the time that the pump has been running the time between Running and Stopped in EventTexti then you must configure the analysis for using both the Tagname and the EventTextl fields It would not be enough just to use one f
69. roperty ext Status Sort orde f Ascending C Descending x Cancel Figure 3 15 Sort Records Available fields Contains a list of all available fields Fields to sort Lists the fields to be used for the sort operation in descending priority Sort order Choose ascending or descending sort order for the sort operation Up Down arrows Use these arrows to change the sort order Fields can be moved between the list boxes by double clicking on the field name or by using the move buttons in the centre of the window To reset the sort order remove all fields from the Fields to sort list box and click OK Although the records are re fetched from the database server the records are Ny only sorted in the table grid I e the underlying source table is not affected 3 9 Copy selected records This feature can be accessed from the menu item Edit Copy To select more than one record do one of the following e Press and hold down the SHIFT key while pressing the up down key e Press and hold down the CTRL key while selecting records with the mouse e Select a record with the mouse hold down the SHIFT key and select another record All records in between these two selections will now be selected To copy the selected records to the clipboard use one of the following methods e Select the menu item Edit Copy e Right click in the table grid to bring up a small copy export menu 3BEL303466R0101 Page 22 of 64 AlarmInsig
70. t Pump Analyzing object Main Export valve 7 Close Analysis finished at 2000 01 01 21 10 25 Dose Figure 7 29 3BEL303466R0101 Page 56 of 64 AlarmInsight Expert Tools Quick Access Functionality The analysis status dialog is divided into two parts At the top you have the object list containing the status for each of the objects configured for the current analysis template At the bottom all the runtime messages that the analysis generates are listed Object list section The object list grid has the following fields Description gt O Object Match Min Time Avg Time Max Time The longest time found between any ON OFF pair Tot Time The accumulated time for all ON OFF pairs Warnings The number of warnings generated for the object Status Pending waiting for calculation Calculating currently calculating times Done analysis for this object is finished The results can be printed using the Print or the Print Preview button to the right of the grid During the analysis Expert Tools creates a separate table that contains all ON OFF pairs This table is named lt Analysis name gt _ALL and can be opened just like any other SmartLogger table Pressing the View On Off button will open the table and at the same time minimize the Execution Status dialog Runtime messages section All relevant status information warnings and errors are listed in the message window The information is written t
71. tings Data limitation Resolution lt None gt y Alarm filter ABB Alarms 2 D ej Priority field Priority v Time scope 004 1015 00 00 00 gt End of table Figure 7 6 Analysis settings Resolution The analysis can be divided into time periods like a day based analysis for a complete month When specified the graphical presentation will have a corresponding number of pages Priority field Specifies the field in the table containing the priority identification Required Data limitation Alarm filter Specifies the filter to be used on the data sources If no filter is selected then the complete data source is analyzed Refer to section Limiting the analysis data for creating or modifying filters Time scope This shows the actual time scope that will be used for the analysis Refer to section Limiting the analysis period for information on changing the analysis period Pressing the Execute button starts the analysis and the final result will be presented in a data grid and as a graphical presentation as shown below Grid presentation 3BEL303466R0101 Page 40 of 64 AlarmInsight Expert Tools Quick Access Functionality Events Result Chan Messages PS e mi fh PeicaFrom TN CTI 15 03 2005 4436 E 15 03 4005 rs 440 E 15 03 2005 HI 3614 Figure 7 7 Column descriptions Period From Indicates the analysis period Only relevant if a resolution has been select
72. ulating elapsed time between two specific events and is a part of the Analyze Tools add on In the Expert Tools terminology the two events used for calculating elapsed W times are called an ON criterion and an OFF criterion 3BEL303466R0101 Page 53 of 64 AlarmInsight Expert Tools Quick Access Functionality In the process industry this Analyze Time function can be used for many different purposes like calculating The total running time for a pump How many times a certain pump has performed a start stop cycle How many times a certain valve has gone from open to close The min avg max running time for a pump The min avg max travel time for the valve In addition to this the Analyze Time module will detect signal flicker if one of the analyzed objects has this problem Signal flicker can occur if there for example is a bad connection in a valve s closing switch so that the switch generates two events every time valve is closed The Analyze Time configuration dialog Shown in Figure 7 26 can be opened by choosing Analyze Time Config Run from the menu A configured analysis can be saved to disk The file saved is called an Analyze Ny Time template and describes all objects pumps valves etc and analysis settings for one analysis Analyze Time nlzTimellsg x UGDEMO ANL Z TIME Analysis fields Apply query and time limitations Detined objects Main Export Valve DN c
73. up is shown in Figure 8 3 HL License Provider x License provider serca 7 fe Befresh Socket port used for license provider 12004 gt License prowider status started gt a Users Setup Mo of licenses 5 Available 5 Connected Figure 8 3 Socket This is the port that SmartClient will use to communicate with the License port Provider service It is default port 18004 and should not be changed unless it conflicts with some other application 3BEL303466R0101 Page 61 of 64 AlarmInsight Expert Tools Alarm Management Start Stop Starts Stops the License Provider service It is only necessary to restart the service in these cases 1 The socket port has been changed 2 The number of user licenses has been upgraded like from 5 concurrent users to 10 concurrent users The final tab sheet Trace shows information messages regarding the communication with the License Provider service and is only relevant for fault tracing 8 2 WTS Information The WTS information dialog showing the current user s individual WTS settings can be opened from the menu item Tools WTS Information in Expert Tools C WINZ000 Smartclient UserData CACHEDDATA C WINZ0001 Smartclient CachedData ANLZTIME C WINZOOO SmartClient AnalyzeTime Data ANLSAFREG C WINZOOO dmartCclient AnalyzeFregq Other information WTS homedirectory C WINZOOO SmartClient Figure 8 4 3BEL303466R
74. ve accepted e Pump Control does not match PUMP CONTROL 5 query Load Load a previously saved query definition Save Save the current query definition to a file 3 5 1 Query examples Exact match gt Will be disabled if the database does not support case sensitivity A query can only be loaded if field names types used in this saved query matches the table structure of the current table 3BEL303466R0101 Page 17 of 64 AlarmInsight Expert Tools Basic Operations If you want to see all records where the Tagname field contains the exact string HAS OV 12222 you simply enter Query Definition E Criteria ANCO Tagname JHAS OV 1 eedd Add to list Figure 3 9 Combined AND criteria If you in addition to the Tagname criteria only want to look at records where PropertyACount is greater than 50 then you additionally enter Query Definition x Criteria AND Tagname y HAS OV 12244 Add to list PropertyaCount gt fso Midate Figure 3 10 Using multiple character wildcards If you in addition to the criteria s above only want to look at records where Description starts with Flare then you must enter Query Definition X Criteria ANMCO Tagname y JHAS OV 1 eedd Add to list PropertyACount gt fo Update Description y Flare Reset All Figure 3 11 It is also possible to use multiple wildcards in a single criterion If you for example
75. want to extract all records where the Tagname starts with KKS and contains the characters ZSC the criteria should be KKS ZSC W A wildcard is only valid for character fields Adding multiple criteria s OR To add another criteria to this query click on the Add to list button and the AND criteria just specified will be added to the criteria list In this example we now specify another criterion which singles out the events where Tagname equals EEF P 7075 and with PropertyBCount less than 15 The query should now look like shown in Figure 3 12 3BEL303466R0101 Page 18 of 64 AlarmInsight Expert Tools Basic Operations Query Definition Criteria AMC Propery Count dis ooo Update NotUsed eff NotUsed o Reset All NotUsed ff NotUsed wf ff Test wildcards Single char 4 Multiple chars Criteria list 0 Pseudo code Tagname H45 0 41 2244 SND Property Count 50 AND Descriptio Tagname EEF P f075 SND PropetyBCounte 15 e We Case sensitive 213 Query M Cancel Figure 3 12 When the Query button is pushed the SQL query statement will be composed by the statements in the list and the criteria in the AND section In this example the logical query will look like this Tagname HAS OV 12244 AND PropertyACount gt 50 AND Description Flares OR Tagname EEF P 7075 AND PropertyBCount lt 15 Wildcards single characters For all databases the _ underscore chara
76. ystems Inc OPC Registered trademark of the OPC Foundation 3BEL303466R0101 Page 2 of 64 Table of Contents 1 ANEFOGU CUON minis 5 Li Conventions and CETINITIONS eps Aisa 5 2 Installation and Set up iia 7 2L System tequireentSs ar E 7 2 2 Installation proquct registration aida cis 7 3 Basic Operations cian 8 Sad Menu oO Ve MISWissr a a a ea 8 Biz OPENING a table irina is 8 3 2 SUPpported La DIES aida aid 10 Si2e2 BasetimMe SOL 10 O O O PCE OS A E 10 5224 Advanced OPINA 10 2o SAVE VIEW AS crne Ea ten index around shasta aeerevedetoomniavarguedetanaielatorevedetaraehes 11 BS PUN iia 12 tel Page SEUD sei aves al a a o iS 13 ez REDOC DESIGN ii A A AEEA 14 Sk O T a aa a N es 15 S09 SOL OUEN iaa 16 5 5 1 QUErY examples rrinin AAEN AAAA AAE AE aa 17 OHO TIME V EW e a e a Seams tected a a a a a ed mace 20 3 7 FING RECORG a aa 20 3 0 SOL SOE nta noia A AAAA AA EEA 21 239 COPY selected econ Sanare ias 22 4 MalntenanCO isa 23 Ack COPOS uscar tantra 23 a A S A OE o E E A A E E A A A E A AE T E E A E es 23 Aa AT BAY OUR aea rita ta 24 Aa Coor Seturan nn Ea O A A OEA 25 Ade EXPONO TONE S rara 26 AES Miscelaneos Aa AEA A A A AE AE adas 26 5 DEMOS aa 28 Sel Table IEXDO rra 28 Sede TEXN LO A A 28 iz TEME EXPO ai eee ene er ne ren ere eet 29 o Wo eX CEDE aa ee oe 29 AA XAMEEXPO a AAA 29 2 Table Mere aaa ias 29 5 3 Database Alias Manager 0 a ARA AAA ARA 30 Dail Database driver SETE OS AA AA eateas

Expert Tools - User's Guide

Contents

Download Pdf Manuals

Related Search

Related Contents