Workday-Pro-HCM-Reporting Exam Questions

In Workday composite reports, sorting behavior is controlled at the column level, not globally. Each column in a composite report can be configured with its own sort order (ascending or descending). When a composite report is sorting by the last column, it means that column has an active sort configuration applied.

To change the sort to the second to last column and set it to descending, you must edit that specific column's configuration and adjust the sort settings accordingly. Workday evaluates column sorting in sequence, and the active column-level sort determines the output order.

From the Workday HCM Reporting documentation:

''Composite reports support column-based sorting. Sorting is defined within the column configuration and determines the order in which results display.''

''To change sort behavior, update the sort settings on the appropriate column.''

The other options are incorrect because dynamic data rows control layout flexibility, combine data rows merge subreport results, and report settings manage prompts and general options---not sorting logic.

In Workday, when you configure composite reports, you can map subreport prompts to prompt sets for greater flexibility. However, if the Do Not Prompt at Runtime checkbox is selected on the subreport prompt, the prompt will not be exposed in the Map 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 is B. The Do Not Prompt at Runtime checkbox is selected for the prompt on the subreport.

Matrix reports in Workday allow for grouping, summarization, and drill-through capabilities. To let managers dynamically refine report results at runtime, you configure Facet Filters. Facet Filters enable users to filter the report output interactively, without modifying the underlying definition.

From the Workday Reporting documentation:

''Matrix reports allow grouping and summarization of data. You can also configure facet filters so users can dynamically refine report results by selecting values such as Hiring Source or Location.''

Thus, the correct way to let the recruiting manager refine the output is D. Configure Facet Filters.

To locate the correct fields and data sources for a custom report, Workday provides the Business 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 is B. Run the Business Object Details report.

The Arithmetic Calculation function is designed for mathematical operations such as addition, subtraction, multiplication, and division. In this scenario, the bonus equals 10% 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.