You are creating a query for a historical compensation story report in Query Designer.

Understanding Time Filters in Query Designer

When creating a query, time filters determine the scope of the data retrieved. Filters such as As of Date or Dynamic Date often default to "Today," which retrieves only current records.

Reason for Current Records Only

Option B: The Compensation table filter is explicitly set to As of Date > Dynamic Date: Today. This restricts the results to only the current compensation records.

Option D: The Job Information filter is configured to match records with the effective start date equal to today, which also limits the results to current data.

Why Other Options are Incorrect

A: This filter applies to Job Information, not Compensation, and does not explain why only current compensation records are retrieved.

C: "Same Filter as First Table" would align filters between tables, but does not necessarily restrict to current data.

References

SAP SuccessFactors Query Designer Guide