Skip to main content


Workday Adaptive Planning Knowledge Center


Access Rules

Access rules define specific intersections of data that users or groups can edit or view.


An account is a container that groups actuals or planning information, like expenses, assets, liabilities, sales, and any business metrics.

Account Groups 

An account group, is a folder-like organization tool that contains accounts in the account lists, without summing the totals. 

Account Rollup

An account rollup is the total for an account that has child accounts. For example, a Travel account rollup can include hotel expenses, car rental, and airfare. 

Actuals Version

Actuals versions contain your actual financial results for a given period of time, like your income or expenses from May 2020. Actuals are records of events that happened. 

Admin Publishing

Admin Publishing enables administrators to make multiple changes to an instance and publish them all at once, rather than publishing each change individually.

Allocation Rules

Allocation rules define the calculations used to distribute values (like expenses and incomes) to different parts of your organization.

Area Chart

An area chart visualizes trends as data points, where the x-axis is time or dimension. This chart is similar to a line chart with color fills between the line and the threshold.


An assumption is a global value that is accessible to all users when writing formulas in their own plans. Assumptions can vary over time and have different values in different versions, but will have the same value at all levels and in every account.

Assumption Account

Assumption accounts, also called global assumptions, drive calculations in other accounts.  Some examples of assumption accounts include Standard Raise %, Commission Payout, Bonus Payout. The data in these accounts drive calculations based on other data, such as the annual salary per employee. You enter the value of assumption accounts at the Total Company level and the values are the same on every level. 


An attribute is a logical grouping with a list of possible values. Use attributes to tag accounts, dimensions, and levels. Create attributes to represent different rollup hierarchies for your organization. 

Audit Trail

Audit trail provides a history of user-entered changes on sheets. This information helps to answer questions about where and when the data originated in a cell, who made the latest changes. The audit trail also tracks changes resulting from imports and formula updates.

Bar Chart

A bar chart visualizes multi- data series as horizontal columns, where the y-axis is time or dimension. This chart is similar to a column chart where the axes are switched.


A breadcrumb is a navigational aid to help users track their location in the user interface. 


Breakback is a set of rules used to spread a value entered in a time rollup back into the time units within the rollup.

Calculated Account

Designed for computational efficiency, a calculated account contains a single formula that is consistent across all plans and is used to run calculations on data from elsewhere in your model. Metric accounts are a type of calculated account. 

Column Chart

A column chart visualizes a data series as vertical columns, where the x-axis is time or a dimension.

Consolidation Percentage

A consolidation percentage is the percent of a company owned. Sometimes called a minority interest. 

Crosstab Chart

A crosstab visualizes data in tabular format. This chart is often used to compare relationships between data sets.


cumulative translation adjustment (CTA) is an entry in the comprehensive income section of a translated balance sheet summarizing the gains/losses resulting from varying exchange rates over a certain time period.

Cube Sheet

A cube sheet is a type of sheet that allows for multi-dimensional data input in a few accounts across a potentially large set of dimensions.

Cumulative Translation Adjustment

cumulative translation adjustment (CTA) is an entry in the comprehensive income section of a translated balance sheet summarizing the gains/losses resulting from varying exchange rates over a certain time period.

Custom Account

custom account is an account that can hold any kind of numerical data or formulas. The rollup logic for time, dimension, and level is flexible as are many of the settings that create accounts with unique capabilities. 


A dashboard is a container for grouping a series of charts or other data analysis often by a theme or subject.


A dimension is an accounting characteristic with a list of possible values. Use dimensions in all types of sheets. A product dimension can represent the product lines and products sold by your corporation. A job dimension can represent the job titles assigned to employees. A level dimension can provide an alternate rollup structure for your organization. 

Doughnut Chart

A doughnut visualizes a data series as a circular chart. This chart is similar to a pie chart without the center.

Element Group

An element group is a collection of elements that you can apply to a report row or column. Each element in the group adds as a new row or column.


