Chapter 4. Create the data model for the employee rostering project
Use this section to create the data objects required to run the employee rostering sample project in Decision Central.
Prerequisite
You have completed the project set up described in Chapter 2, Set up the employee rostering sample project.
Procedure
-
With your new project, either click Data Object in the project perspective, or click Add Asset
Data Object to create a new data object. Name the first data object
Timeslot
, and selectemployeerostering.employeerostering
as the Package.Click Ok.
-
In the Data Objects perspective, click +add field to add fields to the
Timeslot
data object. -
In the id field, type
endTime
. -
Click the drop-down menu next to Type and select
LocalDateTime
. - Click Create and continue to add another field.
-
Add another field with the id
startTime
and TypeLocalDateTime
. - Click Create.
-
Click Save in the upper-right corner to save the
Timeslot
data object. - Click the x in the upper-right corner to close the Data Objects perspective and return to the Assets menu.
Using the previous steps, create the following data objects and their attributes:
Table 4.1. Skill id Type name
String
Table 4.2. Employee id Type name
String
skills
employeerostering.employeerostering.Skill[List]
Table 4.3. Shift id Type requiredSkill
employeerostering.employeerostering.Skill
timeslot
employeerostering.employeerostering.Timeslot
Table 4.4. DayOffRequest id Type date
LocalDate
employee
employeerostering.employeerostering.Employee
Table 4.5. ShiftAssignment id Type employee
employeerostering.employeerostering.Employee
shift
employeerostering.employeerostering.Shift
For more examples of creating data objects, see Getting started with decision services.
4.1. Create the employee roster planning entity
In order to solve the employee rostering planning problem, you must create a planning entity and a solver. The planning entity is defined in the domain designer using the attributes available in the Red Hat Business Optimizer dock.
Use the following procedure to define the ShiftAssignment
data object as the planning entity for the employee rostering example.
Prerequisite
- You have created the relevant data objects and planning entity required to run the employee rostering example by completing the procedures in Chapter 4, Create the data model for the employee rostering project.
Procedure
-
From the project Assets menu, open the
ShiftAssignment
data object. -
In the Data Objects perspective, open the Red Hat Business Optimizer dock by clicking the
on the right.
- Select Planning Entity.
-
Select
employee
from the list of fields under theShiftAssignment
data object. In the Red Hat Business Optimizer dock, select Planning Variable.
In the Value Range Id input field, type
employeeRange
. This adds the@ValueRangeProvider
annotation to the planning entity, which you can view by clicking theSource
tab in the designer.The value range of a planning variable is defined with the
@ValueRangeProvider
annotation. A@ValueRangeProvider
annotation always has a propertyid
, which is referenced by the@PlanningVariable
propertyvalueRangeProviderRefs
.- Close the dock and click Save to save the data object.
4.2. Create the employee roster planning solution
The employee roster problem relies on a defined planning solution. The planning solution is defined in the domain designer using the attributes available in the Red Hat Business Optimizer dock.
Prerequisite
- You have created the relevant data objects and planning entity required to run the employee rostering example by completing the procedures in Chapter 4, Create the data model for the employee rostering project and Section 4.1, “Create the employee roster planning entity”.
Procedure
-
Create a new data object with the identifier
EmployeeRoster
. Create the following fields:
Table 4.6. EmployeeRoster id Type dayOffRequestList
employeerostering.employeerostering.DayOffRequest[List]
shiftAssignmentList
employeerostering.employeerostering.ShiftAssignment[List]
shiftList
employeerostering.employeerostering.Shift[List]
skillList
employeerostering.employeerostering.Skill[List]
timeslotList
employeerostering.employeerostering.Timeslot[List]
-
In the Data Objects perspective, open the Red Hat Business Optimizer dock by clicking the
on the right.
- Select Planing Solution.
-
Leave the default
Hard soft score
as the Solution Score Type. This automatically generates ascore
field in theEmployeeRoster
data object with the solution score as the type. Add a new field with the following attributes:
id Type employeeList
employeerostering.employeerostering.Employee[List]
With the
employeeList
field selected, open the Red Hat Business Optimizer dock and select the Planning Value Range Provider box.In the id field, type
employeeRange
. Close the dock.- Click Save in the upper-right corner to save the asset.