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.

Question

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.

Miguel Angel Rico MÃ¡rquez · Accepted Answer

The Job information table time filter is set to: As of Date > Dynamic Date: Today.

Miguel Angel Rico MÃ¡rquez · Accepted Answer

The compensation table time filter is set to: Same Filter as First Table.

Miguel Angel Rico MÃ¡rquez · Answer

The Query Advanced Filter is set to: Job Information effective start date equal to Dynamic Date: Today.

Miguel Angel Rico MÃ¡rquez · Answer

The compensation table time filter is set to: As of Date > Dynamic Date: Today.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 50 - C_THR92_2405 discussion

Suggested answer: A, B

0 comments