1. Home
  2. Other Releases
  3. On-premises 5.1
  4. Guides
  5. Tours
  6. Concepts
  7. Tools
    1. Alert Editor
    2. Alias Sync Tool
    3. Analyzer
    4. Apache Parquet Merge Tool
    5. Avro Extractor Tool
    6. Business Schema Designer
    7. Business Schema Manager
    8. Cluster Management Console
    9. Command Line Interface
    10. Content Manager
    11. Dashboard Filters Manager
    12. Data Agent
    13. Data APIs for External Notebooks
    14. Data Manager
    15. Formula Builder
    16. Formula Validation Tool
    17. Inspector Tool
    18. Join Editor
    19. Load Job Viewer
    20. Model Update Viewer
    21. Notebook Editor
    22. Profile Manager
    23. Public API
    24. Query Plan Viewer
    25. Scheduler
    26. Schema Designer
    27. Schema Diagram Viewer
    28. Schema Manager
    29. Schema Wizard
    30. Security Manager
    31. Table Editor
    32. Tenant Management Tool
    33. Versioning Migration Tool
  8. References
  9. Integrations
  10. Data applications
  11. Releases

Tools → Query Plan Viewer

About the Query Plan Viewer

The Query Plan Viewer allows a tenant user to view the direct data map path that the Incorta Analytics Service uses to retrieve or calculate a measure in an Incorta Analyzer table, Incorta View, an Insight, or while exploring data for a physical schema or a business schema.

Query Plan Viewer access rights

A user that has the right to the Analyzer. For more information, refer to Analyzer.

To access the Query Plan Viewer, in the Analyzer, in the Measure tray, select > for a pill. In the Measure pill properties under Advanced, select Query Plan.

Query Plan Viewer Anatomy

The Query Plan Viewer consists of the following:

  • Action bar
  • Diagram canvas

Action bar

The Action bar consists of:

  • A maximize button (diverging arrows icon) that you can select to maximize the window of the Query Plan Viewer.
  • A minimize button (converging arrows icon) that you can select to minimize the window of the Query Plan Viewer.
  • An X that you can select to close the Query Plan Viewer.

Diagram canvas

The Diagram canvas shows the Direct Data Map path diagram which contains the following:

  • The name of the physical schema or business schema of each object in the Query Plan
  • Base table, which refers to the driving object in the join path
  • Schema objects
  • Join arrows, if any

In the Query Plan Viewer, you can view the physical schema entity objects you are using and their relationships, or joins, between the objects as an arrow, and the base table. The arrow source represents the child table, and the target represents the parent table.

The base table that specifies how Incorta joins two schema entities.

Note

You can join two physical schema entity objects that are not directly joined (i.e. the tables that do not share a common dimension) by dragging and dropping a column from a transactional table into the Base Field.

There is a key at the bottom of the query plan viewer that indicates the entity type by color. Here are the entity types, and corresponding colors:

  • Table - blue
  • Materialized View - green
  • Alias table - red
  • Incorta Analyzer table - orange
  • Incorta SQL table (Incorta Labs feature) - purple

Example to view the direct data map path with the Query Plan Viewer

Here is an example to view the Query Plan Viewer:

  • Sign in to the Incorta Direct Data Platform™.
  • In the Navigation bar, select Content.
  • Select a dashboard.
  • In the dashboard, edit an insight.
  • In the Measure tray, select > beside a pill.
  • In the pill properties, Advanced section, select Query Plan.