Workday-Adaptive-Planning Sample Questions Answers

In Workday Adaptive Planning, sub-versions can only be created under Plan versions. Sub-versions allow organizations to maintain multiple planning scenarios or iterations beneath a single parent Plan version — for example, a Best Case, Base Case, and Worst Case sub-version under a single Annual Plan. This structure supports scenario planning and budget iterations without creating entirely separate top-level versions for each scenario. Virtual versions are read-only versions derived from formulas that blend data from other versions; they do not support sub-versions. Actuals versions store historical financial data imported from the general ledger and are immutable in structure. Hidden versions are used for intermediate calculations and are not directly user-accessible. The sub-version feature is exclusively a Plan version capability, enabling planners to track multiple budget iterations within a controlled, hierarchical version structure. Reference: Workday Adaptive Planning — Version Management, Plan Versions, Sub-Version Creation.

The requirement specifies using the average monthly consulting expense from last year (total prior year divided by 12) then multiplying by (1 + inflation rate). The formula div(ACCT.ConsultingExpenses[time=this.year-1],12)*(1+ASSUM.Global_Inflation_Rate) correctly captures this: [time=this.year-1] retrieves the full prior year total, div(...,12) divides by 12 to calculate the average monthly value, and *(1+ASSUM.Global_Inflation_Rate) applies the inflation adjustment. Option A [time=this-12] references the same month from one year ago — a specific month's value, not an annual average. Option C omits the prior year time reference, using the current account value rather than last year's data. Option D retrieves the full prior year total without dividing by 12, which would apply inflation to an annual total rather than a monthly average. The combination of the annual prior year reference, division by 12, and the inflation multiplier makes Option B the precise implementation of the described estimation strategy. Reference: Workday Adaptive Planning — Time Modifiers, div() Function, Inflation Formula Patterns.

The Contributor permission set template in Workday Adaptive Planning is specifically designed for users who need to enter budget data into planning sheets while also being able to view reports and dashboards. Contributors can add and modify values in sheets they have access to, which satisfies the requirement to add values to existing plan estimates. They also receive read access to reports and dashboards, fulfilling the contextual visibility requirement. The Power User template grants broader administrative capabilities that exceed what a standard budgeter requires. View Only limits users to read-only access with no data entry capabilities, making it inappropriate for budget input. Implementor is an elevated administrative role for system configuration and model building. The Contributor template is the optimal baseline because it is scoped precisely to the data entry and reporting visibility functions described, and it can be further refined by the administrator to limit access to specific levels or sheets. Reference: Workday Adaptive Planning — Security and Permission Sets, User Roles, Contributor Template Configuration.

In Workday Adaptive Planning, account deletion is a permanent and irreversible operation. When the Rent account is removed from the model, all formulas and data associated with that account are immediately and permanently deleted across every version (Actuals, Budget, Forecast) and every level in the organizational hierarchy. There is no automatic reassignment mechanism — the system does not migrate data to sibling accounts such as Salaries, nor does it transfer data up to the parent rollup account Total Operating Expenses. There is no archiving or soft-delete function that preserves data in a recoverable state. The rollup account Total Operating Expenses will continue to aggregate data from its remaining children, but the Rent account's contribution is permanently lost. This behavior makes account deletion one of the most consequential structural changes an administrator can perform. Best practice requires administrators to export or document all account data before deletion and to audit any reports, dashboards, or formulas that reference the account being removed, as those references will produce errors post-deletion. Reference: Workday Adaptive Planning — Account Management, Account Deletion Behavior, Model Maintenance, Data Integrity.

