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.
Modeling workspace
Before you use the modeling workspace feature, take note of the following points:
  • 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.

  1. Go to the Data Modeling page.
    1. Log on to the DataWorks console.
    2. In the left-side navigation pane, click Workspaces.
    3. In the top navigation bar, select the region where your workspace resides. Find your workspace and click DataStudio in the Actions column.
    4. In the upper-left corner of the DataStudio page, click the Icon icon and choose All Products > Data Modeling > Data Warehouse Planning. The Data Layer page appears.
  2. In the left-side navigation pane of the page that appears, click Workspace for Data Modeling.
  3. In the Data Model Workspace Configuration section of the Workspace for Data Modeling page, view the data development workspaces that are associated with the model design workspace. Then, click Modify Configuration to add or remove a data development workspace.
    Note After you click Modify Configuration, you can add or remove only the workspaces on which you are granted the administrator permissions.
    Modify Configuration
    • Select the workspace to which you want to publish a model from the Workspace for Data Development drop-down list, click OK, and then click Submit to use the workspace as a data development workspace.
    • Click Delete in the Actions column of a workspace that is used as a data development workspace and click Submit to remove the workspace from the list of data development workspaces.
  4. After the modification is complete, view the change records in the Change Records section of the Workspace for Data Modeling page.

What to do next

When you publish a model, you must select a data development workspace based on your business requirements. For more information, see Publish and manage a table.