Maintaining Jobs

Example: Defining a Job with Multiple Output Tables and Input Sources in a Process Flow

This example defines a Job with a Process Flow that has multiple output tables and multiple input sources. An OLAP Group and both of its children summary data stores are specified in a single job. The Detail Logical Table Sales Detail Grp is specified as the input source for the two summary data stores as well as the OLAP Group.

Consider the following when specifying multiple output tables for a Job:

Only one Job can specify a given data store as an output table, but many Jobs can specify a given data store as an input table.
If you specify a given data store as an output table and the data store is already specified as the output of another Job, you will be given a series of prompts to determine how the other Job should be handled.
SAS/Warehouse Administrator will not allow you to add an output table that is invalid for a Job.
All output tables that you add to a Job must be in the same metadata repository as the Job. For example, you can create a Job whose output tables are all in the same Data Warehouse, and you can create a Job whose output tables are all ODDs in the same Warehouse Environment. But you cannot create a Job in which a Warehouse table and its ODD are both specified as outputs for that Job. For more information, see Overview: Metadata Repositories.

Note: The following explanations describe the metadata and methods used to achieve the desired results. It is assumed that the appropriate Data Warehouse Environment, Data Warehouse, Subject, Detail Logical Table, and OLAP objects physical properties exist. [cautionend]

Adding a Job From the Data Store

In the SAS/Warehouse Administrator Explorer, position the cursor on the data store for which you want to add a Job, for example HOLAP Group.

[untitled graphic]

Click the right mouse button, and select Process. SAS/Warehouse Administrator asks you if you want to create a Job. Select Yes.

The software adds a Job (named by default for the data store), opens the Process Editor, and displays an icon for the output table in the Process View.

[untitled graphic]

You would now typically define the Job properties, such as a Job name and whether the code for the Job is generated by SAS/Warehouse Administrator or user-written. This example assumes that the Job code is generated by SAS/Warehouse Administrator.

Adding an Input Source

To display the Selector window, in the Process Flow, click the output table HOLAP Group with the right mouse button and select Add Inputs

[untitled graphic]

In the Selector window, select the type of table you want to add as an input source, which for this example is a Detail Logical Table, then click Show.

[untitled graphic]

From the list of displayed tables, select the table you want to add, which is Sales Detail Grp, then click OK. The input source is added to the Process Flow.

[untitled graphic]

You would now update the default metadata for the Mapping process.

Adding a Second Output Table and Input Source

In the Process Flow, click the right mouse button in background and select Add Output Table.

The Selector window displays. In the Selector window, select the type of table you want to add as an additional output table, which for this example is an OLAP Table. Then click Show. From the list of displayed tables, select the table you want to add, which is Sum 12 OLAP Table, and click OK. The additional output table is added to the Process Flow.

[untitled graphic]

To specify an input source for the additional output table, in the Process Flow, click the output table Sum 12 OLAP Table with the right mouse button and select Add Inputs

From the Selector window, select the type of table you want to add as an input source, which for this example is a Detail Logical Table, then click Show. From the list of displayed tables, select the one you want to add, which is Sales Detail Grp (the same input source as specified for output table HOLAP Group), and then click OK. The Process Flow displays that the input source is specified for both output tables.

[untitled graphic]

You would now update the default metadata for the Mapping process.

Adding a Third Output Table and Input Source

In the Process Flow, click the right mouse button in background and select Add Output Table. The Selector window displays.

In the Selector window, select the type of table you want to add as an additional output table, which for this example is an OLAP MDDB. Then click Show. From the list of displayed tables, select the table you want to add, which is Sum 11 OLAP MDDB, and click OK. The third output table is added to the Process Flow.

[untitled graphic]

To specify an input source for the third output table, in the Process Flow, click the output table with the right mouse button and select Add Inputs

From the Selector window, select the type of table you want to add as an input source, which for this example is an OLAP Table. Then click Show. From the list of displayed tables, select the table you want to add, which is Sum 12 OLAP Table, then click OK. The input source, which is also an output table in the Process Flow, is displayed in the Process Flow.

[untitled graphic]

You would now update the default metadata for the Mapping process.

Top of Page