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
- Enter the necessary basic data for your server ID.
- 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
- Open the
Demand Plan Server Setup window. Query
for your
server ID.
- Click the Base Flows tab, and create a new row.
- In the Flow Description field, enter an appropriate description. In the Site ID field,
the site assigned by your instructor.
- In the Master Flow field, click No.
- Double-click the SQL Statement field. In the Edit window that
appears, enter the following SQL statement:
- Select contract, part_no, date_issued, qty_issued from
Internal_invent_part_issue_pub
where Internal_invent_part_issue_pub.part_no like '2%'
- Click OK, and save your changes.
- Repeat steps 1–6, except with part_no like '5%'.
- Open the
Demand Plan Server Setup window, and query for your
server ID.
- Click the Combined Flows tab, and create a new row.
- In the Flow Description field, enter an appropriate description. In the Site ID field,
the site assigned by your instructor.
- In the Master Flow field, click Yes. Save your changes.
- Right-click and then click Edit Combined Flow.
- 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.