DataWorks:Conceptual model: Dimension

Procedure

1. Go to Dimensional Modeling.

   1. Log on to the DataWorks console. Switch to the target Region. In the left-side navigation pane, click Data Development & O&M > Data Modeling. Select the target Workspace from the drop-down list and click Go to Data Modeling.

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

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 for the dimension. Different levels correspond to different business scenarios: Common Layer: Stores processed and integrated common data to create a unified, enterprise-level dimension. If you select this level, you must also specify a Data Domain. For information about how to create a data domain, see Data Domain. Application Layer: Builds business-level dimensions based on specific application requirements. If you select this level, you must also specify a Data Mart. For information about how to create a data mart, see Data Mart. Note By default, you can create only Application Tables in the Application Layer. 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 for the dimension. 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 option is available only when you select Application Layer for the Data Warehousing Level.
   Abbreviation	The abbreviation for the dimension. The abbreviation must be unique within the specified Data Domain or Data Mart.
   Name	The name of the dimension.

4. Click Save.

   After the dimension is created, you can find and manage it in the directory tree on the left of the Dimensional Modeling page, under the corresponding Data Domain or Data Mart.

FAQ

Q: How do I create a dimension in the Application Layer?

A: By default, you can create only Application Tables in the Application Layer. You can create a new Data Warehousing Level, select Application Layer, and then configure the model type for the new level. The available model types are Application Table, Dimension Table, and Conceptual Dimensions. You can enable Dimension Table and Conceptual Dimensions separately or together.