Exporting data to Microsoft Excel file format
You can export data to an Excel file format at the following levels:
- Risk Investigation
- Health Measures
- Business Criteria
- Technical Criteria
- Rules, Distributions and Measures
- Application Investigation, Transaction Investigation
- Action Plan
- Scheduled and Active Exclusions
If there is no data in the table, then the download icon will be disabled.
Use the following icon:
When you click this icon, depending on your browser you will be prompted whether you would like to Save or Open the Excel file. The Excel file will contain the data you requested in column format:
Notes about the exported Excel file data
Some information such as rule criticality or weight are not available in the exported data.
Variation between snapshots as a percentage is not provided, but scores/grades for both current and previous snapshot are provided.
Where a cell is blank this typically means that either the data is common to all modules (blank Module Name cell) or there are multiple Technologies (blank Technology cell).
Results are calculated by AIP at four levels and the Excel spreadsheet will display the results at each of these levels (see the four levels below). As such, when there is a single technology and a single module in the application (i.e. a full content module), depending on how the analysis is defined, the results will be identical for all the four levels (see screenshot below):
Violation level export - Associated Value data
When you export to Excel from the Violation level, a column containing a Rule's Associated Value may also be available in the resulting Excel file - in the example below, "JSP Page name" is the Associated Value for the Rule "Action Artifacts should not directly call a JSP page":
The Associated Value refers to a specific output for the Rule in question. For the Rule shown above "Action Artifacts should not directly call a JSP page", the Associated Value is defined as the JSP Page name - in other words, for this Rule, the JSP file listed in the column highlighted above violates the Rule in question. You can view the Associated Value configuration in the CAST Management Studio by opening the Assessment Model and locating the Rule: