Work with Relational Models - Quick BI - Alibaba Cloud Documentation Center

The Quick BI relational model is a data modeling system for multi-table joins and analysis. It addresses common issues in traditional physical modeling, such as low efficiency, poor accuracy, and limited analytical flexibility, making it ideal for multi-dimensional data analysis in complex business scenarios. This topic describes how to create a relational model.

Prerequisites

You have created a dataset. For more information, see Create a dataset.

Procedure

On the dataset creation page, double-click or drag a data table to the canvas, or use custom SQL to create a table.
After you select a data table, you can view the logical table details.
1. You can Rename the logical table.
  Alternatively, click the icon on the right side of the logical table and select Rename.
2. Select the fields to include.
3. If you no longer need the data table, click Delete.
  Alternatively, click the icon on the right side of the logical table and select Delete.
Drag another data table to the canvas and configure the join relationship.
1. Select join fields
  Select the fields to join the two tables. You can click Add Join Field to add multiple join fields.
  Note
  Only dimension fields can be used as join fields.
  Click Delete to remove a join field, or click Clear All to remove them all.
2. Advanced settings
  Click More Options to open the advanced settings pane.
  1. Join relationship
    You can configure the join relationship with a cardinality of 1:1, 1:N, N:1, or N:N. For more information, see Join relationship.
  2. Match type
    You can set the match type to partial match or full match. For more information, see Match type.
Click OK to create the join relationship.

Repeat these steps as needed to join multiple logical tables.

Note

In a relational model, each logical table can also function as a physical model. When you drag a data table to the logical canvas, its corresponding physical model is a single-table model. If you need to perform more complex physical modeling, you can open the physical canvas for the logical table. To do this, click the icon on the right side of the logical table and select Go to Physical Canvas, or simply double-click the logical table. In the physical canvas, you can configure physical joins and unions. For more information, see Joins and unions.