Generating Enterprise Decision Management Output

Overview

Use the Enterprise Decision Management transformation to generate Enterprise Decision Management output in the context of a SAS Data Integration Studio job. The transformation uses an Enterprise Decision Management flow package that is created in SAS Decision Manager. The package is used to structure the data in an input table and generate columns in the output tables. The Enterprise Decision Management transformation maps physical data to decision flows. The output tables attached to the transformation produce decision-making results from the mapped input data. SAS Decision Manager supports collaborative maintenance, governance, and continuous enhancement of analytical models for operational decision making.

The required inputs, or columns, for an Enterprise Decision Management flow job are defined by Enterprise Decision Manager. Each Enterprise Decision Management flow job that you run in SAS Data Integration Studio requires a source table that contains the required inputs defined by the Smart Object.

When the source table columns are equivalent in name, the job uses the original source table to provide the required inputs. (For relational database management systems, the columns also must be identical in case. If the input table is a SAS table, only identical column names are required.)

However, when the source table columns are not equivalent to the required input columns, a view is generated as input to the job. Therefore, you should try to use a source table with column names that are identical to the defined required inputs to enhance performance.

The Enterprise Decision Management flow package that is created in SAS Decision Manager contains an automatically generated correlation_id column in its required inputs. However, it is also possible to manually define a correlation_id request variable or a correlation_id reply variable in the SAS Decision Manager application. Do not create one of these manually defined correlation_id variables if you plan to use the Enterprise Decision Management flow package in the Enterprise Decision Management transformation in a SAS Data Integration Studio. When you attempt to run the job under this circumstance, the following error is displayed:

ERROR: Compilation error.
ERROR: Duplicate declaration for correlation_id with incompatible types.

Mixed-case reply variables contained in Enterprise Decision Management flow packages can cause Enterprise Decision Management flow jobs to fail when you run them in SAS Data Integration Studio. To avoid this problem, select the Enable case-sensitive DBMS object names check box on the Physical Storage tab in the properties window for the EDM Results tab.

Problem

You want to generate Enterprise Decision Management output from a source table in a SAS Data Integration Studio job.

Solution

You can use the Enterprise Decision Management transformation in a SAS Data Integration Studio job to generate Enterprise Decision Management output. For example, you can create a job that contains a source table, the Enterprise Decision Management transformation, and two output tables named EDM Results and EDM Stats. This sample job includes the following tasks:

Create and Populate the Job
Configure the Enterprise Decision Management Transformation
Run the Job and View the Output

Tasks

Create and Populate the Job

Perform the following steps to create and populate the job:

Create an empty SAS Data Integration Studio job with an appropriate name, such as EDM Output Job.
Select and drag an Enterprise Decision Management transformation from the Transformations tree. Then, drop it in the empty job on the Diagram tab in the Job Editor window.
Select and drag the source table from the Inventory tree. Then, drop it before the Enterprise Decision Management transformation on the Diagram tab. The source table for the sample job is named GEN_TEST_INPUT.
Drag the cursor from the source table to the input port of the Enterprise Decision Management transformation. This action connects the sources to the transformation.

The sample job is shown in the following display:

Enterprise Decision Management Job Flow

Note that the Enterprise Decision Management transformation is named EDM Flow in the context of a SAS Data Integration job flow.

Configure the Enterprise Decision Management Transformation

To configure the Enterprise Decision Management transformation, select an Enterprise Decision Management flow in the Enterprise Decision Management tab. Then, map all required inputs with source table columns in the Inputs and Outputs tab.

The settings for the Enterprise Decision Management tab are shown in the following display:

Enterprise Decision Management Tab

When you select an Enterprise Decision Management flow, the output tables associated with the Enterprise Decision Management flow are added to the job flow.

The completed job flow is shown in the following display:

Completed EDM Job Flow

Completed Enterprise Decision Management Job Flow

The settings for the Inputs and Outputs tab are shown in the following display:

Inputs and Outputs Tab

Note that you can select one of the output tables listed in the table and click View output table columns to review its columns.

The following display shows the output columns for the EDM Results table:

EDM Results Columns

Run the Job and View the Output

Right-click on an empty area of the job, and click Run in the pop-up menu. SAS Data Integration Studio generates code for the job and submits it to the SAS Application Server for execution. If the job completes successfully, you can right-click an output table and click Open to review its output table.

The following display shows a view of the EDM Results output table.

EDM Results Output

Usage Notes

The temporary work tables for the Enterprise Decision Management transformation should be left in SAS data set format. Otherwise, the transformation might fail.

Transformations in a job typically create temporary work tables as they execute. The default work tables are SAS data sets in the SAS WORK library. You can redirect these temporary tables to an alternative format and location, as described in Redirecting Temporary Output Tables. However, the temporary work tables for the Enterprise Decision Management transformation should be left in SAS data set format.

The Enterprise Decision Management transformation requires an Enterprise Decision Management flow. SAS Decision Manager 2.1 can produce this flow. SAS Decision Manager 2.2 cannot produce this flow. In order to use the Enterprise Decision Management transformation, you can use SAS Decision Manager 2.1 to export the flow to a location where the Enterprise Decision Management transformation can access it. You can also use a version of SAS decision management software later than SAS Decision Manager 2.2 to produce this flow.

The global option "Use run time lookup for credentials for statements requiring credentials" should not be enabled when you run a job with an Enterprise Decision Management transformation, and the input to that transformation is an Oracle table. If you disable this option, any SAS Data Integration Studio job with SAS Connect sign-on statements will include user names and passwords in the generated code.