Model View

  • Last update:June 23, 2024
  • Overview

    Version

    FineBI VersionFunctional Change
    6.0.8/
    6.0.10

    Supported the auto-selection of recommended 

    model associations (No need to configure manually)

    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.

     1.png

    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 Excelcan it establish a model relationship with the Excel dataset, otherwise it cannot.

    Examples

    Create a subject and add data into it.

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

     2.png

    Click .

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

     3.png

    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.

     4.png

    Generating Model Relationship

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

    Animation 1.gif

    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.

     5.png

    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.

    Model Relationship

    Example

    1:1 (one-to-one)

    The relationship between a citizen and their ID number, where one person only has one ID number.

    1:N (one-to-many)

    The relationship between states and cities, where a state has many cities.

    N:1 (many-to-one)

    Multiple cities belong to one state.

    N:N (many-to-many)

    A student can choose multiple courses. A course can also have multiple students.

    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.

     6.png

    Deleting Model Relationship

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

     7.png

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

     8.png

    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.

     9.png

    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.

    10.png

    Notes

    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.

    aca446ffa6d6b7830d2909261d2e770.png

    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. 

    4f832ede958c5e506c1daa530e6e047.png

    Solution:

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

    附件列表


    主题: Adding and Editing Data
    Previous
    Next
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy