Design Graph

The Design Graph is the visual workspace in the Data Model Designer where you define which tables and views are included in a data model and how they are linked. From the Design Graph, you can add or remove tables, set the fact table, create joins, and preview how they interact. This section provides links to related tasks and features.

In this section:

Topic	Description
Add tables or views	Add tables or views from the configured data source to the design graph. Select the objects you need for your data model and place them in the workspace.
Determine the fact table	Set the table whose records always appear in query results, even when there are no matching rows in joined tables.
Delete a table	Remove a table from the design graph when it is no longer needed in the data model.
Join tables	Create relationships between fields in different tables. Choose join types to control which records are returned.
Show SQL statement	Display the SQL code generated by the data model, including selected fields, tables, and joins. Use it to understand or troubleshoot query logic.