Elimination is the process of negating the financial effect of two or more account balances under the umbrella of a common parent.

Elimination Level

An elimination level is the level at which inter-company account balances are eliminated.

Formula Assistant

The Formula Assistant is a tool to help you construct syntactically-correct formulas. You can use it to insert valid accounts, assumptions, qualifiers, and functions into a formula. 

Element Group

An element group is a collection of elements that you can apply to a report row or column. Each element in the group adds as a new row or column.

Funnel Chart

A funnel visualizes data segmented by a category. This chart type is often used to show progression in business phases, such as a sales cycle or manufacturing process. This chart type can help you identify potential revenue at various sales stages or identify inefficiencies in a production line.

Gauge Chart

A gauge visualizes data as a meter (speedometer) or gauge. Often used to represent percentages, such as a gross margin percentage or EBITDA percentage. Zones indicate if the metric is good, fair, or bad.

General Ledger Account 

A general ledger account (GL) for planning mirrors the accounts in your real-world general ledger. The settings follow standard accounting principles in general. Many of the general ledger accounts are built into the account tree.  


An instance is the collection of structural components that define a fully-functional  planning entity. Sometimes called an installation, an instance consists of a single set of accounts, organization structure, versions, dimensions, attributes, sheets, versions, permissions, fiscal years, integrations. Workday allows multiple planning instances. 

Instance Tree

The instance tree lets you link instances together in a hierarchy or tree. They can have any number of instances with any level of hierarchy.


Integration Management is a secure bridge to import data from different data sources like spreadsheets, databases, on-premises sources, and cloud sources into Adaptive Planning.

Journal Entry Version

Journal entry versions are a type of sub-version that allows consolidation instances to maintain the integrity of their imported actuals. Instead of changing the data, you create journal entries that adjust the data. These adjustments must be balanced, meaning that the sum of all debits in an adjustment must be equal to the sum of all credits before the journal entry can be posted. Create multiple journal entry versions for IFRS to GAAP, Accruals, and reclassifications.

KPI Chart

A KPI (key performance indicator) visualizes a metric in way that helps you understand how your business is doing relative to set goals.

Leaf Strata

The leaf strata are the smallest unit of time in a time structure. Only time periods in the leaf strata can contain data.


Levels are the organizational structures of your business. For example, levels represent departments, profit centers, cost centers, or geographical regions.

Level Owners

Level owners have special privileges for the levels they own. If your instance uses level-based security, level owners are also the main way you control access to data.

Level Rollups

Level rollups are totals calculated from values entered in sublevels for accounts.

Level Workflow Task

A level workflow task is a type of task that is assigned to a level (not a specific user). Only level owners see this type of task.

Line Chart

A line chart visualizes trends as data points, where the x-axis is time or dimension.

Linked Level

A linked level is a level in a parent (target) instance that inherits some or all the data from the top level of a child (source) instance.

List Dimension

A list dimension is a dimension that is entirely non-hierarchical. It has no sub-dimensions and no hierarchy of dimension values, only a flat list of values.

Locked Version

A locked version has data that cannot be altered or edited.  With the appropriate permissions, administrators can lock and unlock versions. 

Metric Account

A metric account holds a formula that calculates ratios and metrics. Metric accounts pull data from other accounts. For example, Gross Margin % is a metric account that uses a formula based on the values in the Gross Margin and Revenue accounts.  

Modeled Sheet

Modeled sheets are for entering record-based data. The sheet has customized field names across the columns and records as rows. A modeled sheet contains the underlying business logic for modeling financial events, such as revenues generated from sales, monthly salaries of personnel, or the depreciation of capital purchases.


Multi-Instance is a feature enabling multiple planning instances to be linked together in a hierarchical fashion. Data from a child instance can be brought up automatically based on mappings established between accounts and dimensions. See also Instance.

Navigation Icon

The navigation icon appears in the upper left corner of the interface. Click this icon to open the navigation menu. 

