Model View

Version

Application Scenarios

In a subject, you can configure the model relationship of tables within the subject. After configuration, you can select fields from multiple tables in the component.

Functions

Click  to go to the setting interface of subject model in the Data tab. You can set the model relationship between tables by dragging and dropping.

Notes

Limits of configuring a model relationship:

There cannot be a model relationship between a direct dataset and an extract dataset.

If a direct dataset comes from different data connections, then no model relationship can be established between them.

Only when a direct dataset comes from a direct databases supporting integrated analysis with Excel, can it establish a model relationship with the Excel dataset, otherwise it cannot.

Create a subject and add data into it.

In this subject, both extract data and real-time data are added simultaneously. 

Click .

Extract tables are displayed in blue and direct tables are displayed in purple.

Establishing Model Relationship

Drag a table into the table that needs to configure the subject relationship, and you can generate the connection and configure the model relationship.

For example, the field Brand Code is in both the table Brand Dimension and the table Store Sales Statistics. Therefore, you can establish the model relationship between them.

Drag the table Brand Dimension into the table Store Sales Statistics to generate relationship.

After you have established the connection, the Edit Relationship interface will automatically pop up. You can modify Match field and Model Relationship.

Match field:

It is the link between two tables that are connected. If both tables have the field Brand Code, then it is the link that establishes the connection.

The type of the matching fields in two tables needs to be the same.

Model Relationship:

The system will provide suggestions for model relationships based on your data. For a better performance, you should try to choose the correct model relationship as much as possible.

A brand corresponds to multiple sales details, so the relationship between the table Store Sales Statistics and the table Brand Dimension is N:1.

The system also provides matching prompts. You can directly make changes according to the prompts.After modification, the prompt will disappear.

You can establish model relationship for other tables with the same method.

Since extract dataset cannot establish model relationship with direct dataset,you need to establish model relationship within extract tables or within direct tables.

Deleting Model Relationship

Method One: Right-click the connection corresponding to the model relationship to be deleted.

Method Two: Select the model relationship to be deleted and delete it in the editing area on the right.

Selecting Fields from Multiple Tables After Establishing Model Relationship

After establishing model relationship, you can drag the fields of these two tables into the component for analysis.

You can also use fields from these two tables to create a new calculation field. For details, see Overview of To-Be-Analyzed Area Settings.

Viewing Table Information

When you select a table in the model view, the corresponding data information will appear on the right side.

Click  > Edit data to directly go to the editing interface.