In Workday Adaptive Planning standard sheets, cell background colors communicate the editability status of each cell to the user. A grey cell background indicates that the cell is read-only — it may contain a calculated value from a formula or display a rolled-up result, but the user cannot directly enter or modify data in that cell. Read-only cells appear grey to clearly differentiate them from white/editable cells, providing instant visual feedback about where data entry is permitted. This applies to cells that contain shared formulas, cells that are restricted by the sheet's Level Availability configuration, and cells that display rollup calculations. A white cell background indicates an editable cell where a user can enter values. Blue or colored cell backgrounds may indicate other states depending on configuration. Errors in cells are typically displayed with error text rather than a grey background. Rollup accounts do appear grey, but the grey color specifically means read-only, which is a broader category. Reference: Workday Adaptive Planning — Standard Sheet Interface, Cell Color Coding, Read-Only vs Editable Cells.

In Workday Adaptive Planning, View mode is the dashboard mode that enables users to interactively engage with dashboard charts by clicking on data points, bars, or other chart elements to drill into underlying data for deeper analysis. In View mode, charts are live and interactive — users can hover over data points to see values, click segments to filter or drill down, and explore data relationships dynamically. This interactivity supports analytical workflows where users need to investigate variances, examine underlying details, or navigate from summary charts to granular data. Presentation mode renders the dashboard in a static, display-oriented format optimized for showing to an audience, with limited interactivity. Grid mode may display data in a tabular format but is not designed for chart interaction. Snapshots capture the current state of a dashboard at a point in time as a static image for archival or comparison purposes. View mode is the standard operational mode for dashboard users who require analytical interactivity with visualized data. Reference: Workday Adaptive Planning — Dashboards, View Mode, Interactive Analytics, Data Exploration.

In Workday Adaptive Planning, General Ledger accounts such as Prepaid Advertising are created under Root accounts, which are the primary account categories that form the top-level structure of the Chart of Accounts. Root accounts represent the highest level of the account hierarchy and include categories such as Assets, Liabilities, Equity, Revenue, and Expenses. Prepaid Advertising, being a prepaid asset or operating expense account in standard accounting, would be created as a child of the appropriate Root account category. System accounts are pre-built accounts managed by Adaptive Planning for system-level calculations and cannot be user-created. Assumption accounts are reserved for global planning constants like rates and percentages. Contra accounts are used to offset balances in specific accounts (e.g., Accumulated Depreciation) and are a sub-classification, not a primary creation category. The correct workflow is to navigate to Modeling > Model Management > Accounts and create the new GL account under the appropriate Root. Reference: Workday Adaptive Planning — Chart of Accounts, Root Account Structure, General Ledger Account Creation.

In Workday Adaptive Planning, Accounts are the single required element to create a modeled sheet. A modeled sheet must have at least one account defined to represent the data being planned — accounts serve as the columns in a modeled sheet, capturing the various values for each row (record). Without an account, a modeled sheet has no data structure and cannot be created or saved. Dimensions are commonly used in modeled sheets to enable dimensional data entry and classification, but they are optional — a basic modeled sheet can function with accounts alone. Levels are not a creation requirement for modeled sheets; the sheet applies to levels through its assignment configuration, not as a creation prerequisite. Attributes are metadata elements used for filtering and grouping but are not required for sheet creation. The account is the foundational element of any Adaptive Planning sheet type — it represents what is being measured or planned. In the context of modeled sheets, accounts define the column structure of each planning row. Reference: Workday Adaptive Planning — Modeled Sheet Creation, Required Elements, Sheet Architecture.

In Workday Adaptive Planning, Dimensions and Attributes serve fundamentally different purposes within the planning model. Dimensions are used to tag and categorize planning data during entry or import — they are applied to sheets and accounts to enable multi-dimensional data input and reporting along axes such as Product, Project, Customer, or Location. When a dimension is added to a sheet, planners can enter data at the intersection of the dimension value, level, account, and time period. Attributes, by contrast, are used to tag existing model elements such as levels or accounts with descriptive metadata. For example, a Level Attribute might classify each level as a 'Cost Center Type' (Shared Services, Direct, etc.), or an Account Attribute might tag accounts by 'P & L Category.' Attributes do not create new data input axes — they add descriptive properties to existing elements for filtering and grouping in reports. This distinction is fundamental to Adaptive Planning's dimensional architecture. Reference: Workday Adaptive Planning — Dimensions vs Attributes, Dimensional Architecture, Model Design.

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.

