Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights



An account is a container that groups actuals or planning information, such as expenses, assets, liabilities, sales, and any business metrics that an organization is interested in tracking.

Account Rollup

An account rollup is the total for an account that has sub-accounts. For example, a Travel account rollup might include hotel expenses, car rental, and so on. 

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.


An attribute is a logical grouping with a list of possible values that you can use to tag accounts, dimensions, and levels. You can create attributes to represent different rollup hierarchies for your organization (for example, geography vs. function).

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, and so on. 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 Adaptive Planning interface. 


Breakback is a configurable set of rules used to spread a value entered in a time rollup back into the time units that comprise 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 chart visualizes data in tabular format. This chart is often used to compare relationships between data sets.

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.


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. Dimensions are used in all types of sheets to tag levels in the organization structure. For example, a product dimension can represent the product lines and products sold by your corporation and a job dimension can represent the job titles assigned to employees. 

Doughnut Chart

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


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. 

Funnel Chart

A funnel chart 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 chart 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.


An instance is the collection of structural components that define a fully-functional entity within Adaptive Planning. Sometimes called an installation, an instance consists of a single set of accounts, organization structure, versions, dimensions, attributes, sheets, versions, permissions, fiscal years, integrations, and so on. Adaptive Planning allows multiple instances of its hosted system, so users can switch between them. See Multi-Instance.

Instance Tree

The multi-instance feature that lets you link instances together in a hierarchy or tree. Instance trees can contain any number of instances with any level of hierarchy.


Adaptive integration is an application that acts as a secure bridge to import data from different data sources like spreadsheets, databases, on-premises sources, and cloud sources into Adaptive Insights products.

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 in a plan represent the organizational structures of your business (for example, departments, profit centers, cost centers, or geographical regions).

Level Rollups

Level rollups are totals calculated from values entered in sublevels and rolled up the organizational structure. For GL Accounts, a level rollup is always a sum. For Custom and Cube Accounts, you can set level rollups as sums, non-blank averages, weighted averages, or a text field where no rollup applies.

Level Workflow Task

A level workflow task is a type of task that is assigned to a level (instead of 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. 

Modeled Sheet

A Modeled sheet is a customized record-based sheet with field names across 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 Adaptive 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 Adaptive Planning 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.


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

Pie Chart

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

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 chart 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.


A rollup is a total or a rolled up value for levels, accounts, time periods, or splits.

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.

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.


Sheets provide the Adaptive Planning interface for financial managers and planners to view, enter, and update financial data (such as actual ledger data, forecasts, personnel information and budgets). There are three types of sheets: Standard, Cube, and Modeled. 

Sheet Workflow Task

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


A snapshot is static image of a changeable item, such as a dial or dashboard. A snapshot shows the item at a particular moment in time, and does not update.

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 is a simple type of sheet that contains a grid composed 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.


A sub-version is a new planning scenario created under an existing Actuals version in the version tree. You can create a full hierarchy of sub-versions under Actuals. 

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.

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 is a collection of accounts, levels, and other data that represents a particular financial scenario.  For example, a version can include current-year actuals, a budget for next year, a three-year plan, and a what-if plan for evaluating the effects of a business transaction.

Waterfall Chart

 A waterfall chart 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.

Weight Formula

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


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

  • Was this article helpful?