Workday-Pro-HCM-Reporting Exam Dumps - Workday Human Capital Management Questions and Answers

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.

Composite reports combine multiple subreports, and their summarizations depend on the fields configured in the subreports themselves. To enable consistent grouping and summarization across the entire composite report, theLocation field must be included as a Detail Data field in all the subreports. This ensures that each subreport provides the Location context required for composite-level summarization.

From the Workday binder:“Composite reports aggregate results from multiple subreports. To summarize or drill consistently on a specific field, that field must exist as a Detail Data field in all subreports included in the composite.”

If Location is only included in one subreport, summarizations in the other subreports would not align, and Location-based grouping would fail. Similarly, making Location drillable only affects drill-down options, not summary-level grouping across the composite.

Thus, the correct answer isA. Include Location as a Detail Data field in all the subreports.

Access to report fields in Workday is governed bysecurity domains. If a user lacks access to the security domain that secures specific report fields, those fields will not appear in the report output for that user.

From the Workday Reporting documentation:

“A security group gets access to a security domain, which is a predefined set of related securable items. Securable items can include reports, tasks, data sources, andreport fields.”

Therefore, the correct answer isC. The second user does not have access to the domain that secures the field.

When designing trending reports, theGroup by Time Period fielddetermines how the trended records are aggregated and displayed. By default, reports may show quarterly or annual rollups, but this can be easily adjusted tomonthlywithout needing to reconfigure or regenerate trending data.

From the Workday documentation:“In trending reports, the Group by Time Period setting allows users to choose the granularity of the results, such as monthly, quarterly, or annually. This setting controls the display of data in charts and tables.”

Other options are less appropriate: editing the Column Grouping grid changes report layout but not trending intervals, using a prompt does not change aggregation, and running the Maintain Trended Workers task changes system-wide trending setup, not individual report display.

Thus, the correct approach isB. Edit the Group by Time Period field in the report definition.

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.

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.

TheSubstring Textfunction in Workday calculated fields extracts a portion of a string based on character position and length. To capture the area code from a phone number (e.g., the first three digits of a 10-digit number), you define the substring starting at position 1 with a length of 3.

From Workday Reporting documentation:

“Substring Text – Returns a portion of a text string based on a starting position and specified length.”

Example: Phone number 4155551234 → Substring(1,3) = 415.

Therefore, the correct choice isA. Substring Text.

Workday offers several custom report types:Advanced, Matrix, Composite, Search, and Trending.

Advanced Reports: Allow sorting, filtering, grouping, totals, and charts but are not designed for percentage summarizations across grouped data.

Search Reports: Show search results based on facet filters, not suited for summarization and percentages.

nBox Reports: Used for displaying workers or positions across two dimensions (e.g., performance vs. potential).

Matrix Reports: Specifically designed for grouping data, applying summarizations (count, sum, percent), and drilling

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.

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.