Workday Pro HCM Reporting Certification Exam Questions and Answers
Refer to the following scenario to answer the question below.
You have prepared the following matrix report for a recruiting manager.
The recruiting manager wants to dynamically refine the output results for various hiring sources and locations.
How can you achieve this?
A composite report sorts output based on the last column in ascending order. You want the sort to be based on the second to last column in descending order.
How do you make this change?
You are building a report to identify employees who have exceeded the allowed number of 10 sick days in the current year.
Using the Sick Days Taken field, what is the correct formula to create a Boolean calculated field that returns True if an employee has exceeded the allowed number of sick days?
A worker report uses a filter based on the Location field, using the comparison type Prompt the user for a value. A user runs this report and leaves the prompt value blank.
What Worker instances display on the output?
Refer to the following scenario to answer the question below.
You have prepared the following matrix report for a recruiting manager.
The recruiting manager would like to view the top ten hiring sources, rather than just three.
How can you adjust the report definition to address this requirement?
You have received a request for a new custom report that is similar to the Workday-delivered report Compare Workers, and you run the Workday Standard Reports report.
What information can you use to determine if you can copy Compare Workers to create a new custom report?
You are configuring a waterfall visualization showing employee movement. To properly display the information, you need the Termination Count field to return as a negative number.
An HR administrator shares a discovery board with a manager and gives the manager Can Edit permissions. The manager is able to open Drive and access the discovery board. However, upon opening the discovery board, the manager notices that there are placeholders for each visualization and the data does not display.
What permission does the manager need to view the data in the visualizations?
You only want to show snapshot data on a custom trending report that uses the Trended Workers data source.
How can you achieve this with minimal impact to report performance?
You need a calculated field that returns whether or not the initiator for a Manage Goals event is the worker's manager.
Refer to the following scenario to answer the question below.
You have prepared the following matrix report for a recruiting manager.
The recruiting manager wants the rows to sort by Total Count, rather than Total Average Base Pay.
How can you adjust the report definition to address this requirement?
You are configuring a matrix report that groups average performance ratings by supervisory organization. However, the report users would like to be able to drill down and view data at each level of the hierarchy. How should you edit the report definition to achieve this functionality?
An HR analyst has many visualizations in different discovery boards that use the Workers for HCM Reporting data source on the Worker primary business object. The analyst wants to drill into one of the visualizations by Worker. Upon drilling, the analyst notices that Worker is not a listed Drill By field option. They want to drill by Worker without editing the Drill By list of the other visualizations.
How would the analyst configure this?
The Recruiting department requested a report that shows job applications by recruiting source, displayed through count and percent summaries that they can drill into to further analyze the data.
What report type fulfills these requirements?
You are viewing a Report Performance Log and notice the Top Level Filter Time is high.
How should you edit the report definition to improve this?