The dimension management feature provided by Data Modeling allows you to define dimensions in a standardized manner. You can use this feature to create dimensions that may be required during data modeling in advance, manage dimensions in a centralized manner, and ensure that each dimension is unique. This topic describes how to create and manage a dimension.

Background information

The dimension management feature helps you plan dimensions and the attributes of the dimensions in the stage of data warehouse planning in advance. You may use the dimensions when you create a model. This feature also allows you to manage dimensions in a centralized manner. When you create an aggregate table or application table, you can associate a dimension that you create with the table for statistical analysis.

Limits

The abbreviation for the name of a dimension must be unique.

Create a dimension

  1. Go to the Data Modeling 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 the workspace that you want to manage resides. Find the workspace and click Data Analytics in the Actions column.
    4. On the DataStudio page, click the Icon icon in the upper-left corner and choose All Products > Data Modeling.
  2. In the left-side navigation pane of the Data Warehouse Planning page, click Dimension management to go to the Dimension management page.
  3. Create a dimension.
    1. On the Dimension management page, click New dimension.
    2. In the Create Dimension dialog box, configure the parameters.
      Create Dimension
      Parameter Description
      Dimension Chinese name The display name of the dimension.

      The display name can be a maximum of 2,048 characters in length. It can contain letters, digits, underscores (_), ampersands (&), and parentheses () and must start with a letter or digit.

      Dimension English name The name of the dimension.

      The name can be a maximum of 128 characters in length. It can contain letters, digits, and underscores (_) and must start with a letter or digit.

      Dimensional English abbreviation The abbreviation for the name of the dimension. The abbreviation is the unique identifier of the dimension.

      The abbreviation can be a maximum of 128 characters in length. It can contain lowercase letters, digits, and underscores (_) and must start with a lowercase letter.

      Dimension attribute The attributes of the dimension.

      You can specify the rows of attributes that you want to add for the dimension and click Add. Then, the system adds the rows that you specify. You can specify display names, names, and abbreviations for the attributes. You can also specify whether to use an attribute as the primary key of the dimension.

  4. Click Confirm.

View and manage a dimension

On the Dimension management page, you can search for a dimension based on the display name of the dimension or the display name of a dimension attribute in the section marked with 1 and view the information about the dimension and the attribute in the section marked with 2. You can also modify or delete a dimension based on your business requirements.
Note If you search for a dimension by using a keyword of the display name of the dimension or a keyword of the display name of a dimension attribute, all dimensions or dimension attributes whose display names contain the keyword are displayed.
View and manage a dimension

What to do next

After a dimension is created, you can use the dimension as a granularity for data analysis when you create a model table. For more information about how to create a model table, see Create an application table .