Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Workday-Adaptive-Planning Exam - Topic 1 Question 7 Discussion

An OPEX model uses headcount data linked from a personnel sheet. When testing with sample data, all expense results appear in the location dimension value of 'Uncategorized.' What corrections need to be made to populate the location values?
A) The personnel sheet needs to be planned with the location dimension.
B) The personnel sheet needs modeled accounts for each location.
C) The OPEX formulas need to have Data Privacy set to 'Public at all levels.'
D) The OPEX formulas need term modifiers for location.

Workday-Adaptive-Planning Exam - Topic 1 Question 7 Discussion

Actual exam question for Workday's Workday-Adaptive-Planning exam
Question #: 7
Topic #: 1
[All Workday-Adaptive-Planning Questions]

An OPEX model uses headcount data linked from a personnel sheet. When testing with sample data, all expense results appear in the location dimension value of 'Uncategorized.' What corrections need to be made to populate the location values?

Show Suggested Answer Hide Answer
Suggested Answer: A

When expense results in a linked OPEX model appear under the 'Uncategorized' location dimension value, it indicates that the source personnel sheet data does not carry location dimension information. In Workday Adaptive Planning, when a cube or modeled sheet references data from another sheet via a linked account formula, the dimension values present in the results are determined by the dimension values present in the source data. If the personnel sheet was not planned with the location dimension --- meaning location was not used as a planning axis when entering headcount data --- then the location dimension has no value assigned to those rows, and the system classifies them as 'Uncategorized' in the OPEX output. The solution is to configure the personnel sheet to include the location dimension as a planning axis, so that headcount entries are tagged with specific location values. Adding formula term modifiers for location in OPEX would not resolve the root cause, which is missing dimensional data at the source. Reference: Workday Adaptive Planning --- Dimensional Data Linking, Location Dimension, Cube Sheet Architecture.


Contribute your Thoughts:

0/2000 characters
Jerry
2 hours ago
I feel like we discussed needing to model accounts for each location in class. So, option B might be the right choice, but I need to double-check my notes.
upvoted 0 times
...
Nakita
5 days ago
I'm a bit confused about the role of Data Privacy here. Does option C really affect how the location values are populated?
upvoted 0 times
...
Carma
10 days ago
I think we had a similar question in practice where the location wasn't specified correctly. Could it be option D?
upvoted 0 times
...
Emelda
16 days ago
I remember something about linking dimensions, so maybe option A is correct? But I'm not entirely sure if that's enough.
upvoted 0 times
...

Save Cancel