Business Intelligence Tutorial

Specifying that the steps are to run in sequence

To specify that the steps are to run in sequence:

  1. From the Data Warehouse window, right-click on the Build Tutorial Market Dimension process and click Open.
  2. From the Process Model window, click the Task Flow icon:
    Figure arrowcol not displayed.
  3. Click the On Success icon (the green arrow).

    On Success indicates that a step is to be started only if the step before it ran successfully. You can also select the following states:

    On Completion
    Indicates that a step is to be started when the step before it runs successfully or fails. (The blue arrow.)

    On Failure
    Indicates that a step is to be started only if the step before it failed. (The red arrow.)

    For more information, see "Scheduling a step" in the online help.

  4. Click the Load Demographics Data step, which is the step that is to run first.
  5. Hold down the mouse button and drag the mouse to the Select Geographies Data step, which is to run after the Load Demographics step.
  6. Release the mouse button.

    A green arrow that represents the task flow is displayed on the canvas between the two steps.

  7. Repeat steps 4 to 6 with the Select Geographies Data step and the Join Market Data step. This specifies that the Select Geographies Data step is the first step, and the Join Market Data step is the second step.
    The GEOGRAPHIES SELECT statement on the SQL Statement page.

    The steps will now run in the order that is listed in the introduction to this lesson.


[ Top of Page | Previous Page | Next Page | Table of Contents ]