Report Menu

The Report Menu has the following options: -

View All Standard Reports

Run Reports

Create Adhoc Report

Remove All Adhoc Reports

Report Options

    View All Standard Reports

This menu choice will run or remove all Standard Reports

    Run Standard Reports

This sub menu lists categories of Standard Reports which are available, the categories are

    Standard Reports

The Standard Reports that can be run against the Saved Database Batch File to aid in the analysis.   Once a report is run it will add an item to the database View that will allow you view the structures that have been found by the reports criteria which are set in the Report Options.

 As well as the standard reports you may run adhoc reports.

The table below details the different types of reports that may be run

Icon	Report type	Description	Applicable to	Indicates
	Adhoc Report	Report Specific	Report specific
	Populations	Datasets with Record Populations above the Population % Limit of the Maximum Record Population	Datasets	Potential Population Limit error on running database.  Included in Enterprise view
	Populations	Structures which have no data in them	All Structures	Potential Redundant Data Structures
	Populations	Structures with number of Areas above 800	All Structures	Potential Population Limit error on running database.  Included in Enterprise view
	Populations	Structures with number of Areas above the Population % Limit of Maximum Areas	All Structures	Potential Population Limit error on running database.  Included in Enterprise view
	DK Tables	Datasets with number of DK entries above the DK Table Entries Limit	Datasets	Dataset that would potentially benefit from garbage collection
	DK Tables	Datasets with number of DK entries above 50% of the Actual Population	Datasets	Dataset that would potentially benefit from garbage collection
	Set Level Depth	Sets with levels of tables above the Set Levels Limit	Sets	Sets that require excessive IO activity.  Included in Enterprise view
	Set Level Depth	Sets with levels of tables equal to the Maximum Levels	Sets	Sets that require excessive IO activity and liable to halting the database if DMS attempts to exceed the maximum levels.  Included in Enterprise view
	Root Table Entries	Sets with the number of Root Table entries above the Population % Limit of Root Table Entries	Sets	Potential Sets that are.  Included in Enterprise view
	File Information	Structures with Total File Size above the File Size Limit	All Structures	Large Structures
	File Information	Individual Files with File Size above the File Size Limit	All Structures	Large Structures
	File Information	Files which have not been updated for over a year.	All Structures	Potential Redundant Data Structures
	Wasted Space	Datasets with blocks with wasted words per block over the Wasted Space Word limit.	Datasets	Datasets which may benefit from having the structures physical attributes changed to reduce the amount of wasted space.
	Wasted Space	Structures where the total amount of wastage in the file is over the Wasted Space % limit	All Structures	Structures which may benefit from having the structures physical attributes changed to reduce the amount of wasted space.
	Wasted Space	Datasets where the total amount of wastage in the File is over the Wasted Space File limit*	Datasets	Datasets which may benefit from having the structures physical attributes changed to reduce the amount of wasted space.
	Wasted Space	Sets where the total amount of wastage in the File is over the Wasted Space File limit*	Sets	Sets which may benefit from having the structures physical attributes changed to reduce the amount of wasted space.
	Wasted Space	Structures where the total actual loadfactor in the file is less than the Wasted Space % limit	All Structures	Structures which may benefit from having the structures physical attributes changed to reduce the amount of wasted space.
	Dynamic Attributes	Dataset Maximum Memory Utilisation	Datasets
	Dynamic Attributes	Set Memory Maximum Memory Utilisation	Sets
	Dynamic Attributes	Datasets with a Reblockfactor = 1	Datasets	Potentially performance degrading Reblockfactor
	DASDL Attributes	Datasets with the number of wasted words per block greater than the record size.	Datasets	Structures which may benefit from having the structures physical attributes changed to reduce the amount of wasted space.
	DASDL Attributes	Sets with the number of wasted words per table greater than the key size.	Sets	Structures which may benefit from having the structures physical attributes changed to reduce the amount of wasted space.
	DASDL Attributes	Datasets with Area Size = 1 Block	Datasets	Just odd
	DASDL Attributes	Datasets with Block Size = 1 Record	Datasets	Just odd
	Description File and Control File Comparison	Structures with differences between the Description File and Control File values for the following attributes:- Maximum Areas Family Buffer Specifications Reblock Reblockfactor Population Warning attributes Population Increase attributes	All Structures	Potential changes to Database when next compiled.

    Creating Adhoc Reports

The Adhoc Report form allows you create your own Adhoc reports against your database, it is initiated by clicking on the Adhoc report button on the toolbar.  You have all the Database and Structure Attributes available with the option to compare to your defined values.  Once the report is defined it will be processed and included in the end Adhoc Reports node.  

Run Report Against - This selects which structures you want to run the report against.  The default is to run against all structures that fit your report criteria.  Alternatively you may select a previous run report as the basis for your new report, this will mean that only structures reported in the previous run will be considered in the new run.  Through this method of combining report criteria you are able to complete complex selection criteria.

Include - Allows you choose to report against all structures, Datasets only or Sets only.  This field is automatically changed when the Data item selected can only be executed against Datasets or Sets.

Where - Allows you to define the criteria for the structures that you wish to report against. These include:-

Data Item Name - One of the attributes that Virtual Analyser captures
Relation - context sensitive to the type of data to be reported
Value - Value to used as the selection criteria
Include Null and Zero Values - Whether or not you wish to include null or zero values in your output

Sorted - Allows you to define if the Output should be Ascending or Descending

    Saving Adhoc Reports

Once you have created your report you may save it so that it may be run again in the future.  By selecting the Save Report check box you are able to add a comment to the report.  You are then also given options to Save the Report or Save and Run the report.

Rerunning Adhoc Reports

To rerun an existing report you initiate the Adhoc Report Dialogue and click the Show Saved Report Button.  This will then list all the saved reports in the descending order that they were defined.  To run a specific report select the report and Click the Load Report button.  This takes you to the report creation view where you may execute it.

    Removing Adhoc Reports

You are able to remove Adhoc reports from the Database View by one of two methods. 

The first is to select the 'Remove All Adhoc Reports' menu choice which removes all the Adhoc Reports from the Database View.

Alternatively you may select individual reports in the Database View and click the delete button on the toolbar.

    Report Options

This form allows you to select the values that will be used by the Standard Reports as parameters when they are initiated.

The values which can be changed are:-

Icon	Label	Description
	Population % Limit
	DK Entries Limit
	Set Levels Limit
	Root Table % Limit
	File Size Sector Limit
	Wasted Space Word Limit
	Wasted Space % Limit
	* Wasted File Space limit	Derived from File Size Sector Limit * Wasted Space % Limit

The Set Defaults button will revert the attribute values to the Defaults
 

    Reports Defaults

The Default Report Options are:-