The issue in the original formula is that ACCT.Lookups.Rate[Level=TopLevel(-)] retrieves the rate for all Product dimension values aggregated at the top level, rather than the rate specific to each individual Product dimension value being calculated. When the rate reference does not specify the Product dimension modifier, it pulls the aggregate (summed or unfiltered) rate value, resulting in inflated multiplication results. The corrected formula ACCT.Sales.Units * ACCT.Lookups.Rate[Level=TopLevel(-), Product=this] adds the 'Product=this' modifier, which instructs Adaptive Planning to look up the rate for the same Product dimension value as the current row being calculated. The 'this' keyword is a dynamic reference that matches the current dimension context. Level=TopLevel(-) correctly retrieves the globally-entered assumption rate (entered once at the top level), while Product=this ensures the rate corresponds to the specific product being evaluated. Without the Product=this modifier, the formula aggregates across all product rates, causing inflated results. Reference: Workday Adaptive Planning — Cube Sheet Formulas, Dimension Modifiers, 'this' Keyword, Level Modifiers.

The requirement specifies two components: (1) use the same period from last year to capture seasonality, and (2) apply the projected inflation rate for growth. The formula ACCT.Telephone[time=this-12]*(1+ASSUM.Global_Inflation_Rate) precisely implements this: [time=this-12] shifts back exactly 12 months to retrieve the same calendar period from the prior year, preserving seasonal patterns in telephone expenses. Multiplying by (1+ASSUM.Global_Inflation_Rate) applies the inflation uplift factor — the '1+' construct is the standard growth formula that maintains the base value and adds the inflationary increase. Option A uses the same time modifier but references a sales commission assumption, not the global inflation rate. Option B divides the current account by 12 and applies the rate as a multiplier, which does not reflect seasonal prior-year data. Option C references the current period's value without any prior-year time shift, ignoring seasonality entirely. The combination of [time=this-12] and the (1+rate) growth multiplier is a foundational Adaptive Planning formula pattern. Reference: Workday Adaptive Planning — Time Modifiers, Seasonality Formulas, Inflation Calculations.

In Workday Adaptive Planning, entering data at an (Only) level — which represents topside adjustments made directly at a rollup level, independent of its child levels — requires a specific permission setting. Users must have the 'Access to (Only) levels' permission enabled within their assigned permission set. This permission is not automatically included in standard Contributor permission sets and must be explicitly configured by an administrator. Without this permission, the (Only) level rows will appear greyed out or hidden on level-assigned sheets, and the user will be unable to enter data there even if they have Edit access to the parent level. This design is intentional: topside adjustments at rollup levels are a sensitive planning action that could affect consolidated results, so the permission is isolated and controlled. Simply having access to the parent or its descendants is insufficient — the (Only) access permission is a discrete, named privilege in the permission set configuration. Reference: Workday Adaptive Planning — Permission Sets, (Only) Level Access, Level-Assigned Sheets, Security Configuration.

A Metric account in Workday Adaptive Planning is specifically designed to display calculated Key Performance Indicators (KPIs) such as ratios, percentages, and performance measures that are derived from other account values. The profit margin ratio — calculated as Operating Income divided by Revenue — is a classic financial KPI that does not represent a ledger balance but rather a derived performance indicator. Metric accounts are formula-driven, read-only in nature, and are displayed on financial statements and reports alongside GL accounts to provide contextual performance insight. They support percentage formatting and can reference other account types in their formulas. Calculated accounts have a different architectural role in Adaptive Planning and are not the standard type for KPI ratios. General Ledger accounts store transactional financial data. Custom accounts serve structural or supplemental purposes. Metric accounts are the official account type for financial ratios and KPIs in the Adaptive Planning account hierarchy and appear under Model Management > Accounts. Reference: Workday Adaptive Planning — Metric Accounts, KPI Configuration, Financial Statement Display.