Use this glossary to learn more about Cube’s data structure, key concepts, and terminology.
Account is one of the default top-level dimensions that organizes data from your source systems. The Account top-level dimension typically includes your General Ledger transactions, formulas, and operational information.
Cube stores data from your source system as actuals under the Scenario top-level dimension, along with budget and forecasting scenarios. This data from your source system is automatically write-protected with the actuals setting to keep your Cube data accurate.
Learn more about your data using the analyze section of the Spreadsheet add-on to drill down on a value or validate your table.
An API is a set of protocols that allow software systems to integrate and communicate with one another. Cube uses a secure API that connects to your source systems and mirrors your source data within Cube so you can use data from multiple sources in your financial planning.
Attributes are additional metadata associated with each transaction or row in your spreadsheet. Set attributes automatically using a detailed source system integration or on demand when publishing data to Cube using the Spreadsheet add-on. View attributes by drilling into a value to see detailed transactions or rows.
See a summary of changes with the mini audit trail in the Spreadsheet add-on. Use the audit trail in the Web portal to view all changes to your data, including the event type, when it occurred, who made the change, and additional in-depth details. Use
Block is a write protection setting available to Scenarios top-level dimensions. When a scenario is blocked, team members can't publish changes to your Cube data.
Plan for expected expenses and use those in your financial planning by organizing your budgets under the Scenario dimension.
The Spreadsheet add-on pulls data from Cube into your spreadsheet using the dimensions in a range's rows and columns. Choose a pre-built range, create one from scratch, or open a template in the Spreadsheet add-on’s build section.
Chart of Accounts (COA)
Define your Chart of Accounts structure under the Account, Department, and other dimensions in the Web portal. Organize and map the hierarchy so child accounts roll up to the appropriate parent account and appear in the correct order.
A Cube Value refers to the data stored in your Cube after all mappings, translations, and calculations occur. This value is what you fetch or publish when using the Spreadsheet add-on. A Cube Value can be a single value or a rollup of multiple values.
You likely already have a package or a template you use for financial reporting. You can Cubify or update this package or template to match Cube dimension names for easy fetching and publishing with the Spreadsheet add-on.
Custom connectors or integrations
Cube has developed tailored solutions to accommodate source systems without out-of-the-box integrations. Cube uses a third-party integration platform, Boomi, to make this possible through three types of connections.
- On-premise integrations: If your company manages private servers, Cube integrates by installing a data agent. This agent retrieves data using access credentials and data queries provided by your team.
- Cloud integrations: In cases where no standard connector is available or a data warehouse to pull data from, Cube collaborates with you to create a suitable solution for sending data.
- Programmed flat file: If one of the above is not feasible, Cube can connect to a designated location (such as FTP) to ingest files regularly.
Build and save dashboards of charts and KPIs in the Web portal to display your Cube data visually.
Download your Cube data as a CSV or Excel file from the Web portal using the data exporter.
A data table is the main container to mirror data from your source system. All integrations with source systems and all flat file uploads use a data table to organize the incoming data.
Define your organization's structure in your Department top-level dimension and enable slicing and dicing your data at the department level.
Cube organizes your data into a flexible hierarchy of dimensions or categories:
- Top-level dimensions are the main organizational structure of your data. Your Cube can contain up to eight top-level dimensions, set up by our team when we build your Cube. These dimensions appear as tabs across the top of the dimensions section in the Web portal.
- Parent dimensions are the next level down in the dimensions hierarchy. Parent dimensions have one or more child dimensions and hold data that rolls up from these children.
- Child dimensions are the lowest level in the dimensions hierarchy and store data as values. Child dimension values are line items or transactions mirrored and mapped from your source system, calculated from a formula, or published from the Spreadsheet add-on.
View the transactions and their attributes that make up a value by drilling down on a cell using the Spreadsheet add-on.
Fetch or pull a set of data from Cube to your spreadsheet using the Spreadsheet add-on to define the dimensions as rows, columns, and filters.
A flat file is a CSV or TXT file that contains records, transactions, or other data in a format Cube will recognize. Flat files can be routinely uploaded into Cube via the data tables area in the Web portal when a direct integration isn't available.
Automate calculations in Cube by saving commonly used formulas as a part of your data hierarchy. Formulas will appear as a child dimension and have a calculator icon in the "Type" column. These formulas will recalculate whenever changes are made to your data, and the values can be fetched to your spreadsheet using the Spreadsheet add-on.
General Ledger (GL)
Cube mirrors your General Ledger's accounting and transactional data, including defined attributes. We typically do this using your Chart of Accounts.
Cube data is flexibly structured to align with your reporting and analytics needs. We do this by organizing your data into an OLAP cube using a hierarchy of dimensions or a structure of data categories.
Your data hierarchy consists of categories and sub-categories referred to as top-level dimensions, parent dimensions, and child dimensions.
Oftentimes, this structure matches your source system, but ultimately, you can define this.
Periodically resync your connection with your third-party source system and pull in any new data using the import action in the Web portal.
Manage your source data and dimension hierarchy in the inputs section of the Web portal.
Use your Cube Library in the portal to share reports, files, links, and prebuilt spreadsheets with team members. These files can be static or ready to refresh by fetching data with the Spreadsheet add-on.
Mapping matches the source system data structure to Cube's structure through a one-to-one or a many-to-one relationship. During imports, Cube uses this mapping to determine where the values should be stored and does not save any data for unmapped relationships. Keeping your Cube data healthy relies on routinely performing mapping maintenance.
Cube supports applying exchange rates to transactions received in foreign currencies for integrations with QuickBooks Online, Xero, and Netsuite.
Our company name, Cube, refers to the multi-dimensional data storage system called an Online Analytical Processing (OLAP) cube. Data in an OLAP cube is organized into dimensions or categories, and values are stored in the cross-sections of dimensions.
View the audit trail, share files, and export data in the outputs section of the Web portal.
The publish action in the Spreadsheet add-on pushes data from your spreadsheet to Cube. This action changes or adds new Cube values stored in the cloud.
Use the permission settings in the team section of the Web portal to control what data your team members have access to and which actions they can take.
A team member account's permission group (Admin, Finance, or Business) provides or restricts that user's available actions in the Web portal or the Spreadsheet add-on.
Use ranges in the Spreadsheet add-on to fetch or publish data from your spreadsheet. Define the dimensions that make up the rows, columns, and filters to build your range.
Cubify an existing report or create a new one using your Cube dimensions for faster reporting. Save these reports as templates in the Spreadsheet add-on, and they will appear in the creator's reports section of the Web portal.
Streamline work with your team and ensure consistency in reporting by sharing reports with other Cube users.
The selection made in the rollup logic section of the formula builder determines the order of operations for your calculation.
Rollup values differ from Cube values because they are summary values determined by summarizing child dimensions or performing calculations. We do not store these values in our database. They are calculated upon request, just in time.
Create, analyze, duplicate, and merge versions of your financial data using actuals, budgets, and forecasts in the Scenario top-level dimension.
Cube mirrors data from ERP, CRM, HRIS, Spreadsheets, or other sources connected or published to Cube. This source data is not changed when publishing using the Spreadsheet add-on.
Depending on data mappings, a Cube value may contain multiple consolidated transactions. Use the Drilldown action in the Spreadsheet add-on to split the value and view these transactions and their associated attributes.
Use the Spreadsheet add-on to work with your Cube data in Google Sheets or Excel. Learn how to download the Spreadsheet add-on.
Standard connector or integration
Cube has developed integrations that facilitate direct connections to source systems. To utilize this option, Cube users must have administrative permissions for the source system(s).
Add tags to your dimensions in the Web portal to create alternate rollups or hierarchies. See examples and learn more.
Team members are the Cube users from your company. Add or remove users and manage their permissions in the team section of the Web portal.
Build templates in the Spreadsheet add-on using your Cube dimensions or Cubifying the rows and columns of existing reports. Save templates to the Spreadsheet add-on and the portal to generate reports quickly.
The Time top-level dimension appears in every Cube hierarchy, allowing you to slice and dice by the financial period most relevant to your company.
The time rollup is a dimension setting for all parent dimensions in the Account top-level dimension. This setting determines how the child dimension values are summarized at quarter- and year-end.
Transactions are the individual line items representing an event, journal entry, or data point within a source system. Transactions have values and may have other associated metadata or attributes.
Use the validate action in the Spreadsheet add-on to check your table's rows and columns before pushing or pulling data from Cube. Cube looks for an exact match to dimension names, so validating will help you catch human errors or typos.
Use validation when Cubifying an existing report to quickly find the rows and columns that need to be updated to match your Cube dimensions.
Cube’s web-based tool allows team members to:
- visualize data using dashboards,
- maintain dimensions, mapping, source data, and currencies,
- audit changes,
- use or share files and templates,
- and manage team permissions and settings.
Learn more about using the Web portal.
Use write protection settings on actuals, budget, and forecast scenarios to block changes or only allow updates by your source system.