MENU
Within a modeled sheet where users can select from different Benefit Elections stored as dimension values, what can you create to drive different rates in formula calculations based on the Benefit Election dimension value selected?
In Workday Adaptive Planning, a single value lookup table for the Benefit Election dimension is the correct design to drive different calculation rates based on which benefit election a user selects in a modeled sheet. A value lookup table maps each dimension value (e.g., Single, Family, Employee+Spouse) to a corresponding rate value, enabling the modeled sheet formula to dynamically look up the appropriate rate for whichever benefit election is selected on each row. This architecture is efficient, maintainable, and requires only one lookup object rather than separate tables per dimension value. Creating a separate value lookup table for each dimension value (Option C) is unnecessarily complex and duplicates data structures. A cube sheet (Option B) could store rate assumptions but requires a more complex reference architecture than a simple value lookup. A Rate dimension attribute (Option D) stores static metadata on dimension values and cannot drive time-sensitive rate lookups in calculations. The single value lookup table per dimension is the official, recommended pattern in Adaptive Planning's modeled sheet design. Reference: Workday Adaptive Planning --- Value Lookup Tables, Modeled Sheets, Dimension-Driven Calculations.