Impact Assessment extracts & reports
There are several types of impact assessment reports and extracts that you can use:
Impacted assets
Impacted users
Impacted asset by user
Detailed lineage
Impacted assets
Available on the impacted asset tab.
Select the download button to download the results
Note: The download is based on the filters and columns added to the tab. Add more columns to the table to include it in the download.
Impacted users
Similar to impacted users, select the impacted users tab and click on the download button to downloaded the impacted users
Impacted asset by user
This export provides a JSON structured file that includes all users of an impacted asset.
See below instructions for how to flatten this JSON file using Excel
Select the actions button in the top right corner
Select impacted asset by user export
Detailed lineage
This export provides the source and target mapping between each asset in the impact assessment.
Select the actions button in the top right corner
Select detailed lineage report
Appendix: Flattening JSON using Excel
Step 1) Load the JSON into Power Query
Open Excel. Click on the Data tab.
Click Get Data → From File → From JSON.
Select your .json file downloaded from Impact Assessment extracts & reports | Impacted-asset-by-user
Power Query will load and display the hierarchical JSON structure.
Step 2) Inspect the Structure
Power Query shows the JSON data in a nested format. You might see columns containing: Records (for nested objects) and Tables (for nested arrays)
Go to the Transform Tab. Click on Convert to Table
You’ll need to expand these to flatten the data.
Step 3) Expand Nested Records
You’ll need to expand these to flatten the data within the nesting.
Click the small expand icon next to the column containing a Record.
Select the fields you want to extract to a row.
Click OK.
Repeat the above step if the newly expanded fields still contain nested records.
Example
Before
After
Step 4) Remove/Filter Unnecessary Columns
Once flattened, delete any redundant columns to clean up your dataset.
Step 5) Load to Excel
When you're done, click Close & Load to bring the data into your Excel sheet