Organization Structure

An organization structure models the operations of your company and the way data rolls up for planning and analysis purposes. Also known as the hierarchy of levels. See also, level.

Owned Levels 

See level owner.


A perspective is a group of dashboards and charts, usually focused on a common function such as finance or sales.

Perspective Context

perspective context is a set of system or admin-defined filters available from any perspective. You can use these contexts to temporarily narrow the focus of the analysis and test ideas or check for patterns.

Pie Chart

A pie visualizes a data series as a circular chart with slices sized proportionally to represent the data values.

Plan Version 

Plan versions, also referred to as planning versions, plans, and planning, may be budgets, what-if scenar­ios, or almost anything else you can imagine.

Prediction Version

Prediction version is a plan version that contains machine learning predictions. Once you generate predictions, your sheets highlight anomalies that fall outside the lower and upper bounds of the predictions.

Primary Axis

A primary axis on a chart indicates the magnitude of metric values. For example, the y-axis on a column chart can display values based on account units.

Pyramid Chart

A pyramid visualizes data segmented by a category. This chart is similar to a funnel chart - only inverted.


A reclassification is movement of an amount from one general ledger account to another. Examples of a reclassification include correcting an incorrect entry after month end close or consolidating ledgers of multiple business entities,where certain accounts for one entity must be moved to a different account when considered in the context of its larger owning entity.

Reporting Currency

A currency is marked as a reporting currency when it is important to have exact exchange rates for it, rather than converting through an intermediate currency. In large companies, however, marking a currency as a reporting currency may create hundreds of exchange rate accounts and should be done only sparingly.


rollup sums or averages the values of entries according to a pre-set structure. Rollup cells represent the rollup value of time, accounts, dimensions, or levels. 

Roll up

To contribute the total of a rollup. Values can roll up to levels, accounts, and time periods. Splits also roll up to the original account total. 

Rollup Accounts

A rollup account is a parent account that sums the totals of its child accounts.

Root Accounts

A root account is the top-level account in the hierarchy. It has no parent account and does not roll up to another account. Your planning model comes with several general ledger (GL) root accounts, and any account you add rolls up to one of the root account eventually. 

Root Stratum

The root strata is the largest unit of time in a time structure. In most cases, Fiscal Year is the root containing all other strata.

Scatter Chart

A scatter chart visualizes trends as data points, where the x-axis is time or dimension. 

Scorecard Chart

A scorecard visualizes a series of data in a tabular format that summarizes actuals versus planned data, and variance. This chart often includes a micro chart to highlight key metrics.

Secured Dimensions

Secured dimensions are the dimensions you selected to define access rules. They may include accounts, levels, and up three custom dimensions.

Shared Formulas

Shared formulas are calculations assigned to an account. They persist across selected levels and the entire time span of a version. Unlike other calculated data, shared formulas provide values that aren't locked in sheets. Because the value isn't locked, you can edit the formula in the sheet cell or enter different data.  


Sheets provide an interface to view, enter, and update data (such as actual ledger data, forecasts, personnel information and budgets). There are three types of sheets: standard, modeled, and cube. 

Sheets on Dashboards

Use sheets on dashboards to enter data without navigating away from your dashboard. Save your sheet to dynamically see changes on dependent charts and dashboards.

Sheet Workflow Task

sheet workflow task is a type of task that is assigned to a sheet not a user. Only users who have access to the sheet can see this type of task.


A snapshot is static image of a dashboard, chart, or report.

Source Actuals

When an allocation or elimination rule is applied to the actuals version, source actuals allow you to specify a particular sub-version of actuals to be used as the source for the rule. See also Target Actuals.


A sparkline is a tiny line chart or bar chart on that represents changes in account values over time. You can add sparklines as a display option on standard and cube sheets (and on modeled sheets that include a timespan column). 


