The Employee Hours Worked Trend Analytics Workbook contains a calculation named Example Overtime Band 1. To display all the overtime bands used by your enterprise, you need to create new calculations for each overtime band. Use the predefined Example Overtime Band 1 calculation as your template.

The calculation text in Example Overtime Band 1 is:

SUM(HRI_UTL_GET_HOURS_WORKED('EXAMPLE_BIS_OT_BAND1',"Assignment Id (for Workbook Calculation)",NULL,Period End Date))

Use Oracle Discoverer User Edition.

   To adapt the Hours Worked Workbook:

1. In Oracle Discoverer User Edition, open the HRMSi - Employee Hours Worked (Organization Hierarchy) Trend Analytics workbook.

2. Copy and rename the example calculation Example Overtime Band 1 for each overtime band you want to display in the report.

3. In the text of each new calculation, change EXAMPLE_BIS_OT_BAND1 to the name of each of one of your overtime band formulas.

   Note: If you have not created Overtime Band formulas, see: Setting Up and Configuring Working Hours

4. Hide the example calculation.