6.1 Create a Workspace

The Workspace creation requires entry of the source of dataset, validation, and deployment. Besides, the application may require users of different function groups to create and approve a Workspace. In other words, a user associated with the modeler function group creates a Workspace and the approval and deployment are done by a user associated with the Modeling Administrator function group.

UGDOMMAP function should be mapped to the user performing sandbox creation operation. Otherwise, the create operation will fail.

Two new objects are added during data sourcing in workspace creation:
  • Materialized View
  • Triggers

Create workspace process can be time-consuming, typically may take between 2 to 3 hours. However, if certain scenarios are not carefully considered, the creation may encounter failures, leading to unwanted delays. To prevent such setbacks and ensure a seamless creation, it is crucial to address these potential issues beforehand.

The possible issue and solution are as follows:
  • Adding Views, Materialized Views, or Triggers without selecting their respective parent tables
    • Issue: If a user adds views, materialized views, or triggers without confirming the selection of their corresponding parent tables, it can lead to the workspace creation failure.
    • Solution: It is essential to verify that all dependent objects, such as Views, Materialized views, and Triggers, have their corresponding parent tables included in the selection before initiating the creation process.

To create a Workspace, follow these steps:

  1. Navigate to Workspace Summarypage.
    The page displays workspace records in a table.
  2. Click Add Workspace.
    The Create Workspace page is displayed.

    Figure 6-2 Create Workspace


    This image displays the Create Workspace screen.

    The window displays a progress indicator at the left that indicates the active window where you are entering details. Click Previous to go back a step and click Next to go to the next step.
    The following steps show the various phases from workspace creation to deployment:
    1. Basic Details
    2. Workspace Schema
    3. Data Sourcing
    4. Metadata Sourcing
    5. Validate
    6. Summary

    Note:

    During the Workspace creation, simulation segment code parameter is added. Simulation segment code can be provided as anything. It should be 10Char Name and it can be same as the workspace name.