DataWorks:Create a conceptual model: Dimension

Procedure

1. Go to Dimensional Modeling.

   1. Log on to the DataWorks console. After you switch to the destination region, choose Data Development & O&M > Data Modeling in the navigation pane on the left. Select the desired workspace and click Go to Data Modeling.

   2. In the top menu bar of the Data Modeling page, click Dimensional Modeling.

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

3. Configure the basic information for the dimension.

   

   Parameter	Description
   Data warehousing level	Select the data warehousing level to which the dimension belongs. Different layers are designed for different business scenarios: Common layer: Stores the results of processing and integrating public data to establish unified, enterprise-level dimensions. If you select this option, you must also specify a data domain. For more information about how to create a data domain, see Data domains. Application layer: Creates business-level dimensions for specific business applications based on actual needs. If you select this option, you must also specify a data mart. For more information about how to create a data mart, see Data marts. Note The default application layer supports only the creation of application tables. To create a dimension in the application layer, you must create a new application layer and set its model type to Dimension or Dimension Table, Dimension. For more information, see Customize data warehousing levels.
   Business category	Select the business category to which the dimension belongs. For more information, see Define business categories.
   Data domain / Data mart	Specify the data domain or data mart for the dimension based on the selected data warehousing level. The Data mart parameter is visible only when you set Data warehousing level to Application layer.
   Abbreviation	The abbreviation of the dimension. The abbreviation must be unique within the specified data domain or data mart.
   Name	The name of the dimension.

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 Dimensional Modeling page.

FAQ

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

A: By default, the application layer supports only the creation of application tables. You can create a new data warehousing level, select Application layer, and then configure the model type for this level. The available model types are Application Table, Dimension Table, and Dimension. You can choose to mount Dimension Table and Dimension individually or together.