New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Workday-Pro-HCM-Reporting Exam - Topic 1 Question 7 Discussion

Actual exam question for Workday's Workday-Pro-HCM-Reporting exam
Question #: 7
Topic #: 1
[All Workday-Pro-HCM-Reporting Questions]

You are configuring a matrix report that groups average performance ratings by supervisory organization. However, the report users would like to be able to drill down and view data at each level of the hierarchy. How should you edit the report definition to achieve this functionality?

Show Suggested Answer Hide Answer
Suggested Answer: D

Matrix reports in Workday allow grouping and summarization of data, but to drill down through hierarchical structures such as supervisory organizations, you must configure hierarchy-aware calculated fields. The Lookup Hierarchy Rollup function 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.


by Willetta at Nov 24, 2025, 06:35 PM

Limited Time Offer

25%

Off

Get Premium Workday-Pro-HCM-Reporting Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Coleen
10 hours ago
Wait, D) is a thing? I didn't know about Lookup Hierarchy Rollup!
upvoted 0 times
...
Jeniffer
6 days ago
C) won't help with drill-down functionality, just sorting.
upvoted 0 times
...
Vincent
11 days ago
I disagree, B) seems more effective for detailed views.
upvoted 0 times
...
Jolanda
16 days ago
A) is the way to go for drill-downs!
upvoted 0 times
...
Thurman
21 days ago
C) is just weird, why would we want a descending sort order?
upvoted 0 times
...
Stephaine
26 days ago
Wow, this question is really testing our report design skills!
upvoted 0 times
...
An
1 month ago
D) for sure, that's the best way to implement the drill-down hierarchy.
upvoted 0 times
...
Eliz
1 month ago
B) is the way to go, it's the most straightforward option.
upvoted 0 times
...
Ashley
1 month ago
D) seems like the right choice to enable drill-down functionality.
upvoted 0 times
...
Dean
2 months ago
I definitely think the drillable fields are important, so maybe option D is the right choice. I just wish I could remember more about how that works!
upvoted 0 times
...
Francoise
2 months ago
I remember practicing a similar question where we had to adjust the Detail Data grid, but I can't recall if it was about Lookup Related Values or something else.
upvoted 0 times
...
Annelle
2 months ago
I'm feeling pretty confident about this one. The question is all about enabling drill-down functionality, so the obvious choice is option D. The Lookup Hierarchy Rollup field is exactly what we need.
upvoted 0 times
...
Solange
2 months ago
Okay, I think I've got this. The question is asking how to let users drill down into the hierarchy, so the answer is definitely option D. The Lookup Hierarchy Rollup field should do the trick.
upvoted 0 times
...
Annice
2 months ago
This question is tricky. I feel unsure.
upvoted 0 times
...
Trinidad
2 months ago
I think we might need to include a Lookup Hierarchy Rollup calculated field, but I'm not entirely sure if that's the only step needed.
upvoted 0 times
...
Kiley
3 months ago
I'm a little torn between options B and D here. The Detail Data Override could potentially work, but the Lookup Hierarchy Rollup field in option D seems more targeted to the specific requirement of drilling down through the hierarchy. I think I'll go with D.
upvoted 0 times
...
Carma
3 months ago
Adding a Detail Data Override sounds familiar, but I feel like it might not directly address the drill-down functionality we're looking for.
upvoted 0 times
...
Antonette
3 months ago
Hmm, I'm a little confused. I was thinking maybe option B with the Detail Data Override would let us drill down, but I'm not 100% sure. Might need to re-read the question carefully.
upvoted 0 times
...
Lisandra
3 months ago
I'm not totally sure about this one. I think the key is being able to drill down into the hierarchy, so maybe option D with the Lookup Hierarchy Rollup field?
upvoted 0 times
...

Save Cancel