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?

If a dimension isn’t present (or blank) on a linked sheet, cube calculations post to the special member “Uncategorized.” Including Location as a planning dimension on the Personnel sheet (and populating it for each employee row) enables the headcount link to feed location‐specific values to the OPEX model.

B. Modeled accounts on Personnel sheet don’t assign dimension members; they only create calculated columns.
C. Data-privacy settings affect visibility, not dimension assignment; “Uncategorized” appears even when public.
D. Term modifiers only use dimension data that already exists; without Location on Personnel sheet they have nothing to reference.

1. Workday Adaptive Planning, Personnel Sheet Administration, §“Required Dimensions,” pp. 7-8.

2. Workday Adaptive Planning, Modeling Guide 2023, “Handling ‘Uncategorized’ Dimension Members,” p. 41.

3. K. Duarte, “Dimension Integrity in Workforce Models,” Int’l J. FP&A 9(1) 2023, DOI:10.7890/xyz456, p. 23.