Workday-Pro-HCM-Reporting Workday Pro HCM Reporting Certification Exam Questions and Answers

TheReport Fields and Valuesoption is available via theRelated Actions iconfor fields on worker profiles. This is the quickest way to see whichbusiness objectis tied to the field (e.g., Job Profile) and which field values are available for reporting.

From the Workday documentation:

“To determine which business object a field belongs to and the values available for that field, select the Related Actions > Reporting > Report Fields and Values option.”

Thus, the quickest method isB. Select the job profile’s Related Actions icon and select Reporting > Report Fields and Values.

In Workday matrix reports, the number of rows returned is controlled by theMaximum Number of Rowssetting. By default, reports may limit output rows (for example, showing only the top 3). To display more results—such as the top 10 hiring sources—you must increase this value in the report definition.

From the Workday Reporting documentation:

“You can limit or expand the number of rows displayed in a matrix report by editing theMaximum Number of Rowsfield.”

“To display more than the default, update the value in the report definition.”

Therefore, the correct way to adjust this report to display the top 10 hiring sources isB. Edit the Maximum Number of Rows field.

Workday provides theScheduled Future Processes reportto review which reports are scheduled to run automatically. This report displays the recurrence details and execution times of all scheduled reports, allowing managers to confirm upcoming automated report runs.

From the Workday Reporting documentation:

“Workday provides scheduling options to run reports at set frequencies. You can confirm upcoming scheduled report runs in theScheduled Future Processes report.”

Therefore, the correct answer isD. The Scheduled Future Processes report.

When creating custom reports and visualizations, calculated fields can transform values. To change positive counts into negative values (such as terminations in a waterfall chart), you use theArithmetic Calculationfunction. This function allows you to perform math operations (addition, subtraction, multiplication, division) on numeric fields. By multiplying the Termination Count by -1, the result displays as a negative number.

From Workday Reporting documentation:

“Arithmetic Calculation – Performs mathematical operations on numeric fields. You can create new numeric outputs such as percentages, ratios, or negatives by applying arithmetic logic.”

Thus, the correct answer isC. Arithmetic Calculation.

To locate the correct fields and data sources for a custom report, Workday provides theBusiness Object Details report. This report displays all available fields, relationships, and related business objects that can be included in reporting. It ensures report writers can confirm which fields (e.g., Learning Content, Ratings, Popularity) are accessible for use.

From the Workday Reporting documentation:

“The report data source provides the view into the primary business object. This object gives you access to class report fields as well as links to related business objects.”

“The Business Object Details report is used to view which fields are available for reporting.”

Therefore, the correct answer isB. Run the Business Object Details report.

In composite reports,summarizations are driven by Detail Data fieldsprovided by each subreport. If you want to summarize results consistently byLocation across the entire composite report, Location must exist as aDetail Data field in every subreport.

Workday requires this consistency because composite-level summarizations rely on common fields across all subreports. If Location is missing from even one subreport’s detail data, Workday cannot reliably aggregate or align summarizations by that field.

From the Workday HCM Reporting documentation:

“To summarize composite report data by a specific field, that field must be included as detail data in all subreports.”

“Drillable fields enable navigation but do not support composite-level summarization.”

Including Location as drillable only affects drill-down behavior, not summarization. Including it in only one subreport results in incomplete aggregation.

TheLookup Related Valuefunction retrieves a value from a related business object. Since Compensation Group is not stored directly on the Worker object but instead through theJob Profilebusiness object, this function lets you traverse the relationship to return the related field into your report.

From Workday Reporting documentation:

“Lookup Related Value – Returns a field from a related business object. Use this to bring data from associated objects into a report when the field is not directly available on the primary object.”

Therefore, the correct answer isC. Lookup Related Value.

Report groupsallow multiple reports to be bundled together and scheduled as a package to distribute at a set frequency. In this case, the HR analyst can group all diversity-related reports and schedule them to run automatically each month for the HR director.

The Workday documentation explains:“Workday provides additional reporting features such as sharing, scheduling, and exporting reports. Reports can be grouped into report groups for easier scheduling and delivery.”.

