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

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.

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.

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.

The correct choice isLookup Related Value, because this function allows you to retrieve a field from a related business object that is not directly stored on your primary object. In this scenario, theprimary business object is Performance Review, which holds performance-related data but not job-related data such as Job Title. Since Job Title resides on theWorker business object, you need to link from Performance Review to Worker and then retrieve Job Title.

The Workday reporting guide explains:“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.”. This ensures the Performance Review data can be combined with Job Title for meaningful insights.

By contrast, Aggregate Related Instances is used to roll up multiple related values, Range Band applies thresholds, and Evaluate Expression Band is used for conditional ranges, not cross-object retrieval.

When creating a custom report, filters restrict which data records are returned. Workday allows different comparison types for filters. The option“Value specified in this filter”lets you hard-code a condition (for example,Time Type = Part-Time), so the report consistently returns only part-time employees without requiring user input.

From the Workday Reporting documentation:

“Filter – Add conditions to filter the primary business object.”

“Prompts – You can further narrow and refine your report results by having the user complete prompt fields before they run the report… or usevalue specified in this filterfor fixed filtering.”

Therefore, the correct answer isC. Value specified in this filter.

Workday’s configurable security model determines how much data a user can see in reports. If a user can only see their direct reports, they currently haveconstrained access. To view performance data for all workers, the user requiresunconstrained accessto the data source tied to the report field.

From Workday security documentation:

“Constrained security groups grant members access only to a subset of data… Unconstrained security groups grant users access to all target instances of a securable item.”

Therefore, the user needsD. Unconstrained access to the data source used in the 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.