Workday-Pro-HCM-Reporting 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.

TheSubstring Textfunction in Workday calculated fields extracts a portion of a string based on character position and length. To capture the area code from a phone number (e.g., the first three digits of a 10-digit number), you define the substring starting at position 1 with a length of 3.

From Workday Reporting documentation:

“Substring Text – Returns a portion of a text string based on a starting position and specified length.”

Example: Phone number 4155551234 → Substring(1,3) = 415.

Therefore, the correct choice isA. Substring Text.

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.

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.

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.

Workday calculated fields allow users to manipulate dates, numbers, and text values. To calculate a new date based on an existing date field (e.g., Bonus Approval Date), you use theIncrement or Decrement Datefunction. This adds or subtracts a defined number of days, months, or years from the source date.

From Workday Reporting documentation:

“Increment or Decrement Date – Returns a date that is a specified number of days, months, or years before or after the value of the source date field.”

Example: If the Bonus Approval Date is 01/01/2025, adding 60 days using this function would return 03/02/2025.

Thus, the correct choice isA. Increment or Decrement Date.

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.

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.

To connect multiple business objects in reporting, Workday provides theBusiness Object Details report. TheRelated Business Objects tabwithin this report shows how different business objects are linked (e.g., Worker to Dependent). This enables report writers to identify which fields connect the primary and secondary objects.

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 aslinks to related business objects.”

Therefore, the correct answer isC. The Related Business Objects tab of the Business Object Details report.

When designing trending reports, theGroup by Time Period fielddetermines how the trended records are aggregated and displayed. By default, reports may show quarterly or annual rollups, but this can be easily adjusted tomonthlywithout needing to reconfigure or regenerate trending data.

From the Workday documentation:“In trending reports, the Group by Time Period setting allows users to choose the granularity of the results, such as monthly, quarterly, or annually. This setting controls the display of data in charts and tables.”

Other options are less appropriate: editing the Column Grouping grid changes report layout but not trending intervals, using a prompt does not change aggregation, and running the Maintain Trended Workers task changes system-wide trending setup, not individual report display.

Thus, the correct approach isB. Edit the Group by Time Period field in the report definition.