All Products
Search

This Product

    Dataphin:Create business qualifier

    Document Center

    Dataphin:Create business qualifier

    Last Updated:Sep 16, 2026

    A business qualifier defines the business scope for statistical analysis. This topic describes how to create one.

    Prerequisites

    You must first create a business entity. For more information, see Create and manage business entities.

    Procedure

    1. On the Dataphin homepage, click R&D in the top navigation bar. The Development page appears by default.

    2. In the top navigation bar, select a project. If you are in Dev-Prod mode, you also need to select an environment.

    3. In the left-side navigation pane, choose standard modeling > business qualifier.

    4. On the business qualifier page, click the image icon and select Create business qualifier.

    5. In the Create business qualifier dialog box, configure the parameters.

      Parameter

      Description

      Basic information

      Business entity

      Select a business entity. This selection determines if the business qualifier is for a dimension logical table or a fact logical table.

      Subject domain

      Dataphin automatically selects the subject domain of the chosen business entity.

      English name

      • When you enter an English name, Dataphin matches your input against configured word roots in real time. You can select a recommended word root as the English name for the business qualifier. For more information, see Create and manage word roots.

      • The English name must follow these conventions:

        • Can contain only letters, digits, and underscores (_).

        • Cannot exceed 64 characters in length.

      Chinese name

      It must follow these conventions:

      • Can contain any characters.

      • Cannot exceed 128 characters in length.

      Description

      Enter a brief description of the business qualifier, up to 1,000 characters.

      Calculation logic

      Business qualifier type

      You can select basic business qualifier or composite business qualifier.

      • Basic business qualifier: Its calculation logic is an expression that uses fields from a logical table to define a scope condition for metrics. Example:

        is_wireless='Y' -- is_wireless is a field in the source logical table model.

      • Composite business qualifier: This qualifier combines other committed business qualifiers by using AND, OR, and NOT operators. A composite business qualifier has two types of operators:

        • Rule operator: Supports two rules: Match and Not Match (which is equivalent to NOT).

        • Relational operator: Supports two rules: AND and OR.

        • Add rule: Click Add rule to add a blank rule at the same level under the relational operator.

          Note

          You can select only committed business qualifiers that belong to the current source primary table.

        • Add group: Click Add group to add a child-level group under the current relational operator.

          After you configure the relationships for the composite business qualifier, click Preview SQL for calculation logic to view the final SQL expression. Example:

          --Small size: size in ('XS', 'S')
--Cute style: style in ('Cartoon', 'Comic')
--Synthetic fabric: material_type in ('xxx', 'yyy', 'zzz')
--Young customers: customer_age_range = '5~10'

(size in ('XS', 'S') and style in ('Cartoon', 'Comic') and not material_type in ('xxx', 'yyy', 'zzz')) or customer_age_range = '5~10'

        • Reuse calculation logic of another granularity: Click Reuse calculation logic of another granularity to replace the current calculation logic with logic from a different data granularity.

      Data granularity

      You can select a data granularity for the business qualifier based on your business needs. The options are Day, Hour, and Minute.

      Note

      When the computing engine is Doris or SelectDB, it does not support the Minute option.

    6. After you complete the configuration, click Save and Commit.

    Next steps

    If your project is in Dev-Prod mode, you need to publish the business qualifier to the production environment. For more information, see Manage release tasks.