Steps to explicitly set a catalog or schema

Procedure

  1. Create a single session parameter whose value identifies whether you are in design mode. When you are in design mode, set the value of this session parameter to a specific value, such as design. Otherwise, leave the value empty.

    Tip: If you use a project or override value, you must set it each time you open the model for editing.

  2. For each catalog and schema in each project data source, create a parameter map that contains
    • An empty default value.
    • A key whose name is the design value of the session parameter above, and whose value is the name of the design mode catalog or schema for that data source.
  3. Select the data source, and replace the catalog and schema property values with a macro that uses the corresponding parameter map and session parameter.

    For example, use

    #$DBSchemaName ($DeployOrDesign) #