Skip to main content

Business Domain

1. Create a New Business Domain​

  • Enter the business domain name;
  • Select the referenced data source;
  • After creation, you can enter the business domain management interface.

2. 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 relationships:
    • Set the From field (field in the current table);
    • Set the To table and its field (target table and target field);
    • Choose the relationship type: one-to-one, one-to-many, many-to-one, many-to-many;
    • Submit to complete the relationship binding between the two tables.

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

3. SQL Template Modeling​

  • Supports creating business relationship templates using SQL statements;
  • Templates include natural language questions and corresponding SQL queries;
  • Suitable for configuration by IT administrators, allowing business users to directly call and use, reducing the learning curve.

4. Relationship Overview​

  • Displays all tables in the business domain and their structural relationships, facilitating global understanding and management.

Parameterized Templates​

Supports creating 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 the SQL statement as placeholders;
  • When called, 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 to ensure the accuracy and security of query results.

Example:
SELECT * FROM Sales WHERE Region = ${region} AND Date >= ${start_date}

Reference Templates​

Provides a series of system preset 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 logic 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 within teams, improving overall usage consistency.