A split is a supporting calculation for accounts. A split lets you plan accounts, such as expenses or business metrics, with greater detail. The entered value of splits are rolled up to their parent account. Splits are for your information only and do not appear on other sheets or levels.

Standard Sheet

A standard sheet contains a simple grid of accounts and time periods. Common examples of standard sheets include expense sheets, revenue sheets, profit-and-loss sheets, balance sheets, and cash flow sheets.


Sub-versions are slices of your actuals, created under an existing actuals version in the version tree. The data of each sub-version rolls up to the data displayed in actuals; that is, data is not duplicated. You can have any number of sub-versions under actuals, and sub-versions can also have sub-versions.  Create actuals sub-versions to organize and filter your actuals in different ways.

Target Actuals

When an allocation or elimination rule is applied to the actuals version, target actuals allow you to specify a particular sub-version of actuals to be used as the target for the rule. See also Source Actuals.

Territory Assignments

When creating a territory map, territory assignments are required to indicate the names of sales representatives and the geographies they own. You set territory assignments within a modeled sheet by selecting dimension values for sales representatives in one column and geographies in another. Territory assignments commonly include other information like market segment or industry.

Text Chart

A text in a dashboard can provide guided assistance,  usage notes, or general information or notes about visualizations displayed on the dashboard.

Time Period

A time period is a collection of consecutive days, weeks, months or other time stratum with established start and end dates. They can be leaf or rollup strata where data is stored.

Time Rollup

A time rollup specifies how account totals appear on any worksheet with time periods (for example, quarterly or yearly totals). 

Time Strata

Time strata are the layers of time that roll up to each other from the leaf stratum to the root stratum.

Time Stratum

A time stratum is an individual level of time within the time strata.

Top Level

The top level is the required, highest level in an organizational structure. All sheets appear on the top level, and all levels in the organization roll up to it.

Trading Partners

Trading partners are two parties within a company, typically subsidiaries or departments which do business with each other and post intra-company transactions. Typically, a debit transaction and credit transaction gets booked by the two parties and the seller invoices the buyer.

Unpublished Changes

Unpublished changes are changes made to an instance while Admin Publishing is in effect. These changes are not activated until an administrator publishes them. 

User-assigned Sheet

A user-assigned sheet is a sheet that an administrator assigns to one or more specific users. Unlike level-assigned sheets, assigned users can view these sheets at any level.  

User Group

Created by administrators, a user group is a collection of individual logins for an installation. These groups are useful for assigning and managing version permissions for a large number of users. They are also useful for emailing reports to different sets of users.


A version represents a particular financial scenario.  For example, a version can be current-year actuals, next year's budget, a three-year plan, or a what-if plan for evaluating the effects of a business transaction.

Virtual Version

Virtual versions are plan versions that use data from two different versions to create a read-only composite version.  With virtual versions, you can use the data of one version and apply the exchange rate of another version, which removes the rate fluctuations.  Create virtual versions to enable Constant Currency Reporting.

Waterfall Chart

 A waterfall visualizes data to show where you started, where you ended, and how you got there. The initial and the final values are often represented by whole columns, while the intermediate values are denoted by floating columns.

Weighted-Average Translation (WAT)

Weighted-Average Translation (WAT) is an account setting for cumulative accounts. A master formula pulls the data from a periodic account into the cumulative account. Weighted-Average Translation then converts the currencies on the delta at the average periodic exchange rate. This provides a weighted-average conversion. Additional settings: Balance Reset and Balance Transfer at Reset provide automated data flows.

Weight Formula

A weight formula in an allocation rule describes how the allocated-in amounts are distributed among target levels.


Workflow is the process that levels go through during the planning cycle. It includes these stages: In Progress > Submitted For Review > Approved (or Rejected) > Locked.

Workforce Planning

Workforce planning is an Adaptive Planning instance that uses your Workday HCM data. The model foundation includes dimension and data loaders, top-down and bottom-up modeled sheets, dimensions, and formulas.