|Populating the Worksheet||Refining the Worksheet, Categorizing and Reporting|
This chapter contains the fourth in a set of five tutorials, which together give a tour of EuroSmart. This tutorial shows how to customize the analysis tools and their settings.
This tutorial shows how to customize the analysis tools to look for the monetary elements that are peculiar to the Order project. Every application has its own peculiarities and you need to get to know your application, so that you can establish the settings and tools that will produce the most relevant assessment of where changes are required. This tutorial:
We recommend that you spend some time initially establishing the tools and settings appropriate to your application. You do this as part of your initial analysis, by selecting individual programs and files in your project and investigating them and determining the best way to analyze them. Later, when you have the tools and settings established, you can analyze the whole application in earnest.
In this tutorial, you:
This tutorial takes about 30 minutes.
This section explains how to open the appropriate worksheet for the Order project.
If you are continuing immediately from the last tutorial, you need to reload the worksheet for the Order project, as follows:
Click Load from File and select the Order.mdb.
If you stopped following the tutorials, to experiment independently or to close down EuroSmart, start this tutorial as follows:
If you have already started this tutorial and now want to restart it, you need to reopen the backup worksheet that you made at the end of the previous tutorial. To do this:
Depending on how you have Windows set up, the worksheet names are displayed with or without the .mdb extension.
Now, you can work on the project worksheet Order.mdb, and leave the backup EndofChap7.mdb intact in case you need it again.
The default settings for the analysis tools are supplied with EuroSmart. When you first install you choose a country, so that the default settings appropriate to that country are applied. However you can change to another country's settings later, using the Country option on the Euro menu.
You can customize the settings and create your own versions of them. You can then choose between your customized settings and the default settings.
The new group of settings will contain settings for all the countries. At the moment, we are just configuring the settings for United Kingdom, but all the other countries' settings are copied unchanged from the Defaults group into the new Order group.
Click OK and then click Next.
Click any of the tools to toggle its selection and the highlighting.
Note: deselecting a tool means that no settings will be defined for that tool.
The settings you specified are saved in the Order group of settings for the United Kingdom.
Notice that the status bar at the bottom of Analysis Tools now shows Settings: Order\United Kingdom.
The settings you have specified for these tools remain intact even if you close down the product.
If you are working in a group, you might all want to use the same settings, so that the results from your analysis are consistent and reproducible. If one user develops some improved settings, you might all want to adopt those settings.
Currently, the facilities for sharing settings are limited. However you can copy files from one user's PC to another.
This section describes how to copy customized settings to another PC.
Now, if you look on the other PC and go to Country on the Euro menu, the Order group of settings will be available.
In some situations, you need both positive and negative settings for a tool. For example, you might want settings that find unwanted data items so that you can remove them from the worksheet, and you might want other settings that find genuine points of interest so that you can add them to the worksheet. You can create search criteria files for any tools that have an Import button, and then you can import the criteria when you run the tool.
This section describes how to create a file of search criteria for the Names of data items tool.
Notice that each setting is typed exactly as it would be in the dialog for the analysis tool, except that case is not significant.
The resulting set contains 39 data items with monetary names. Notice that many of the items are gray indicating that they are already in the worksheet. The only items that aren't in the worksheet are related to BMS screen fields and if you examine their PICTURE clauses, you can see that they are single digit items and so don't hold monetary values.
You can store the search criteria files centrally, so that all the users in your group can use the file.
During your analysis, you might need run the same sequence of tools on several different programs or sets. You can create a tool that mimics the way you produced a set manually, which might have involved running several analysis tools, subtracting or intersecting sets, and running further tools.
The new tool is known as a composite tool and comprises the sequence of tools together with their settings that you used manually. The new tool appears on the analysis tools list, from where you can run the new tool and automatically produce sets in the same way as the manually produced set.
This section explains how to capture the process used to generate the "Monetary constants" set, and to create a composite tool "Find monetary constants".
The resulting set contains 60 items, which is the same as the first time you produced this set manually. You might expect the number to be different because you changed the default settings with the Configuration wizard. However, a composite tool always adopts the settings used to produce the previously created set.
You now have a composite tool made from an audit trail, and you can run this tool on other programs to repeat exactly the same process.
When you are developing tools, you might need to change part of it without recreating it from scratch again, perhaps to adopt some new settings.
We recommend that you finish developing and refining tools on a selection of source files before you go on to do the full analysis. The problem is that if you change a composite tool half way through your full analysis, your later audit trails will refer to the same tool as the earlier audit trails, but the settings will be different. This gives the potential for confusion.
This section shows how to edit the new tool Find monetary constants so that it uses the settings that you configured for the Names of data items tool, and to include an additional data item name.
The resulting set has 45 entries, and not the 60 originally produced
from this composite tool. The difference of 15 represents 6 data items
*code* in their names, and 9 statements that use
those data items. The last tutorial investigates this further.
Currently, facilities for sharing composite tools are limited. All your composite tools are stored in one file and there is currently no way to merge your tool file with anyone else's.
To work round this problem, one person needs to maintain the master tool file, and be responsible for distributing updated versions to the users. We suggest you nominate someone, such as a team leader, to be administrator. The administrator then does most of the investigation and creation of new tools, and also owns the master composite tool file.
If a user develops a new tool, there is currently no way to pass that tool to the administrator for merging. The user needs to explain or demonstrate the process to the administrator, so that the administrator can mimic the process manually. The administrator can then capture the new composite tool, so that it is recorded in the master composite tool file.
The file containing the composite tools is Toolcomp.dat and is located in the project directory, which is Projects\Order for the tutorials. Note that this file is saved automatically when you close down EuroSmart, but not until then.
When the administrator has updated the master file, everyone needs to copy it into their project directory.
The worksheet is persistent and is continually saved, and so it is automatically up to date if you shut down.
However, it is good practice to save a backup of the worksheet, so that you can go back to a previous copy.
If you already have a backup with this name, give a new name such as EndofChap8-1.mdb.
You can close EuroSmart, if you want to stop for now. You can then continue with the next tutorial some other time.
Copyright © 1998 Micro Focus Limited. All rights reserved.
This document and the proprietary marks and names used herein are protected by international law.
|Populating the Worksheet||Refining the Worksheet, Categorizing and Reporting|