Workday Workday-Pro-HCM-Reporting - Workday Pro HCM Reporting Certification Exam

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.

In Discovery Boards, drill behavior is defined in theDrill By field list. To add Worker as a drillable option in just one visualization, the analyst canoverride the Drill By list in the Configuration Panelof that visualization. This allows Worker to appear as a drill dimension without altering the defaults applied across other visualizations.

From the Workday documentation:“You can override Drill By field lists in the visualization configuration panel. This enables drill customization on a per-visualization basis without impacting other discovery boards.”

The other options are less appropriate: Maintain Field Lists changes the default for all boards; adding Worker as a dimension affects grouping, not drilling; and sheet filter controls allow filtering but do not add drill options.

Thus, the correct choice isD. Override the Drill By field list and add Worker in the Configuration Panel for this visualization.

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

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.

For amatrix report to be used as a subreportin a composite report, the group-by fields in the matrix report must align with the fields enabled for filtering and grouping in the composite report. If this alignment does not exist, Workday does not allow the matrix report to appear as a valid subreport option in the Sub Report Name dropdown.

From the Workday binder:“To include a matrix report as a subreport in a composite, the group-by fields of the matrix must match the fields enabled for grouping in the composite report. If these do not match, the matrix will not appear in the Sub Report Name selection.”

Other factors such as prompt defaults or filter settings may impact usability, but they do not prevent the matrix report from being selectable. The key dependency is thefield alignment between the composite and the matrix group-by fields.

Therefore, the correct answer isA. Check that every field in the composite report's set of fields that are enabled for filtering and grouping also exists as a group-by field in the matrix report.

TheReport Fields and Valuesoption is available via theRelated Actions iconfor fields on worker profiles. This is the quickest way to see whichbusiness objectis tied to the field (e.g., Job Profile) and which field values are available for reporting.

From the Workday documentation:

“To determine which business object a field belongs to and the values available for that field, select the Related Actions > Reporting > Report Fields and Values option.”

Thus, the quickest method isB. Select the job profile’s Related Actions icon and select Reporting > Report Fields and Values.

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.

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.