clapgeek logo
When constructing an expression for a calculated column in Query Designer, which syntax should you use to enter a date?
An administrator creates a new MDF object for storing attachments related to an employee's dependents. After uploading some test data, the administrator states they are unable to report on the new data with Advanced Reporting tool in a canvas report. The administrator is working for a client that has already had their system transitioned to Workforce Analytics on SAP HANA. How can the administrator quickly make the data available for reporting?
You are working with nested labels on your instance in Report Center.
How do you configure the labels as displayed in the screenshot? Note: There are 2 correct answers to this question.
In the Advanced Reporting tool, you want to create a query where the results meet the following criteria: Only show one row per employee, Only show the pay components Base Salary and Bonus, Show these pay components as individual columns. You have joined the Global Job Information table with the Compensation table.What else must you do? Note: There are 2 correct answers to this question.
When you create a table report with filter groups, what is the logical relationship between filter groups?
Why would you export report definitions? Note: There are 2 correct answers to this question.
You want to create a query that shows only the current Job Information data for each employee. On the Job Information table, which date type configurations can you use? Note: There are 2 correct answers to this 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.
Which permissions should you assign to allow a user to add a new story that will include Career Development Planning data? Note: There are 2 correct answers to this question.
When you format a list report component, which actions can you perform? Note: There are 3 correct answers to this question.
You have a field in Job Information that stores the assignment of an employee to a Generic Object record for a Company Car Company Car records include an Assignment Date of the Car. You want to create a query that includes the Employee Information, and also include the Assignment Date of the Car. You add the Job Information Table toQuery Designer. What steps do you take to accomplish the query? Note; There are 2 correct answers to this question.
You are creating a calculated column to calculate an employee's organizational tenure. Why does the formula in the screenshot result in an error?
You are building a performance report with the Story report type. In reviewing the Performance Management schema, you notice that the 2019 Performance Review Table is listed in the Available Data section. You begin the query by adding the Basic User Information table from the User schema. You notice that the 2019 Performance Review Table is NO longer listed in the Available Data section. Why is the 2019 Performance Review table NOT in the list?
Within a Story, 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?
You support report consumers. A report consumer asks if it is possible to save the selected items
when viewing the detail of a chart in a story report (see screenshot).
How do you tell the report consumer to save the state? Note: There are 2 correct answers to this question.
You create a report page and want to change the grid column width and grid row height of the Page Designer. Where can you do this?
What is a prerequisite for using the SuccessFactors standard canvas report templates?
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.
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?
An executive reviews a canvas report on employee compensation. The executive discovers that NOT all employees are included in the report. You need to adjust the report so that all employees are included by default, but included employees can be adjusted at runtime. How do you accomplish this task? Note: There are 2 correct answers to this question.
TESTED 30 Jan 2025