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

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.

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.

To evaluate year-over-year changes in benefit costs and enrollments, you need historical data comparisons over time. TheTrending Reporttype is designed for exactly this use case, leveraging data sources likeTrended Workersto display snapshots at periodic intervals and calculate variances between time periods.

From the Workday binder:“Trending reports allow you to track changes to worker data across time. These reports support analysis of headcount, demographics, benefit enrollments, and cost variances year-over-year or month-over-month.”

Advanced and Matrix reports provide strong analysis capabilities, but they are based on current or related effective-dated data, not time-series snapshots. Composite reports combine multiple subreports but do not inherently manage trending data or variance calculations across years.

Therefore, the only correct option for year-over-year benefit enrollment and cost variance isD. Trending Report.

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.

Workday’sReport Performance Loghighlights processing time contributors such as “Top Level Filter Time.” If this is high, the best practice is toreplace report filters with built-in data source prompts, since prompts restrict data earlier in processing, improving performance.

From the Workday Reporting documentation:

“To improve report performance, leverage built-in data source prompts instead of filters whenever possible. Prompts reduce the data set retrieved before filters are applied, minimizing filter processing time.”

Therefore, the correct answer isB. Use built-in data source prompts instead of filters.

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

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.

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.

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.

Workday dashboards allow organizations to present multiple reports together in a consolidated, highly visual, and interactive format. For C-level executives, who require acomprehensive and regional view of annual average base pay, dashboards are preferred over individual reports or worklets because they enable grouping and comparison across multiple data sets.

From the Workday binder:“Dashboards provide an interface to view charts and sheets all in one place. This enables managers and executives to analyze key metrics and trends so they can make better decisions.”. By organizing reports by region within a dashboard, executives can quickly compare averages, identify trends, and take strategic action without needing to navigate multiple reports.

Worklets are lightweight tiles often used for single reports or quick tasks on the Home page. However, this scenario requires anorganized collection of reports, makingD. A dashboard, because we need information from a collection of reports, organized by regionthe correct answer.

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.