Skip to main content

Business Domain

Create a New Business Domain​

  • Enter the name of the business domain (limited to 50 characters);
  • Select the referenced data source;
  • After creation, you can enter the business domain management interface.

Add Data Tables and Relationship Modeling​

  • Add multiple business-related data tables as "business domain nodes";
  • Each node represents a table, and multiple nodes can be added;
  • Click the "Relationship List" of each table node to add associations:
    • Set the From Field (field in the current table);
    • Set the To Table and its Field (target table and target field);
    • Select the relationship type: One-to-One, One-to-Many, Many-to-One, Many-to-Many;
    • After submission, the relationship between the two tables is established.

In this way, users can build a complete data relationship network within the business domain, facilitating subsequent intelligent queries and chart generation.

Relationship Overview​

Displays all tables and their structural relationships within the business domain, making it easy for global understanding and management.

Parameterized Templates​

Supports the creation of SQL templates with parameterized variables to flexibly meet data query needs in different scenarios.

  • Parameters (such as date, department, region, etc.) can be defined in the template and inserted into SQL statements as placeholders;
  • When invoked, users can input different parameter values, and the system will automatically generate the corresponding SQL query;
  • Suitable for common queries that require flexible condition adjustments, significantly improving reusability and query efficiency;
  • Parameters can have default values and input restrictions set to ensure the accuracy and security of query results.

Example:

SELECT * FROM Sales where t1.c1 = "{value1}"
SELECT * FROM Sales where t1.c1 in ({value1})
SELECT * FROM Sales where t1.c1 like "%{value1}%"

Import and Export of Parameterized Templates​

To facilitate migration or batch deployment of query templates across different environments (such as development, testing, production), the system supports import and export of parameterized templates.

  • Implementation or delivery personnel can export multiple templates at once and quickly import them into the target system, greatly reducing repetitive configuration work;
  • Supports version management and batch updates of templates, which is beneficial for team collaboration and unified template maintenance.

Reference Templates​

Provides a series of system-predefined query templates to help users quickly understand and reuse standardized modeling methods.

  • Template examples cover common business scenarios such as sales analysis, inventory statistics, customer profiling, etc.;
  • Users can refer to the logical structure and field settings of the templates to customize models that meet their own business needs;
  • Supports copying, modifying, and saving based on reference templates to quickly build personalized data relationship models;
  • Facilitates unified data modeling standards for teams and improves overall usage consistency.