The data source used by the two tables only displays current (active) employees.
How would you configure a filter on the table End of Previous Year Headcount by Location to display data accurately?

Note: There are 2 correct answers to this question.

• A.Set the Range type to Offset
• B.Set a filter on Hire Date (Member)
• C.Set a filter on Hire Date (Range)
• D.Set the Range type to Standard

Comment: *

Name: *

Email: *

Verification: *

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.

• A.The compensation table time filter is set to: As of Date > Dynamic Date: Today.
• B.The Job information table time filter is set to: As of Date > Dynamic Date: Today.
• C.The Query Advanced Filter is set to: Job Information effective start date equal to Dynamic Date: Today.
• D.The compensation table time filter is set to: Same Filter as First Table.

Comment: *

Name: *

Email: *

Verification: *

A report consumer claims that a canvas report shared with them is NO longer available in Report Center. Upon your investigation, you find the report has been deleted. You need to reproduce the report as quickly as possible.
What action do you take?

• A.Use the Recycle Bin to restore the Report.
• B.Use the Restore Deleted Report tool to restore the report.
• C.Create a new report and add orphaned pages. Share the report.
• D.Contact Successfactors support to request the report be restored.

Comment: *

Name: *

Email: *

Verification: *

You want to create a report that shows one row per employee, that includes the total number of previous employers for each employee.
Which tool must you use?

• A.Runtime Filters
• B.Calculated Columns
• C.Aggregated Calculated Columns
• D.Date Options

Comment: *

Name: *

Email: *

Verification: *

You create a query using the Basic User Information table. After you add the Proxy Information table, you notice that some of the basic information records are NO longer displayed in the preview.
How do you adjust the query to return the missing records in the preview?

• A.Change the join type to Left Outer Join.
• B.Remove the related table and add it using the Show Related Tables command form the Action Menu.
• C.Change the join type to Inner Join.
• D.Remove the related table and select and drag it from the Available Data section.

Comment: *

Name: *

Email: *

Verification: *