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

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, 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 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.

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.

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.

TheArithmetic Calculationfunction is designed for mathematical operations such as addition, subtraction, multiplication, and division. In this scenario, the bonus equals10% of monthly sales, so you need to multiply the sales field by 0.10.

The Workday documentation highlights:“Arithmetic Calculation – Creates a numeric field using mathematical operations performed on existing fields.”. This makes it the ideal choice for payroll- and incentive-related calculations.

Other options are less relevant: Evaluate Expression is for logical or Boolean conditions, Lookup Related Value is for retrieving fields from related objects (not calculations), and Sum Related Instances aggregates multiple rows of data but does not directly calculate percentages.

Thus, the arithmetic calculation provides a straightforward and efficient way to compute bonuses dynamically in the report.

TheTrended Workersdata source is specifically designed for reports that displaytrends over time, such as headcount, turnover, and demographics. It captures periodicsnapshots of worker data(monthly, quarterly, etc.), which allows organizations to track workforce metrics historically.

From the Workday binder:“Trended Workers captures snapshots of worker data at periodic intervals, providing historical reporting across time dimensions. This enables reporting on headcount, attrition, and demographics in a time series format.”

By contrast,Workers for HCM Reportingis used for current-state data, not trending.Worker Historyprovides effective-dated transaction-level history but does not automatically generate trending snapshots.Headcountis a standard delivered report and not a reusable data source for custom trending analysis.

Therefore, the most appropriate data source for worker headcount trends over time isA. Trended Workers.

Workday maintains ashared WDSetup tenantwhere customers can access the latest delivered content, including reports, dashboards, and calculated field templates. Customers must log in through theWorkday Community portalto access this tenant.

From the Workday binder:“The WDSetup tenant provides shared configuration content maintained by Workday. Customers can access the tenant through Workday Community to review the latest delivered reports and dashboards.”

The other options are incorrect: Object Transporter (OX) migrates content between customer tenants, not WDSetup. Customer Central is a separate tenant for learning, not for content review. The “What’s New” report shows system updates, not the latest WDSetup content.

Therefore, the correct answer isC. Sign in to the Shared WDSetup tenant through the Workday Community.

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.

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.

TheWorkday Standard Reports reportlists all delivered reports and key attributes. Only standard reports created with theReport Writer toolcan be copied and modified into custom reports. The “Type” column indicates whether the report is a Report Writer report.

From the Workday Reporting documentation:

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

Thus, the correct indicator isC. The report shows Report Writer in the Type column.

TheCustom Report Exception Audit reportidentifies errors in custom reports, such as missing security access. If a new report owner does not have access to one or more fields on the report, it will trigger acritical error.

From the Workday Reporting documentation:

“The Custom Report Exception Audit report identifies issues such as missing field access when ownership of a report is transferred.”

Therefore, the correct answer isA. The HR Analyst does not have access to all of the fields on the report.

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

To check whether a worker’s sick days exceed the threshold of 10, you must define aBoolean condition. The expressionSick Days Taken > 10evaluates to True when the value is greater than 10, and False otherwise.

From Workday Reporting documentation:

“True/False conditions can be created using numeric comparisons such as greater than (>), less than (<), or equal to (=). These return True or False depending on the worker’s data.”

Thus, the correct formula isA. Sick Days Taken > 10.

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.