Workday Workday-Adaptive-Planning - Workday-Adaptive-Planning

In Workday Adaptive Planning, when a cube sheet is configured at the Year time stratum, all data stored in that sheet exists at the annual level — not at monthly periods. When formulas on monthly sheets or other sheets reference accounts from this year-stratum Rates cube sheet, the reference must include the [time=this.year] modifier to correctly resolve the time dimension. Without this modifier, a monthly formula attempting to reference a year-stratum account may return zero or an error because the system cannot automatically match a monthly time context to an annual data point. The [time=this.year] modifier explicitly instructs the formula to retrieve the annual value corresponding to the year in which the current period falls. Automatic breakback does not apply to formula references from external sheets. Monthly inputs cannot aggregate to a year-stratum cube sheet — data must be entered at the year level. References across different time strata require explicit time modifiers to ensure correct data retrieval. Reference: Workday Adaptive Planning — Cube Sheet Time Stratum, Cross-Sheet References, [time=this.year] Modifier.

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.

Workday Adaptive Planning supports alternate reporting hierarchies through the use of level dimensions and level attributes, which allow users to tag and classify levels according to groupings that exist in external systems of record such as Workday HCM or Workday Financial Management. This approach preserves the primary level hierarchy while enabling reporting along alternate dimensional structures without restructuring the core model. Level dimensions enable slice-and-dice reporting across dimensions that cross-cut the standard hierarchy, while level attributes allow metadata tagging of individual levels for grouping in reports and dashboards. Neither modifying the system of record nor creating parallel rollup structures represents a maintainable or scalable solution. The 'For reporting purposes only' checkbox applies to specific use cases but does not comprehensively support alternate hierarchy reporting across the model. Level dimensions and attributes are the recognized, official design pattern for multi-hierarchy reporting in Adaptive Planning. Reference: Workday Adaptive Planning — Level Attributes, Level Dimensions, Alternate Hierarchies, Reporting Configuration.

In Workday Adaptive Planning, modeled sheets offer flexibility in time stratum configuration, allowing administrators to select any time stratum that is defined and available in the instance's calendar — including Month, Quarter, Year, or any custom stratum configured for the instance. This flexibility distinguishes modeled sheets from some other sheet types that may be bound to the default instance time stratum. For example, a Personnel modeled sheet might be set to a monthly stratum for per-pay-period tracking, while a Capital Projects modeled sheet might use an annual or quarterly stratum. The available strata are determined by the time calendar setup in the instance. The time stratum for a modeled sheet is not determined by the version's time stratum (versions inherit the instance default). It is not limited to quarterly only. It is not restricted to the instance default — the key advantage of modeled sheets is the ability to choose from all available strata. Reference: Workday Adaptive Planning — Modeled Sheet Configuration, Time Stratum Selection, Sheet Design.

Assumption accounts in Workday Adaptive Planning are purpose-built for storing global constants — such as inflation rates, tax rates, or standard multipliers — that are referenced across multiple formulas and sheets. By design, Assumption accounts allow data entry at the Top Level (Only), meaning a single value is maintained centrally and referenced uniformly throughout the model. This aligns with best practices for model maintainability: rather than hard-coding values into individual formulas, a central Assumption account serves as the single source of truth. When the inflation rate changes, the administrator updates one cell, and all dependent formulas recalculate automatically. This eliminates version drift and ensures consistency across the entire model. Modeled accounts are used for row-based planning; Metric accounts display calculated KPIs but are not editable input stores; Custom accounts have different structural roles. Assumption accounts are foundational in Adaptive Planning's architecture and appear prominently in the Accounts configuration under Model Management. Reference: Workday Adaptive Planning — Accounts Setup, Assumption Account Configuration, Model Management.

In Workday Adaptive Planning, the Formula Assistant is the built-in tool designed specifically to help users construct, validate, and test formulas within the system. The Formula Assistant provides an interactive interface for browsing available functions (such as div, divf, if, sum), selecting valid account references, choosing appropriate time modifiers, and reviewing function syntax — all without requiring the user to memorize formula syntax from scratch. It provides real-time syntax guidance, function descriptions with parameter explanations, and the ability to test formula logic against actual data before committing. This is the primary tool for formula development and validation in Adaptive Planning. Account Details provides metadata about an account's configuration but does not assist in formula construction. Linked Accounts shows accounts that reference each other but is not a formula building tool. Shared Formulas is a method for applying the same formula across multiple levels or accounts but is not an interactive assistance feature. The Formula Assistant is the official, purpose-built formula construction tool in Adaptive Planning. Reference: Workday Adaptive Planning — Formula Assistant, Formula Development, Account Formula Configuration.

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.

In Workday Adaptive Planning, the default time stratum is Month > Quarter > Year. To reference the same quarter from one year ago, the correct time modifier is [time=this.qtr-4], which shifts back four quarters (equivalent to one year) from the current quarter. The divf() function performs a floating-point division of the quarterly total by 3 to derive a monthly average. This is correct because a quarter contains 3 months, and dividing the quarterly amount by 3 yields the average monthly value for that quarter. The formula divf(ACCT.Example[time=this.qtr-4] , 3) retrieves the total value for the quarter that is four quarters prior and divides by 3 to return the average monthly value. Option B uses this.year-1, which references the full prior year rather than the same quarter. Option C's syntax [time=this.qtr, this.year-1] is not valid Adaptive Planning formula syntax. Option D uses a month range modifier that does not correctly target a full quarter. Reference: Workday Adaptive Planning — Time Modifiers, Quarter References, divf() Function, Formula Syntax.