Success Factors report of active employees in certain period of time

[beyreli]

Hi folks,

Is it possible to create a report for active employees in a period (successfactors). For example, I want to see all the active personal in the range of 01.08.2023 - 31.08.2023. Tricky part is if someone hired 02.08.2023 and terminated 05.08.2023 this employee should be in report even if terminated ( It is enough to be an active at some moment in date range once. It doesn't matter if employee terminated. that employee should be in report )

First of all which report type would be revelant for this request (Table, Canvas, Story)

We've tried job info data range however we didn't get the exact result we want.

All suggestions are welcome

Kind Regards..

[brittacarols]

In SAP SuccessFactors, you can create a report using the Ad Hoc Reports or Online Report Designer (ORD) tool to fulfill your requirements. Both tools offer flexibility in designing custom reports.

[nlgro023]

Can be done, the only thing you may need to be comfortable with is potential duplicate lines (as people could have multiple job info /comp etc. records in that period). Table would be a bit too hard mode as you'd only have filtering to play around with (the combo of effective start date >= 01.08.2023 and effective and effective start date <= 31.08.2023 or effective start date < 01.08.2023 and effective and effective end date >= 01.08.2023 etc.)
I personally would prefer to build a column that does such checks and shows yes if so, then I'd use that to filter in a canvas / story (ideally story) report + use a pivot table to remove duplicates.