If your data system involves multiple workspaces and you want to use the same data warehouse plan for these workspaces, you can use the modeling workspace feature. This feature allows you to plan data warehouses, perform dimensional modeling, and define metrics for the workspaces in a unified manner. This topic describes the use scenarios of the modeling workspace feature. This topic also describes how to associate a data development workspace with and disassociate a data development workspace from a model design workspace.
Background information
DataWorks Data Modeling provides the following types of workspaces when you use the modeling workspace feature: model design workspace and data development workspace.
- Model design workspace: The current workspace that you access serves as the model design workspace. Model designers design and manage models in this workspace. These models will be published to the data development workspaces that are associated with this workspace. The models can be aggregate tables, dimension tables, or fact tables.
- Data development workspace: Data development engineers perform extract, transform, load (ETL) operations based on model design results in data development workspaces.

- In the preceding figure, a model designer designs a model (Model 1) in the Project_1 workspace and publishes the model to the Project_2 and Project_3 workspaces. If the model needs to be modified, the model designer can modify the model only in the Project_1 workspace. The model designer cannot view and modify the model in the Project_2 and Project_3 workspaces.
- The Project_1 workspace is used as the model design workspace, and the model designer can choose whether to publish the model to the Project_1 workspace. If the model designer chooses to publish the model to the Project_1 workspace, the Project_1 workspace is also used as a data development workspace. The Project_2 and Project_3 workspaces are used as data development workspaces and cannot be used as model design workspaces.
Precautions
- When you associate data development workspaces with a model design workspace, take
note of the following point:
You can select only the workspaces on which you are granted the administrator permissions. You cannot select the workspaces that are already used as data development workspaces.
- When you disassociate data development workspaces from a model design workspace, take
note of the following point:
You can select only the workspaces on which you are granted the administrator permissions.
Procedure
This section describes how to associate a data development workspace with and disassociate a data development workspace from a model design workspace.