Define Dataset

Explanation

This activity is used to define the datasets that will be used within a company to transfer data to the Scheduling Engine. A dataset will contain information on how data should be scheduled. That is, the type of scheduling that should take place and the time horizon for the scheduling. There are three types of scheduling that can be assigned to a dataset, Static, Dynamic and Appointment. Static scheduling is generally used for long term rough scheduling such as the resource capacity for a year, while Dynamic scheduling is used for short term detail scheduling with the focus on optimizing the utilization of resources. And the Appointment scheduling is used when the Appointment Booking Engine is requested to generate appointment slots based on available resources. The time horizon for which the data should be transferred and scheduled should be entered in days. For instance, if the number of days is set to 7, all work orders, schedules, employees, breaks and HR bookings, for the site(s), that should be scheduled within the given time interval (7 days in this example) will be sent to and scheduled by the Scheduling Engine. In addition an appointment work days duration can also be specified; the appointment work days duration will follow on from the scheduling work days duration to return a less accurate but faster schedule for a longer period. For example entering an appointment work days duration of 10 days and a scheduling work days duration of 5 days will make the Scheduling Engine schedule activities for 15 days ahead from the system date, with a high accuracy in the first 5 days and rest with a less accuracy. Further, a calendar can be entered as an input reference so that the scheduling work days duration will determined based on the working days of the calendar only. For example entering a 5 working days per week calendar, with 7 scheduling days and 14 appointment days will send a total scheduling window of 27 days(7+2 and 14+4 = 27).In the Time Zone, you need to enter in what time zone the dataset should be scheduled, used and displayed. i.e. If you are working in an Australian or American company, you can have one central installation for the complete country and different work dispatchers and service technicians in the different time zone regions, you should have one dataset for each of the time zone regions. When this is correctly set up, you will get the scheduled availability and activities correctly displayed on your own computers, configured with your local regional settings.

You can set up the dataset to be applicable for one or more sites within the company. Following is a list of data that will be transferred for scheduling from the relevant site(s):

Note: In Mobile Workforce Management, permission groups define which users are allowed to view a set of resources (employees in IFS Applications) and activities (separate and route work orders). These permission groups are called object groups. In the integration, object groups have the equivalence of sites in IFS Applications. This means that in order for a Mobile Workforce Management user to be able to view information like resources and activities belonging to a particular site, the user must be connected to the corresponding object group. The object groups for activities and resources are transferred automatically from IFS Applications to Mobile Workforce Management, but object groups for the Mobile Workforce Management users must be set up and granted to the users manually from the iSWB. The user must also be granted to the dataset itself manually in iSWB.

Default values can be entered for the work orders in the dataset. From these, the default activity type, maximum base value per hour and appointment scheduling type must be entered when setting up the dataset. If a work order is missing a primary scheduling type, secondary scheduling type or an activity type, or if it is an appointment work order which is missing a scheduling type, the default values from the dataset will be assigned automatically to the work order. If a location is missing its do on location incentive value, the default value entered in the dataset will be retrieved to the work order. It is possible to define the lowest status from which work orders in the dataset can be transferred for scheduling. The default work order status for all datasets is Released and is set for the parameter Dataset Schedule from WO Status (Scheduling/Basic Data/Scheduling Configuration). The parameter value can be changed if required and you can also choose to configure this per dataset. Values need to be entered for HR activities, i.e., Lunch and Break, in the dataset as well. The values will be assigned to all lunches and breaks and will be used as an input when scheduling the activities.

For each dataset, it is possible to connect a broadcast to an allocation type. The allocation type is used to indicate what type of data should be output based on its association with either the DSE (Dynamic Scheduling Engine), SDS (Scheduling Dispatch Service), ABE (Appointment Booking Engine) or iSWB (Scheduling Workbench). The purpose of connecting broadcasts to allocation types is to enable transferring of SDS rules (i.e., a set of commit rules to automatically commit/uncommit orders) and to set up communication between IFS Application and the SDS, iSWB, ABE or DSE. To start the transfer of data per allocation type, the connected broadcast must be activated. It is possible to deactivate a broadcast for an allocation type without deactivating the entire dataset. Based on the allocation type you select, the following will occur when the data is transferred via the dataset:

It is possible to connect a Modelling Dataset ID to the scheduling dataset. A modelling dataset allows combining modelling data configured in the Advanced Resource Planner (ARP) to be used with the scheduling dataset. Modelling datasets are set up in Scheduling Workbench - Administration and the modelling data is set up in Scheduling Workbench - Planning - Data Management. To extract and utilize the modelling data the scheduling dataset have to be linked with a modelling dataset. This is achieved by not defining the data_path parameter on the scheduling dataset. The Modelling Dataset ID will be transferred to Mobile Workforce Management as the Scheduling Dataset ID, prefixed with the Dataset Prefix from Scheduling Configuration if this is defined.

