Skip to main content
Skip table of contents

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

  1. Available on the impacted asset tab.

  2. 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.

image-20250521-011436.png

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

  1. Select the actions button in the top right corner

  2. Select impacted asset by user export

image-20250521-011906.png


Detailed lineage

This export provides the source and target mapping between each asset in the impact assessment.

  1. Select the actions button in the top right corner

  2. Select detailed lineage report

image-20250521-012121.png


Appendix: Flattening JSON using Excel

Step 1) Load the JSON into Power Query

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.

image-20250521-025619.png

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.

image-20250521-025824.png

  • Repeat the above step if the newly expanded fields still contain nested records.

image-20250521-030019.png

Example

image-20250521-030223.png

Before

image-20250521-030237.png

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

image-20250521-031347.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.