<Overview> <OpenRep> <Main> <CompRep>
The OpenDef worksheet assist you in maintaining the CSV data
files which are included in the workbook. The CSV files are listed on the
worksheet with
the sheet name
,
information how many data rows are contained on the sheet
,
a description of the data
and the source file name
. The description must be typed in by the user
of the workbook. If the workbook is generated from the “Generic Reports”
spreadsheet the first CSV file is named “Initial CSV Report” and it is
suggested to give it a more meaningful name.
The worksheet contains the following commands:
Open New Report: presents a file dialog
and lets you select a CSV file. The drop down list below the “Open New Report “
button:
helps you to define how the columns are
converted into the workbook. The default is that Excel will automatically
determine whether a column contains numbers, dates, times or strings. But in
some cases the interpretation of numbers and strings is misleading. For that
purpose it is possible to set the column fix to be included as a string. The
drop down list provides some examples for CSV files which are generated by the
z/OS AVTEST tool set. The report which is probably most often generated and
which needs some special treatment is the “LPAR Activity Report”. If you
process this report select the respective entry.
In cases where you process SMF data which is not supported
by any of the pre-defined reports and for which the “Default” does not provide
a meaningful column you can define your own mapping. For this purpose select
the entry of the drop-down list and use the
worksheet to define
the mapping. The most likely reason for using a special column mapping is for
hexa-decimal numbers. Because some hexa-decimal numbers contain letter the
value is automatically interpreted as a string and those which do not are
interpreted as integer numbers. This is often very confusing and it is advised
to include such columns completely as string values.
Load for Reporting
is a drop-down box which allows to select the report from which charts can be
generated. The selected report is used on the Main and CompRep worksheets. The
drop-down list is also available on these worksheets. The selected CSV data
sheet is marked with an orange bar
in the CSV table.
Delete CSV Report helps you to delete a
CSV data sheet and all of its related charts. In order to delete a CSV data
file you MUST place the cursor on the row of the CSV report in table
.
If the the cursor is misplaced or if the row does not contain a valid CSV data
sheet description a message is shown that nothing will take place:
If the row contains a valid report, the report name is displayed and a confirmation to continue is requested. For example if you placed the cursor into the row of CSVREP01 the following message is displayed:
If you answer with “Yes” the report and all of its dependent
charts are removed from the workbook. In the following example Chart_Trx1 and
Chart_RTD3 have been created from data of CSV sheet
CSVREP02. If CSVREP02 should be deleted the two charts would be deleted also.
Charts which depend on other CSVREPnn worksheets are not effected as well as
charts which depend on comparison data sheets, like Chart_Serv_4
which
depends on Data_Serv_4. Even if Data_Serv_4 has been created from columns of
CSVREP02 the data sheet and its chart remain in the workbook. The deletion of
such charts and data sheets must be done manually. If you plan to remove a
Data_ sheet make sure to also remove all of its depending Chart_ sheets because
otherwise unresolved references remain in the workbook.
Create a copy of the workbook allows to create
a completely new spreadsheet which contains all the content of the existing
workbook. You can then delete and add CSV files as you wish.