Skip to content

Visualization

The semantic visualization provides a graphical representation of the model, displaying query tables as interconnected nodes with their respective dimensions and measures. The goal is to help users understand the structure and relationships within their semantic data model.

Node Structure

Each node in the visualization represents a query table in your data model. The node displays the table name as a header and contains two main sections below it.

Node Header

Each table node includes a + (plus) icon in the top-right corner that provides quick access to add new elements to the table, with options to:

  • Add Custom Measure: Create a new custom measure for this table
  • Add Join Relationship: Establish a new join relationship with another table
  • Add Alias: Create an alias for this table

Screenshot

When you click any of these options, a side modal opens with the relevant form fields. Fields marked with an asterisk (*) are required and must be completed before saving.

Node Content

The contents of a node are divided into dimensions and measures:

  1. Dimension Section
    • Header: "Dimension" (blue background)
    • Contains all dimensional columns from the table
    • Shows the display name of each column
    • Represents categorical or descriptive data used for grouping and filtering
  2. Measures Section
    • Header: "Measures" (blue background)
    • Combines both simple measures and custom measures in a single section
    • Shows the measure name for each entry
    • Represents numerical data used for calculations and aggregations

For detailed information, refer to dimensions, simple measures, and custom measures.

Editing Nodes

Clicking any item in the dimension or measure section opens a side modal to view or edit that item.

Screenshot

By default, the modal opens in read-only mode and displays different information depending on the item type.

For Dimensions:

  • Column: The actual column name from the database
  • Data Type: The data type of the column (e.g., Text, Number, Date)
  • Display Name: The user-friendly name shown in the visualization
  • Value Type: Classification of the column (e.g., Description, Measure, Key)
  • Ontology: Semantic classification if applicable
  • Sample Values: Preview of actual data values from the column

For Simple Measures:

  • Measure: The actual measure name from the database
  • Aspect: The business context or category (e.g., COST, REVENUE)
  • Currency: Currency type if applicable
  • Precision: Number of decimal places for display
  • Disabled Aggregator: Aggregation functions that are disabled for this measure
  • Alternate: Alternative measure name
  • Alias: Alternative display name for the measure

For Custom Measures:

  • Aspect Name: The business context or category (e.g., UNIT, COST, REVENUE) — required
  • Currency: Currency type if applicable
  • Precision: Number of decimal places for display
  • Expression: The custom calculation formula/logic — required
  • Measure Name: The display name for the custom measure — required
  • Alias: Alternative display name for the measure
  • Expression Status: Current status of the expression (e.g., ACCEPTED, PENDING)

To edit, click the Edit button (pencil icon). Fields that are greyed out are read-only and cannot be modified.

Relationships (Edges)

Edges (connecting lines) between nodes represent join relationships between tables. The presence or absence of edges indicates the following:

  • Connected Tables: Tables with join relationships have connecting edges
  • Isolated Tables: Tables without joins have no connecting edges to other tables

Join Status

Join relationships are indicated by line type:

  • Dotted Lines: Pending join status
  • Solid Lines: Accepted join status

Each edge also displays a join type label (e.g., left join, inner join). Hovering over the label shows detailed join information, including:

  • Join Type: The type of join relationship (e.g., Inner Join, Left Join)
  • Primary Key: The primary key column from the source table
  • Foreign Key: The foreign key column from the target table
  • Status: Current join status (Pending or Accepted)

Screenshot

The join status legend is also shown in the top-right corner of the visualization.

Editing Joins

Clicking a join type label or an edge directly opens a side modal for viewing and editing the join relationship details.

Screenshot

By default, the modal opens in read-only mode. Click the Edit button in the bottom right to enable editing. Fields that are not greyed out can be modified; greyed-out fields are read-only.

Search & Explore

The top-right corner of the visualization includes a search feature to quickly locate specific elements in the semantic model.

Search Capabilities:

  • Table Names: Search for any table in your semantic model
  • Column Display Names: Search for specific columns using their display names across all tables
  • Auto-Navigation: Clicking any search result automatically scrolls and zooms to the corresponding element
  • Visual Focus: The target node or column is highlighted for easy identification

Search Behavior:

  • Table Results: Clicking a table name centers and highlights the entire table node
  • Column Results: Clicking a column name navigates to the parent table and highlights the specific column
  • Dynamic Results: Results update as you type for instant feedback

Zoom & Pan

The bottom-right corner of the visualization includes zooming and panning controls.

  • Zoom in/out controls available in the bottom-right corner
  • Use mouse controls to zoom in/out and pan across the visualization
  • Search results automatically adjust the zoom level for optimal viewing

Training Required

Changes to the semantic model take effect only after re-training. Re-train the database to apply updates and improve query accuracy.