Model View

Version

Application Scenarios

In a subject, you can configure the model relationship of tables within the subject. Subject model configuration can facilitate multi-table analysis.

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.

Generating Model Relationship

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

Editing Model 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 select the most suitable model association based on your data. Considering performance impacts, you are advised to select correct model associations.

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

Setting Other Tables

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.

Fields with N:N association cannot be used in the detail table

Problem

If N:N model association is created between two tables in the model view, as shown in the following figure.

An error message "Fields with N:N association cannot be used in the detail table." will appear when the fields of these two tables are called at the same time in a Detail Table component, as shown in the following figure. 

Solution:

Do not call cross-table fields with N:N model association in a Detail Table component.