SuccessFactors Advanced Reporting Date Filters

[P2002459989]

Hello,

I created a report in Advanced Reporting with the base table of Compensation Information. The client wants to return all compensation records for a given date range, but only show active employees in that time frame. Currently, the job info records are not a 1:1 match with the comp info records.

For example:

Date Range is 8/4/2022-8/4/2022

The Driving Table is Comp Info

The Related Tables Job, Comp, Comp2 are set to be selected based on Driving Table Start date

Employee X is currently terminated, but is on the report because the comp record is in the range even though the job record it pulled is NOT in the date range.

How can I use the date options to pull in the exact comp records I want and only the active employees in that date range.

When I do a date override for Current Date on Job Info, it appears to pull only the employee who are currently active rather than active in the time frame of the date range.

See attached.report-issue-with-date-filters.png

[Angie_Pullano]

Hi Sue,

Is this the result you are looking for if Date Range validity period of 1/1/2020 to today is selected? Screenshot is history for one employee:

Here are the settings I used in Date Options:

Filter is applied for only active employee status records.

HTH,

Angie