Support for Reporting of Time Events in SAP SuccessFactors Time Tracking
Hello Time Community,
We are happy to announce that Time Events (punches) are now reportable with 1H 2023 release of SAP SuccessFactors Time Tracking.
The Time Events fields are available and can be created via Story Reporting. Generally, there are additional information like and many more details required to generate the report. The reports will help admins to generate Time Events for the employees with the following filters:
- Date range – daily, bi- weekly, weekly, monthly or quarterly
- Specific country, location, department, cost center, etc.
- Punched in a specific region when location capture is enabled.
- Percentage of employees who punch using terminal, web or mobile (pie chart or bar graph)
Below are some simple steps for creating the report. It uses the basic filter of date range for a month. If you follow the steps mentioned below, you can see the report as shown in the screenshot.
Steps to create a Time Event Report:
Pre-requisites: Ensure you have access to Report center along with permission to create the new Story.
- Click on the New Button and select the report you want to create as “Story”.
- This takes you to the next section where you can decide to create any kind of report. I selected a Table to get the above report.
- Once you land on the Query Designer that looks the following way
- You will now see Clock In Clock Out object displayed under Available Data section.
- Expand the Clock In Clock Out object to see Time Events. Drag the Time Events to the Query Designer screen. You will see the other entities associated with Time Events.
- Clicking on Time Event in the Query Designer will show related tables, columns to be selected, adding filters and delete.
- Click on the “show related tables” to show three entities – Geo Location, Time Event Type and Basic User Information.
- Click on the “+” icon on the top of every entity to add the table to extract data for the report.
- I added the “Time Event Type” as this contains the Time Event Type Name like the Clock In for the P10 and Clock Out for say P20.
- Now, click on the select column option to enable columns required for the report.
- I enabled the Time Event Type Name columns to display the Clock In and Clock Out.
- Similarly, I also added the Basic User Information and selected columns like Display Name, Manager and Location.
- Basic User Information also has the related tables with Job Information which you can add as well to add details like Supervisor/Manager’s Display Name, Department, Division information.
- Geo Location is also another entity associated with Time Event which contains information of employee’s location of punch details like latitude, longitude, address.
- The columns related to Time Events are also selected.
- Once selected, the structure will look as below and you could try to check the preview by clicking on the “Preview Query”
- Once you are able to generate the preview, you can click the “Finish” button.
- A prompt to select the Data Source appears which is already filled with “Time Event”. Click on “OK” button.
- It prompts another popup with setting variable of “As of Date for Job Information”. You could decide to set to the current date or a prior date as well. Click on the “OK” button.
- You are now taken to select the object for the story canvas. I have selected “Table” as I require a table layout. Click on the “Table”.
- You are now shown the table and the Builder to make modifications to column headers, the layout on how the table should be displayed, etc.
- Select the Cross-tab as the Table Structure to get the table I showed in the beginning. In the Column section, the count is the only column shown. You could delete this row and add the required row by clicking on Add Dimensions button. Select the required columns you want to show in the table. I have selected all except the Time Event Date. I will use this as a filter.
- Once, they are selected, the Builder will show with values as below. It is time now to arrange the columns in the necessary order by dragging them using the three dots in the left-hand corner. Also, the column headers can be renamed. For example, there are two Display Name. One shows the employee display name and the other is Manager’s Display Name.
- The rows now show like the one below. Now, time to add the filters to ensure you have the right data for the report.
- Filter can be set by clicking on Add Filter in the Filter section. There are various options and I selected Time Event Date (Range). This allows to select a range of date ranges like Monthly or Yearly. The type of date range can be dynamic or fixed. I wanted to generate for a month and hence, I fixed the time range and set the granularity to Month. Selected the month as April 2023 to May 2023. Click ok button to save the filter and apply it.
- Now, its time to save your story and click on Save option. Providing a story name will save your story.
- You can now already see the data loaded in the table view. It has the time events for the month of April 2023 to May 2023.
Hope the steps provided helped you create your report. You could now hide columns or even add additional filters to get the required data.
The Standard Report will be incomplete without the planned working time information and planned to be released as per roadmap schedule.
If you have any questions or feedback, please leave a comment below. You could also post your queries in the SAP Community