Scorecard Export Files in Informatica Analyst
You can export scorecard results to a Microsoft Excel file. The Analyst tool saves the file in the "xlsx" format.
The exported file contains scorecard summary, trend charts, rows that are not valid, and scorecard properties.
Scorecard Export Results in Microsoft Excel
When you export the scorecard results, the Analyst tool saves the information to multiple worksheets in a Microsoft Excel file. The Analyst tool saves the file in the "xlsx" format.
The following table describes the information that appears on each worksheet in the export file:
Tab | Description |
|---|
Scorecard Summary | Summary information of the exported scorecard results. The information includes scorecard name, total number of rows for each column, number of rows that are not valid, score, and metric weight. |
Trend Chart | Trend charts for scores. |
Invalid Rows | The details of rows that are not valid for each column. |
Properties | Scorecard properties, such as name, type, description, and location. |
Exporting Scorecard Results from Informatica Analyst
You can export scorecard results to a ".xlsx" file to view the data in a file.
1. Open a scorecard.
2. Click Actions > Export Data.
The Export Data to a file dialog box appears.
3. Enter a file name. Optionally, use the default file name.
The default file format is Microsoft Excel.
4. Select the code page of the file.
5. Click OK.