The Workday Pro HCM Reporting Certification Exam (Workday-Pro-HCM-Reporting)

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, the Location 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 is A. Include Location as a Detail Data field in all the subreports .

In Workday Discovery Boards, visualizations such as pivot tables are based on summarized and grouped data. When you choose to generate a report from a Pivot Table visualization , Workday converts the visualization into a Matrix Report that includes only a table , preserving the row and column groupings and summarizations used in the pivot.

The Workday HCM Reporting documentation states:

“When generating a report from a pivot table visualization, Workday creates a matrix report that reflects the grouped and summarized structure of the pivot.”

“Charts are not included when generating reports from pivot table visualizations; the output is a table-only matrix report.”

Advanced Reports are generated from non-pivot, row-based visualizations. XpressO is not used for discovery board–generated reports. Matrix reports with charts are created only when the visualization includes a chart component, which pivot tables do not.

Therefore, the correct answer is B. Matrix Report (with only a table) .

Workday calculated fields allow users to manipulate dates, numbers, and text values. To calculate a new date based on an existing date field (e.g., Bonus Approval Date), you use the Increment or Decrement Date function. This adds or subtracts a defined number of days, months, or years from the source date.

From Workday Reporting documentation:

“Increment or Decrement Date – Returns a date that is a specified number of days, months, or years before or after the value of the source date field.”

Example: If the Bonus Approval Date is 01/01/2025, adding 60 days using this function would return 03/02/2025.

Thus, the correct choice is A. Increment or Decrement Date .

In Workday matrix reports, the number of rows returned is controlled by the Maximum Number of Rows setting. 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 the Maximum Number of Rows field.”

“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 is B. Edit the Maximum Number of Rows field .

In composite reports, drill-down functionality is controlled at the column level . By configuring drillable fields on the output columns, users can select values and view related details, such as worker name, location, and manager.

From the Workday documentation: “Drill-down values in composite reports are configured on columns. Columns can be set to include drillable fields, allowing users to select a value and view related data.”

Rows determine how data is grouped, prompts filter initial results, and subreports provide the raw data but do not directly control drillable field configurations.

Therefore, the correct configuration is C. In the composite report columns .

For a matrix report to be used as a subreport in a composite report, the group-by fields in the matrix report must align with the fields enabled for filtering and grouping in the composite report. If this alignment does not exist, Workday does not allow the matrix report to appear as a valid subreport option in the Sub Report Name dropdown.

From the Workday binder: “To include a matrix report as a subreport in a composite, the group-by fields of the matrix must match the fields enabled for grouping in the composite report. If these do not match, the matrix will not appear in the Sub Report Name selection.”

Other factors such as prompt defaults or filter settings may impact usability, but they do not prevent the matrix report from being selectable. The key dependency is the field alignment between the composite and the matrix group-by fields .

Therefore, the correct answer is A. Check that every field in the composite report's set of fields that are enabled for filtering and grouping also exists as a group-by field in the matrix report .

Access to report fields in Workday is governed by security 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, and report fields .”

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

When creating a custom report, filters restrict which data records are returned. Workday allows different comparison types for filters. The option “Value specified in this filter” lets you hard-code a condition (for example, Time Type = Part-Time ), so the report consistently returns only part-time employees without requiring user input.

From the Workday Reporting documentation:

“Filter – Add conditions to filter the primary business object.”

“Prompts – You can further narrow and refine your report results by having the user complete prompt fields before they run the report… or use value specified in this filter for fixed filtering.”

Therefore, the correct answer is C. Value specified in this filter .

Workday delivers many standard (delivered) reports that are available to all customers. These reports are a great starting point but are not editable directly. If the delivered report does not meet your requirements, you should copy it and then modify the copy to create a custom report . This ensures that you retain the delivered report as-is, while still tailoring the report output to your business needs.

From the Workday Module 1 and 2 Reporting sections:

“Workday delivers standard reports that are available for all customers. If necessary, you can copy many of the Workday-delivered reports to create a custom report and modify it as needed .”

“There still may not be a report that meets my specific needs though. In that case, I can either create a report from scratch or copy a delivered report and make changes .”

“Standard reports are already available in all customer tenants and span across the functional areas in Workday. Workday creates standard reports using either the report writer tool or XpressO. However, you can copy and modify reports created with report writer as needed .”

Therefore, the correct recommendation is to copy and modify the delivered Headcount By Job Profile report (Option D) instead of editing the original.