|Customizing the Analysis Tools|
This chapter contains the last of the five tutorials, which together give a tour of EuroSmart. This tutorial describes some more analysis tools. It explains how to set categories and to produce some useful reports.
The target for this euro analysis is for all the monetary points of interest to be captured in the worksheet and for each entry to be assigned definite categories.
We have now completed the assessment related to monetary constants.
Although the earlier tutorials have given a flavor of the tools, the process followed is not complete. We have not yet explored all the necessary areas. There are also several other types of analysis that we need to perform to cover all the potential aspects of the application that may be impacted depending on the characteristics of your particular application.
For the areas we have examined, we have not yet looked at every point of interest to validate if a change to the code is required and to categorize the point of interest if a change is required.
In this tutorial you refine the worksheet, removing some unwanted data items and identifying some additional points of interest. You also update the categories of the worksheet entries, and produce some reports. 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 previous tutorial, you need to reload the default worksheet for the Order project.
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:
Now, you can work on the project worksheet Order.mdb, and leave the backup EndofChap8.mdb intact in case you need it again.
The worksheet very quickly fills with a tremendous numbers of entries, making it difficult to focus on the entries you are interested it. To solve this problem, you can filter the worksheet based on a wide range of attributes and show the subset of entries that you are interested in at a particular time.
This section shows how to filter the worksheet to display just a subset of entries.
The worksheet still has 72 data items, but it is now filtered and shows
just 8 data items that have
CODE in their names. Notice that
Filtered in the information bar shows that 8 items are filtered.
Since some these data items with
CODE in the name are
unlikely to be monetary, they need removing. We assume for now that they
all need removing.
CODEdata items and click Remove from List.
Although the worksheet appears empty, notice that the count in the information bar shows that 64 data items remain in the worksheet and 8 data items are removed.
To review the removed list, click Display Filters and clear *code* from the first field.. Check Show removed candidates only at the bottom and click OK.
Notice that Filtered is checked in the information bar once again, and that 8 items are in this filtered list, which is the same as the removed list.
To do this, select the two data items and click Remove from List again. Click Yes to confirm reinstating the data items.
Now the worksheet contains 6 removed data items and 66 remain in the worksheet.
Now, when you subsequently add a set to the worksheet, if the set
contains any of those removed
*CODE* data items, they
won't be re-added to the worksheet, but will stay as removed.
The worksheet now contains 66 data items and 6 removed.
As well as adding items that might be of interest to the worksheet, you can exclude items that are definitely not of interest. Then, whenever you subsequently add sets, any items that definitely aren't monetary, don't get added.
To do this, you create a complete set of items that definitely aren't monetary and add these directly to the removed list of the worksheet.
This set contains 41 data items.
Notice that 47 data items are removed, but 66 still remain. None of the existing items was actually removed. All the newly removed items came from the excluded set and have been added directly into the removed list..
To do this, click Display Filters, clear all the fields and check Show removed candidates only. Click OK.
Now, any subsequent operations to add sets to the worksheet automatically exclude these items, because they are already in the removed list.
The worksheet contains 66 data items and 47 removed.
In the same way as you can channel a set into the worksheet, you can channel entries the other way, from the worksheet into a set. This can be useful if you want to manipulate a set of worksheet entries to find related points of interest.
The resulting set has 71 data items and its title is "Worksheet channel".
Another way of making a set is to drag worksheet entries onto an analysis tool. This is quick but has drawbacks since you lose the audit trail, and so it is useful mainly in the early stages when you investigating which settings and tools are going to be appropriate for your application.
As a final check, there are several other types of analysis that might uncover new potential impacts on the application. For example, a monetary data item might impact the application through the statements involving that data item and also through the other data items in those statements.
In this section, you explore two analysis tools that might be useful is the final stages when double checking for impacted points of interest.
The resulting set has 116 statements, some of which already exist in the worksheet, which you can see because they are grey.
The worksheet now contains 138 statements (74 plus 64 new ones).
Note that Data trace can take a considerable time to run on large projects, so allow plenty of time and perhaps run it overnight, or even restrict the scope of programs on which the tool runs.
The worksheet now contains 138 statements.
As you investigate the application further, you need to record your analysis and your decisions. Part of this entails categorizing worksheet entries according to how definite you are that each is monetary, what sort of problem they are and what sort of code modification each one needs.
You can categorize points of interest in any way that suits your organization or the application. Although EuroSmart comes with a set of categories, you are free to create your own using Edit Categories. This is available as an administration function only, to enable you to provide a defined set of categories for your work group so that everyone categorizes consistently.
There are three types of category:
This section adds the categories of worksheet entries.
This section shows how to produce a range of reports on the final worksheet, giving details of every point of interest, every file, every category, or whatever you require.
When you have found all the points of interest in your application, you are ready to modify the code, and to compile and test the modifications. You do this in your preferred development tool.
If you use Micro Focus Mainframe Express as your development tool, you can import the points of interest from EuroSmart, so that they are highlighted in the code ready for you to edit.
This section shows how to export the points of interest from the worksheet, so that you can import them into Mainframe Express and use them to identify the lines of code that need modifying.
|Customizing the Analysis Tools|