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

Glossary

A glossary of terms commonly used at Adaptive Insights.

Account

An account is a container that groups actuals or planning information, such as 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 might include hotel expenses, car rental, and so on. 

Actuals Version

Actuals versions contain your actual financial results for a given period of time, like your income or expenses from May 2014. Actuals are records of things 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.

Assumption

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. 

Attribute

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.

Breadcrumb

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

Breakback

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.

 CTA

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. 

Dashboard

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

Dimension

A dimension is an accounting characteristic with a list of possible values. Dimensions are used in all types of sheets. For example, 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 chart visualizes a data series as a circular chart. This chart is similar to a pie chart without the center.

Elimination

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.

General Ledger Account 

A general ledger account (GL) is meant to mirror the accounts in your real-world general ledger. The setting options follow standard accounting principles in general. Many of the general ledger accounts are built into the account tree.  

Instance

An instance is the collection of structural components that define a fully-functional entity within Adaptive Insights. 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, so you can switch between them. 

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.

Integration

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.

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.

Level

Levels are 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 for accounts.

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. 

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

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.

Perspective

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

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.

Reclassification

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

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. Adaptive Insights 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.

Sheets

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. 

Sheet Chart

A sheet chart is a container for displaying sheets within a Discovery dashboard. Sheet charts let you make changes to the sheet data your charts rely on without the need to navigate out of Discovery. Saved changes immediately update related charts and sheets in a dashboard.

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.

Snapshot

A snapshot is static image of a dashboard, chart, or report and cannot be updated. Use snapshots to record information for a specific moment in time.

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.

Sparkline

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

Split

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-version

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.

Territory Map

A territory map is a geographic chart that defines the boundaries of sales territory ownership. You can view sales-related data for a territory by clicking it. Territory maps require a cube sheet containing sales representatives, their geographic assignments, and other multi-dimensial data related to their sales performance or sales opportunities.

Territory Planning

Territory planning is the process of deploying sales representatives to geographies, market segments, or industries as part of achieving sales goals.

Text Chart

A text chart is a container for displaying text in dashboard. They can be useful for providing explanatory information or notes about the other charts or sheets in a dashboard. The text can be entered unformatted, as HTML, or as markdown syntax.

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.

Version

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

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.

Workflow

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

  • Was this article helpful?