Defining Flows—Exercises

IMPORTANT
It is extremely important that you set up and work within your own Server ID in order to maintain your data integrity. If you work within any other server id, you will compromise your exercise data as well as the data of other students. Predictable exercise results require that your data be isolated to your own server id.

 

Basic Data Setup

Entering General Server Data

Purpose: The purpose of this exercise is to show you how to set up general server data for your server ID.

Windows:
Demand Plan Server Setup
Forecast Server

  1. Enter the necessary basic data for your server ID.
  2. Save your changes.

General exercise for Entering General Server Data

Main Exercises

Purpose: The purpose of this exercise is to show you how to define a base flow.

Windows:
Demand Plan Server Setup/Base Flows

Defining Flows - Base Flows

  1. Open the Demand Plan Server Setup window. Query for your server ID.
  2. Click the Base Flows tab, and create a new row.
  3. In the Flow Description field, enter an appropriate description. In the Site ID field, the site assigned by your instructor.
  4. In the Master Flow field, click No.
  5. Double-click the SQL Statement field. In the Edit window that appears, enter the following SQL statement: 
  6. Select contract, part_no, date_issued, qty_issued from Internal_invent_part_issue_pub 
    where Internal_invent_part_issue_pub.part_no like '2%'
  7. Click OK, and save your changes.
  8. Repeat steps 1–6, except with part_no like '5%'.

Defining Flows - Combined Flows

  1. Open the Demand Plan Server Setup window, and query for your server ID.
  2. Click the Combined Flows tab, and create a new row.
  3. In the Flow Description field, enter an appropriate description. In the Site ID field, the site assigned by your instructor.
  4. In the Master Flow field, click Yes. Save your changes.
  5. Right-click and then click Edit Combined Flow.
  6. In the Not Included area, click one of your flows. Move the flow to the Included In Combined Flow area using Move Right. Repeat this process with your second flow. Click OK and then Yes.