Workday Updated Workday-Adaptive-Planning Exam Questions and Answers by ewan

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.

In Workday Adaptive Planning, a Metric account is the designated account type for displaying calculated Key Performance Indicators and financial ratios on the Income Statement and other financial reports. The profit margin ratio — Operating Income divided by Revenue, expressed as a percentage — is a derived KPI, not a transactional ledger balance. Metric accounts are formula-driven and read-only, meaning they calculate and display a result but cannot receive direct data entry. They support percentage formatting and can be configured to reference any combination of GL accounts, rollup accounts, or Assumption accounts within their formula. Metric accounts appear inline on financial statements alongside GL accounts, providing contextual performance visibility for planners and executives. A Custom account serves structural or supplementary roles not covered by standard account types. A General Ledger account stores transactional financial data such as actual or budgeted monetary amounts and is not appropriate for ratio display. A Calculated account is not a distinct, standard account type in the Adaptive Planning account classification framework for this use case. Metric is the authoritative, purpose-built account type for financial ratios and KPI display. Reference: Workday Adaptive Planning — Metric Accounts, KPI Configuration, Income Statement Design, Financial Ratios.

In Workday Adaptive Planning standard sheets, the Level Availability setting controls whether an account is available for data entry (editable) or restricted to read-only access at each level. To make the Office Supplies account read-only for all levels, the administrator configures the Level Availability for that account to be read-only or unavailable across the entire level hierarchy. This setting overrides any level-specific edit permissions and ensures that regardless of a user's Edit access to a level, they cannot modify the Office Supplies account values on that sheet. Initial View controls the default display state of the sheet (collapsed/expanded). 'Customization for sub-levels' allows different configurations for child levels but does not enforce a universal read-only rule across all levels in a single setting. Account Groups organize accounts into sections within the sheet but do not control editability. Level Availability is the specific, purpose-built setting for controlling account-level read/write access within a standard sheet configuration. Reference: Workday Adaptive Planning — Standard Sheet Configuration, Level Availability, Read-Only Account Settings.