Exam C-THR92-2505 Topic 2 Question 67 Discussion
Actual exam question for SAP's C-THR92-2505 exam
Question #: 67
Topic #: 2
Question #: 67
Topic #: 2
You are creating a query for a historical compensation story report in Query Designer. You have added the Job Information table to the query, configured a scope filter, and previewed the result to verify you are returning the appropriate employees. You add the related table Compensation to the query.
When you preview the query, you only get the current compensation information for the employees. Why do you only receive the current records? Note: There are 2 correct answers to this question.
When you preview the query, you only get the current compensation information for the employees. Why do you only receive the current records? Note: There are 2 correct answers to this question.
Suggested Answer: B,D Vote an answer
* 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
* 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
by Bess at Dec 16, 2025, 01:32 AM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).