DataWorks:Conceptual model: Dimension

Prerequisites

Before you begin, make sure that you have:

• A DataWorks workspace with the Data Modeling feature enabled

• At least one Business Category defined for the target product

• A Data Domain (for Common Layer) or a Data Mart (for Application Layer) already created

Create a dimension

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	The layer in your data warehouse where the dimension resides. Options: Common Layer: Stores processed, integrated data to create an enterprise-level dimension. Requires a Data Domain. For more information, see Data Domain. Application Layer: Builds business-level dimensions for specific application requirements. Requires a Data Mart. For more information, see Data Mart. > Note By default, the Application Layer only supports creating Application Tables. To create a dimension in the Application Layer, first 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	The business category the dimension belongs to. For more information, see Define Business Categories.
   Data Domain / Data Mart	The data domain or data mart for the dimension, determined by the selected Data Warehousing Level. Data Mart is available only when Application Layer is selected.
   Abbreviation	A short identifier for the dimension. Must be unique within the specified Data Domain or Data Mart.
   Name	The display name of the dimension.

   

4. Click Save.

After the dimension is created, 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.

What's next

Associate the dimension with a Dimension Table. For more information, see Create a logical model: Dimension Table.