Data Modeling allows you to create modifiers in a data domain. Modifiers define the business scope of statistical data and modify data in a data domain from different dimensions. For example, in the derived metric sales volume of fresh shops in Shanghai, Shanghai and fresh shops are modifiers.

Prerequisites

A data domain is created. The data domain is used to define the data scope of a modifier. For more information about how to create a data domain, see Data domain.

Background information

Modifiers are used to define the business scope of statistical data. For example, in the derived metrics sales volume of online shops and sales volume of fresh shops, online shops and fresh shops are modifiers. An atomic metric, a period, and one or more modifiers constitute a derived metric that reflects the status of a business activity of an enterprise. For more information about derived metrics, see Derived metric.

Create a modifier

  1. Go to the Atomic Metric page.
    1. Log on to the DataWorks console.
    2. In the left-side navigation pane, click Workspaces.
    3. In the top navigation bar, select the region where your workspace resides. Find your workspace on the Workspaces page and click Data Development in the Actions column.
    4. On the DataStudio page, click the Icon icon in the upper-left corner, choose All Products > Data Modeling > Data Metric. The Derived Metric page appears.
  2. In the left-side navigation pane of the Data Metric page, click Modifier.
  3. Create a modifier.
    1. On the Modifier page, click the Create icon to create a modifier.
    2. On the configuration tab that appears, configure basic information for the modifier.
      Basic Information
      Parameter Description
      Modifier Type
      • The type of the modifier. Valid values:
      • Common Business Modifier
      • Dimension Enumeration Modifier
      Abbreviation The abbreviation for the name of the modifier.

      The abbreviation is the unique identifier of the modifier and cannot be modified after you create the modifier. Example: shop_type_fresh.

      The abbreviation can contain lowercase letters, digits, and underscores (_) and must start with a lowercase letter.

      Name The name of the modifier. Example: shop type of fresh.

      The name can contain letters, digits, underscores (_), and ampersands (&) and must start with a letter or digit.

      Display Name The display name of the modifier. Example: fresh shop.

      The display name can contain letters, digits, underscores (_), ampersands (&), and parentheses () and must start with a letter or digit.

      Effective Scope The effective scope of the modifier. The effective scope defines the scope of the business activity based on which statistical data is collected. Example: fresh shops.
      Description The description of the modifier.
      Data Layer The data layer to which the modifier belongs. Valid values:
      • ADS
      • DWS
      This parameter is displayed only after you click Advanced Settings.
      Mart/Subject The data mart or subject area to which the modifier belongs. This parameter is displayed if you set Data Layer to ADS.
      Data Domain The data domain to which the modifier belongs. This parameter is displayed if you set Data Layer to DWS.
  4. Click Save in the upper part of the configuration tab.

Import modifiers

If you need to create multiple modifiers, you can import the modifiers that you need to use. DataWorks provides a template for you to import modifiers. You can configure the required information about modifiers in the template file and import the file.

  1. On the Modifier page, move the pointer over the Import icon and click Import from Excel.
    You can refer to the steps described in the preceding section to go to the Modifier page.
  2. In the Import dialog box, configure Import Mode, download the template file, configure the required information about modifiers in the file, and then upload the file.
    Import
    1. In the Import dialog box, configure Import Mode.
      Ignore Existing Objects with Same Name is the only value of Import Mode. The value is selected by default and cannot be changed.
    2. Click Download Template to download the template file.
    3. In the downloaded template file, configure information such as Abbreviation, Display Name, and Effective Scope for modifiers and save the file.
      The following table describes the information you must configure in the template file.
      Parameter Description
      Modifier Type
      • The type of the modifier. Valid values:
      • Common Business Modifier
      • Dimension Enumeration Modifier
      Abbreviation The abbreviation for the name of the modifier.

      The abbreviation is the unique identifier of the modifier and cannot be modified after you create the modifier. Example: shop_type_fresh.

      The abbreviation can contain lowercase letters, digits, and underscores (_) and must start with a lowercase letter.

      Name The name of the modifier. Example: shop type of fresh.

      The name can contain letters, digits, underscores (_), and ampersands (&) and must start with a letter or digit.

      Display Name The display name of the modifier. Example: fresh shop.

      The display name can contain letters, digits, underscores (_), ampersands (&), and parentheses () and must start with a letter or digit.

      Effective Scope The effective scope of the modifier. The effective scope defines the scope of the business activity based on which statistical data is collected. Example: fresh shops.
      Description The description of the modifier.
      Data Layer The data layer to which the modifier belongs. Valid values:
      • ADS
      • DWS
      This parameter is displayed only after you click Advanced Settings.
      Mart/Subject The data mart or subject area to which the modifier belongs. This parameter is displayed if you set Data Layer to ADS.
      Data Domain The data domain to which the modifier belongs. This parameter is displayed if you set Data Layer to DWS.
      Note If you cannot edit the template file after you download it, click Start Edit in the upper part of the template file.
    4. Click Select File. Then, select the template file that you saved and click OK.
      You can view the import result and details in the Import dialog box. Import complete

What to do next

You can reference the created modifier, an atomic metric, and a period when you create a derived metric. The derived metric can be used to collect statistical data on the values of an atomic metric within a specific period based on specific dimensions and business conditions. If you want to delete a modifier that is referenced by derived metrics, you must delete all the derived metrics before you can delete the modifier. For more information about how to reference a modifier when you create a derived metric, see Derived metric.