Workday-Pro-HCM-Reporting Practice Exam Questions with Answers Workday Pro HCM Reporting Certification Exam Certification

Sorting in composite reports is determined at thecolumn level, not at the combine row or general report settings. If the output currently sorts by the last column, that is because the sort option was applied there. To change the sorting behavior to the second-to-last column and in descending order, you mustedit that specific column’s configuration.

From the Workday binder:“Composite reports allow sorting based on columns. To change sorting behavior, adjust the column configuration, specifying ascending or descending order.”

The other options are incorrect: “combine data row” merges subreport outputs, not sorting; “dynamic data row” generates flexible rows but doesn’t control sorting; and “report settings” manage prompts and scheduling, not output order.

Therefore, the correct action isB. Edit the second to last column.

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.

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.

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.

Reports in Workday respectdata source security constraints. Different users may see different results in the same report if their access is limited. For example, an HR analyst may have constrained access only to certain organizations or workers, while the Chief People Officer may also have constraints.

From Workday Reporting and Security documentation:

“Report results differ between users if security constraints apply. Constrained security groups grant access only to specific target data (e.g., workers in certain supervisory orgs), while unconstrained groups can view all data.”

Thus, the likely cause is thatboth the Chief People Officer and the HR analyst have constrained access to the data source. Correct answer:C.

If a recruiter sees an empty dashboard tile, the most likely cause isconstrained security access. Even though the dashboard is properly configured and the worklet is enabled, Workday’s security framework ensures that report results vary by user depending on their role and assigned constraints.

From the Workday Reporting binder:“Report results differ between users if security constraints apply. Constrained security groups grant access only to a subset of data… Unconstrained security groups grant users access to all target instances of a securable item.”.

In this scenario, the recruiter likely has constrained access to only their supervisory organization or region. As a result, the “Top New Applications by Job Profile” report returns no records in the worklet tile.

Other options are less likely: if the recruiter lacked access to the report entirely, the tile would not appear; required vs. optional dashboard configuration would not impact existing data visibility; and domain-level security applies to report access, not data filtering.

Therefore, the correct answer isC. The recruiter has constrained access to the report's data source or data source filter.

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