DataWorks:Create a conceptual model: dimension

Procedure

1. Go to Dimensional Modeling.

   1. Log on to the DataWorks console. Switch to the desired region, click Data Development and O&M > Data Modeling in the left-side navigation pane, select the corresponding workspace from the drop-down list, and click Enter Data Modeling.

   2. On the Data Modeling page, click Dimensional Modeling in the top menu bar.

2. On the Dimensional Modeling page, move the pointer over the icon and click Conceptual Model > Create Dimension.

3. Configure the basic information of the dimension.

   Parameter	Description
   Data warehouse layer	Select the data warehouse layer to which the dimension belongs. Different layers serve different business scenarios: Common Layer: Stores the results of processing and integrating shared data to establish enterprise-wide dimensions. After selecting this layer, specify a data domain. For instructions on creating a data domain, see Data domain. Application Layer: Creates business-level dimensions for specific use cases based on application requirements. After selecting this layer, specify a data mart. For instructions on creating a data mart, see Data mart . Note The default application data layer supports only application tables. To create a dimension in the application layer, create a new application layer and set its model type to Dimension or Dimension tables and dimensions. For details, see Custom layers.
   Business category	Select the business category to which the dimension belongs. For details, see Define a business category.
   Data domain / Data mart	Specify the data domain or data mart to which the dimension belongs based on the selected data warehouse layer. The data mart field appears only when you select the application layer.
   English abbreviation	The dimension's English abbreviation, which must be unique within its data domain or data mart.
   Chinese name	The dimension's Chinese name.

4. Click Save to create the dimension.

   After the dimension is created, you can find and manage it under the corresponding data domain or data mart in the left-side directory tree of the dimension modeling page.

FAQ

Q: How do I create a dimension in the application layer?

A: The default application layer supports only application tables. You can create a new data warehouse layer, select the application layer, and configure the model types for that layer. Available types are Application Table, Dimension Table, Conceptual Dimensions. You can attach Dimension Table and Conceptual Dimensions separately or together.