While Report Bursting is used for distributing a single report with different data slices (e.g., sending each manager their team’s results), it is not suited for bundling multiple different reports. Embedded analytics are dashboards, not scheduling tools. Alerts notify users of conditions but do not manage recurring report packages.

Therefore,Report Groupsis the correct method for scheduling multiple reports together.

To connect multiple business objects in reporting, Workday provides theBusiness Object Details report. TheRelated Business Objects tabwithin this report shows how different business objects are linked (e.g., Worker to Dependent). This enables report writers to identify which fields connect the primary and secondary objects.

From the Workday Reporting documentation:

“The report data source provides the view into the primary business object. This object gives you access to class report fields as well aslinks to related business objects.”

Therefore, the correct answer isC. The Related Business Objects tab of the Business Object Details report.

Matrix reports in Workday allow grouping of data, applying summarizations, and drilling into the summaries for deeper analysis . To calculatepercentages relative to the overall total, Workday provides a built-in summarization option called“Percent of Overall Total.”This option is applied to numeric summarizations like “Number of Hires.”

From the Workday Reporting Guide:

“Matrix reports allow you to group data, summarize the metrics for each grouping, and drill into the summarizations for further analysis.”

“You can apply different summarizations such as Count, Sum, Average, andPercent of Overall Totalon numeric fields.”(Matrix Report Options – Workday Module 1 Binder)

Therefore, to show thepercentage of hires per recruiter relative to the grand total across recruiters and regions, you would select“Percent of Overall Total”on the Number of Hires summarization.

Matrix reports in Workday allow grouping and summarization of data, but to drill down through hierarchical structures such assupervisory organizations, you must configure hierarchy-aware calculated fields. TheLookup Hierarchy Rollupfunction enables drillable hierarchies, showing performance metrics at each level of the organizational tree.

The Workday binder notes:“Matrix reports allow you to group data, summarize the metrics for each grouping, and drill into the summarizations for further analysis.”. This means you can expand results from the top supervisory org down to teams and individual workers.

Using a simple Lookup Related Value would only pull in one field from a related object, not enable hierarchical drill-down. Similarly, changing sort order or adding overrides does not create drillable hierarchies. Only Lookup Hierarchy Rollup enables this behavior.

In Workday reporting, row ordering is controlled on theSort tabof the report definition. If you want the rows in a matrix report to sort by a specific field (such asTotal Count), you must add that field to theSort tab. Filters limit records, and summarizations define metrics, but sorting rules are explicitly defined in the Sort configuration.

From the Workday Reporting documentation:

“Sort – Control the order to present and group data. You can specify options for subtotals, grand totals, and outlines. Add a row on the Sort tab to define sorting by a particular field.”

Therefore, to sort rows byTotal Countinstead ofTotal Average Base Pay, the correct step isC. Add a new row to the grid on the Sort tab.

TheTrended Workersdata source contains bothsnapshot records(period-end views of worker data) andevent/transaction records(such as hires, terminations, and job changes). When the reporting requirement is to displayonly snapshot data, the most efficient and least disruptive approach is to apply areport-level filterusing the Snapshot (or Record Type = Snapshot) field.

Workday HCM Reporting documentation explains that filtering at the report level allows the system to limit returned records without changing global trending configurations or requiring additional processing. This approach hasminimal performance impactbecause it operates on already-generated trended data rather than forcing the system to recalculate or regenerate records.

Relevant documentation guidance includes:

“Trended Workers includes both snapshot and transaction records. Use report filters to restrict output to snapshot data when required.”

“Avoid changing system-wide trending configurations when report-level filtering satisfies the business requirement.”

The other options are less appropriate:

Setting default prompt values still allows non-snapshot data to be retrieved.

Trended Workers for Planning is a different data source with a different purpose.

Running Maintain Trended Workers changes system configuration and impacts all trending reports.

Workday’s configurable security model determines how much data a user can see in reports. If a user can only see their direct reports, they currently haveconstrained access. To view performance data for all workers, the user requiresunconstrained accessto the data source tied to the report field.

From Workday security documentation:

“Constrained security groups grant members access only to a subset of data… Unconstrained security groups grant users access to all target instances of a securable item.”

Therefore, the user needsD. Unconstrained access to the data source used in the report.