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: