Query Plan is a feature that can be used to show the relationship between the tables used within an Insight in an Entity Relationship Diagram (ERD). The diagram can be accessed from the measure elements only, i.e. elements in the “measure” field.
To access the ERD of the elements used within an Insight:
- Navigate to any Insight.
- Select the three vertical dots in the upper right-hand corner of any Insight. The Insight opens in Analyzer mode.
- Select the down arrow of the element in the “measure” field.
- Select the “Advanced” tab.
- Select Query Plan. A window opens showing the relationship between the tables used by this Insight. In this case, it shows that the SALES table (containing the “Revenue” column) is joined with the PRODUCTS table (containing the “Category” column). The SALES table is also joined with the CUSTOMERS table, which is joined with the COUNTRIES table (containing the “Country” column).