Workday Workday-Pro-HCM-Reporting Workday Pro HCM Reporting Certification Exam Exam Practice Test

For amatrix reportto be eligible as asubreport in a composite report, Workday requires strict alignment between the composite report’s enabled fields and the matrix report’sgroup-by fields. Specifically,every field enabled for filtering and grouping in the composite report must also exist as a group-by field in the matrix report.

If this alignment does not exist, Workday excludes the matrix report from theSub Report Nameselection list because the system cannot reliably aggregate or align the summarized data across reports.

Workday HCM Reporting documentation states:

“When using matrix reports as subreports in composite reports, the group-by fields must align with the composite report’s enabled grouping and filtering fields.”

“Matrix reports that do not meet grouping alignment requirements will not be available for selection as subreports.”

The other options do not control subreport eligibility:

Summarization fields affect calculations, not availability.

Filter alignment is validated later, not at selection time.

Prompt defaults do not determine whether a report appears in the Sub Report Name field.

In Workday, when you configure composite reports, you can map subreport prompts to prompt sets for greater flexibility. However, if theDo Not Prompt at Runtimecheckbox is selected on the subreport prompt, the prompt will not be exposed in theMap Sub Report Prompts grid. This is because Workday interprets the prompt as suppressed and therefore not available for mapping at runtime.

From the Workday binder:“Prompts suppressed with the Do Not Prompt at Runtime option will not appear in the Map Sub Report Prompts grid in composite report configuration. To map a subreport prompt, ensure the prompt is enabled at runtime.”

Other options do not directly cause this issue: default values on prompts do not suppress them, security issues would block data but not hide the prompt mapping, and prompt set configuration errors affect defaulting but not visibility.

Thus, the correct answer isB. The Do Not Prompt at Runtime checkbox is selected for the prompt on the subreport.

Workday delivers manystandard (delivered) reportsthat 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 shouldcopy it and then modify the copyto create acustom 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 cancopy 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 orcopy 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 cancopy and modify reports created with report writer as needed.”

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

When reports useIndexed Data Sources, performance issues can arise if sorting is attempted on fields that are not indexed. In the case of the Worker object, sorting directly by the Worker object field is slower. Workday best practice is to sort bytext-based fields such as the “Full Name (text)” field, which improves query performance because it leverages indexed fields.

From the Workday reporting materials:

*“For indexed data sources, performance improves when sorting by text fields such as Full Name (text), instead of object fields. Sorting by object fields causes slower performance, whereas text-based fields use the

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.

Performance issues often occur when trending reports pull fields from related business objects instead of directly from theTrended Workers data source. This requires Workday to join across objects at runtime, slowing down report execution. To improve performance, you shouldadd the required field to the Trended Workers data source, ensuring the data is pre-joined and optimized for trending.

From the Workday binder:“To improve performance, add commonly reported fields directly to the Trended Workers object. Using related business object fields requires additional joins and increases report runtime.”

Creating calculated fields adds complexity rather than improving speed. Purging or re-creating trending data maintains system hygiene but does not address field-level performance.

Thus, the correct solution isA. Add the field to the Trended Workers data source.

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.

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.

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.

In composite reports, drill-down functionality is controlled at thecolumn 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 isC. In the composite report columns.

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.

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.

Workday report filters allow prompts so users can enter values when running a report. If theprompt value is left blank, Workday treats it as though no filter condition has been applied, so the system returnsall available Worker instances regardless of the Location field.

From the Workday Reporting guide:

“Prompts – You can further narrow and refine your report results by having the user complete prompt fields before they run the report. You can set default values for prompts… If left blank, the filter condition is ignored and all data is returned.”

Therefore, the correct answer isD. All Worker instances, regardless of the value of the Location field.

Duplicate prompts occur in composite reports when multiple subreports request similar or identical inputs, such as Company, Date, or Organization. The recommended and most scalable solution is to use aPrompt Setconfigured at thecomposite report level.

Prompt sets allow you toconsolidate duplicate prompts into a single prompt, which is then mapped to the corresponding prompts in each subreport. This ensures a clean user experience and consistent filtering across all subreports.

From the Workday HCM Reporting documentation:

“Composite reports support prompt sets to consolidate duplicate prompts across subreports.”

“Configure prompt sets in the composite report’s Report Settings to eliminate redundant user prompts.”

The other options are not best practice: default values do not remove duplicate prompts, suppressing prompts reduces flexibility, and managing prompts individually in subreports defeats the purpose of composite-level control.

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.

Workday provides multiple types of data sources when creating reports. Among them,Indexed Data Sourcesare specifically designed for performance optimization on large data volumes. They allow faster retrieval and better scalability when working with high record counts, because they are pre-optimized for reporting and queries.

From the Workday Reporting guide:

“Indexed data sources provide optimized performance for large data volumes. These data sources are indexed on commonly used fields and are specifically designed to support high-performance queries.”

Thus, the correct choice isA. Indexedfor ensuring performance with large datasets.

Discovery boards in Workday Prism or Analytics rely on underlyingdata sourcesto populate visualizations. Even if the manager has Can Edit or Can View access to the discovery board itself, they still needaccess to the domains or data sources used in the visualizations. Without this, placeholders appear instead of data.

From the Workday binder:“Discovery boards enforce Workday security. Users must have access to the underlying data sources or domains to view data in visualizations, regardless of board permissions.”

Giving “Can View” permissions on the visualization object itself or Drive access only affects sharing, not data. Discovery Boards: Create allows building new boards, not data access.

Therefore, the manager must haveA. The data source used in each visualization.