Prerequisites

System Effects

Window

Scheduling Dataset

Related Window Descriptions

Scheduling Dataset
Scheduling Dataset/Site
Scheduling Dataset/WO Defaults
Scheduling Dataset/HR Defaults
Scheduling Dataset/Broadcast

Procedure

Use the following procedure to create a dataset for your company and define the default values for work orders in the dataset:

  1. Open the Scheduling Dataset window.
  2. Verify that the correct company is in use. If not, right-click and click Change Company to change the company.
  3. Create a new record (F5).
  4. In the Dataset ID field, enter a unique identification for your dataset.
  5. In the Description field, enter a description of the dataset.
  6. In the Scheduling Work Days field, enter the number of days for the scheduling horizon of the dataset.
  7. In the Appointment Work Days field, enter the number of days to extend the scheduling horizon from the Scheduling Work Days period.
  8. In the Calendar ID field, enter the calendar which contain details of working and non working days.
  9. In the Process Type field, specify whether this should be a Static, Dynamic or Appointment dataset.
  10. Click the WO Defaults tab.
  11. In the Default Activity Type field, enter an activity type for the work orders in the dataset. Use the List of Values to select a valid value.
  12. In the Maximum Base Value per Hour field, enter the maximum base value in hours for the work orders in the dataset.
  13. In the Appointment Scheduling Type field, enter the scheduling type that is to be used for the appointment work orders in the dataset. Use the List of Values to select a valid value.
  14. Optionally, enter the default primary and secondary scheduling types for the work orders in the dataset by using the List of Values in the Default Primary Scheduling Type and Default Secondary Scheduling Type fields respectively.
  15. Optionally, enter the default Do on Location Incentive value. The value can be set to -1 or anything between 1 and 2.
  16. Optionally, enter the lowest status from which work orders in the dataset can be scheduled in the Schedule from WO Status field.
  17. Save the information (F12).

Use the following procedure to enter the sites within the selected company which are to be scheduled:

  1. Click the Site tab and create a new record (F5).
  2. In the Site field, enter the site for which scheduling data is to be transferred. Use the List of Values to select a valid value.
  3. Save the information (F12).

Use the following procedure to define default values for the lunches and breaks in the dataset:

  1. Click the HR Defaults tab.
  2. In the Scheduling Type Lunch field, enter the scheduling type for all lunches in the dataset. Use the List of Values to select a valid value.
  3. In the Lunch Base Value per Hour field, enter the base value per hour for all lunches in the dataset.
  4. In the Scheduling Type Break field, enter the scheduling type for all breaks in the dataset. Use the List of Values to select a valid value.
  5. In the Break Base Value per Hour field, enter the base value per hour for all breaks in the dataset.
  6. Save the information (F12).

Use the following procedure to connect a scheduling broadcast to an allocation type:

  1. Click the Broadcasts tab and create a new record (F5).
  2. In the Allocation Type field, enter the allocation type. Valid values are DSE, ABE, SDS and ISWB.
  3. In the Broadcast ID field, enter the identity of the broadcast that is to be connected to the allocation type. Use the List of Values to select a valid value.
  4. Select the Active check box if you want to activate the broadcast for the allocation type.
  5. Save the information (F12).

Use the following procedure to define a scheduling parameters for a Dataset, this step is optional:

  1. Click the Parameters tab and create a new record (F5).
  2. Use the drop down for Parameter Name to select a parameter.
  3. In the Parameter Value field, enter the the desired value for the parameter.
Parameter Name Description Possible Parameter Values
schedule_time_offset Obsolete. Replaced by the above Time Zone parameter.
data_path

 

 

 

 Data Path can point to additional XML files conforming to this definition to be loaded.
This file is merged with existing XML data set prior to processing. The XML file may
itself also point to an additional file of XML to be loaded. This Data Path needs to point to a existing directory and file name on the Scheduling Server running the Input Manager Service (IMS). The Data Path can be used for for defining an xml containing rules for the Scheduling Dispatch Service (SDS).

If a Modelling Dataset is to be used then the Data Path parameter must not be defined.

 

 Valid values is a complete data path containing directory and file name, e.g.

C:\MWFM\SDS\rules.xml

Substitution variables may be used when defining the data_path.
For more information on substitution variables relating to the Mobile Workforce Management Integration please refer to the activity Define Scheduling Configuration.