Create a conceptual model: Dimension

Modeling perspective

Dimensional modeling organizes model tables into three levels: Common layer, Application layer, and Uncategorized. The Common layer is used to build reusable unified metrics, dimensions, and detailed fact data, and supports management from either data domain or business category perspectives. The Application layer addresses business-specific statistical needs and supports only the business category perspective. After selecting a level, you can create and manage model tables in the corresponding directory tree.

Procedure

1. Go to Dimensional Modeling.

   1. Log on to the DataWorks console. After you switch to the target region, click Data Development and O&M > Data Modeling in the navigation pane on the left. Select the target 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 create unified, enterprise-level dimensions. If you select this level, you must also specify a data domain. For more information about how to create a data domain, see Data domain. Application Layer: Creates business-specific dimensions based on application requirements. If you select this level, you must also specify a data mart. For more information about how to create a data mart, see Data mart. 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 Conceptual Dimensions. You can select Dimension Table and Conceptual Dimensions individually or together.