When you click Export to Excel in the Impact Analysis section, Rapid BI Catalog generates and downloads a timestamped .xlsx file named Impact_Analysis_<date>_<time>.xlsx. The file contains two sheets: Summary and Impacted Objects.
Sheet 1: Summary
The Summary sheet gives a high-level count of every Tableau object type impacted by your selection.
| Column | Description |
|---|---|
| Object Type | The category of Tableau object |
| Count | Number of distinct objects of that type impacted |
Row Order
Rows always appear in the following fixed order:
| Object Type |
|---|
| Tableau Data Sources |
| Tableau Data Source Tables |
| Tableau Data Source Fields |
| Calculated Fields |
| Sets |
| Groups |
| Bins |
| Hierarchies |
| Workbooks |
| Worksheets |
| Dashboards |
| Storyboards |
| Total |
Sheet 2: Impacted Objects
The Impacted Objects sheet provides the full detail — one row per impacted object per dependency path. A single object (e.g., a Worksheet that uses fields from two different Tableau Data Sources) may appear on multiple rows, with each row representing a distinct path through the dependency graph.
Columns
| # | Column Name | Description |
|---|---|---|
| 1 | Searched Object Name | The name of the data asset you searched for, at the level you selected in the filters |
| 2 | Searched Object Type | The type of the searched asset: Connection, Database, Table, or Field |
| 3 | Data Connection Name | The source data connection that contains the searched asset |
| 4 | Database Name | The source database within that connection |
| 5 | Table Name | The source table within that database |
| 6 | Field Name | The specific source field (populated only when filters were set to Field level) |
| 7 | Tableau Server/Cloud | The Tableau Server or Tableau Cloud connection the workbook belongs to |
| 8 | Site | The Tableau site that contains the workbook |
| 9 | Project | The Tableau project that contains the workbook |
| 10 | Workbook Name | The Tableau Workbook containing the impacted object |
| 11 | Tableau Data Source Name | The Tableau Data Source (inside the workbook) through which the dependency flows |
| 12 | Tableau Data Source Table Name | The table inside the Tableau Data Source |
| 13 | Impacted Object Name | The name of the specific impacted object |
| 14 | Impacted Object Type | The type of the impacted object (see table below) |
| 15 | Built From Object Name | The immediate upstream object that this impacted object depends on |
| 16 | Built From Object Type | The type of that upstream object |
Possible Values for "Impacted Object Type"
| Value | What it represents |
|---|---|
| Field | A Tableau Data Source field |
| Calculated Field | A custom calculated field |
| Set | A Tableau Set |
| Group | A Tableau Group |
| Bin | A Tableau Bin |
| Hierarchy | A Tableau Hierarchy |
| Worksheet | A worksheet within a workbook |
| Dashboard | A dashboard within a workbook |
| Storyboard | A storyboard within a workbook |
Note: Workbooks (column #10), Tableau Data Sources (#11), and Tableau Data Source Tables (#12) exist as their own columns, not as Impacted Object Type values.
Header Row Behaviour
- The header row is frozen — it remains visible as you scroll down through large result sets.
- Auto-filter dropdowns are enabled on every column, allowing you to filter and sort directly within Excel.
Understanding "Built From" Columns (15–16)
The Built From Object Name and Built From Object Type identify the immediate upstream dependency in Tableau — the object that the impacted object is directly derived from or depends on.
| Impacted object | Built From example |
|---|---|
| Calculated Field | The field it references |
| Set | The Field that defines set membership |
| Hierarchy | One member field per row (a 3-member hierarchy generates 3 rows) |
| Worksheet | The upstream field or Calculated Field used in the view |
Row Sorting
Rows in the Impacted Objects sheet are sorted in the following priority order (all alphabetical, case-insensitive):
- Searched Object Name
- Impacted Object Type
- Impacted Object Name
- Built From Object Type
- Built From Object Name
Starter Plan (File-Level) — Reduced Column Set
On the Starter plan (file-level granularity), the Impacted Objects sheet is simplified — object-level columns require the Professional or Enterprise plan. The following columns are not shown:
- Tableau Data Source Name
- Tableau Data Source Table Name
- Impacted Object Name
- Impacted Object Type
- Built From Object Name
- Built From Object Type
Only the Searched Object columns (1–2), source hierarchy columns (3–6), the Tableau Server/Cloud, Site, and Project columns (7–9), and Workbook Name (10) are shown.
Next Steps
- Explore dependencies visually: Lineage & Impact Analysis