BI Model

Latest Update： Jul 18, 2023 , 13:58:38

Overview

BI model is a model designed to facilitate complex queries and advanced statistics through SQL query methods. Users can directly develop using SQL statements within the model, complete the required data analysis, and then return it to the front-end interface through the model:

The model settings provide specific configuration options that allow SQL to be written based on the actual business requirements.

Once the SQL writing is completed, you can click the "Parse" button to perform a trial run. If the SQL statement is executed correctly, it will return data results (default 10 rows).

Data Model

The data model label can display information about the fields that the current data model can return.

Field Name：This is the name of the field that will be displayed when the current model is called on the page. Field Identifier：This represents the actual name of the field. Is Primary Key：Single choice, when selecting this field as the primary key, it indicates that this field contains unique values and can be used for passing values and conducting queries.

Parameters

Parameters are built-in features in the BI model that allow for changing query conditions:

Parameter Name: The name of the parameter.

Parameter Identifier: The specific name of the parameter.

Parameter Value: The default value of the parameter. When no parameter is provided, the parameter uses this default value to concatenate the SQL statement.

Required: Indicates whether the parameter must be provided when calling the model method. If it is required, the parameter must be included.