We have enhanced the fetch process with Cube. You can now re-fetch to single and multiple ranges, including ranges on other sheets, if the original fetch had an error.
From the Mini-Audit Trail....
We have enhanced the fetch process with Cube. You can now fetch to single and multiple ranges, including ranges on other sheets.
As you select multiple ranges, your range count will update. Sele...
Refresh your sidebar: which may include clearing your cache, to experience Cube updates
We've been hard at work creating intuitive new designs and user experiences that make it easier than ever to ...
This article will show you how to build a range within Excel or Google Sheets in order to fetch your data.
Building Your Range
Open the Cube add-on within Excel or Google Sheets
Click the 'New' ...
We have enhanced the fetch process with Cube. You can now re-fetch to a failed range through the mini audit trail.
Note: See Fetch to multiple ranges article for help on single/multiple range fetc...
In this article, we're sharing some best practices on how you can use Cube's web reports to enable your month-end close, and collaboration with your accounting team and business stakeholders.
Using Cube's spreadsheet add-ons, you can drilldown into your source data transactions. This enables better and faster analysis, and saves you the step of navigating back to your ERP, CRM, or HRIS-...
Definition of Collection Templates & Reports in Cube
A prebuilt, predefined layout
Used for data input (read & write)
A prebuilt, pr...
Create and maintain different ranges using Cube - all within the same sheet!
Adding a New Range
You can add a new range to your sheet by clicking on the "+" sign in the right corner of the Add-on....
We've simplified the work it takes to calculate to-date values for your variance analysis. Just add "TD" or "YTD" to your Time headers to return the to-date value.
Set up your Headers and Fetc...
Want to use saved templates to automatically update your monthly financial reporting package?
Simply create your standardized financial statements and reports as templates, fetch them into you...
This article will show you how to create budget input templates in Cube and share them with other members of your team.
Creating the Template
1. I've already made a Q1 T&E Budget - Sales templ...
This article illustrates how to register a pre-formatted range.
Registering the Range
1. Open the Cube sidebar and click Select
2. Highlight your table on the sheet, including column and row h...
This article will help you determine which build type to use.
fka "Manual Mode"
If you have a pre-formatted range that you're looking to register, you'll want to use Select. After selec...
This article illustrates what a multi-dimensional range is and provides a few examples of ones you can build in Cube.
What is a multi-dimensional range?
In Cube, a multi-dimensional range is one ...
With so many features available in Cube, many of our users often ask;
"How are other people using this?"
In this article, we'll show you how a company uses Multiple Ranges to break down Revenue by ...
You can use Validate to check your registered range for dimensions that the sidebar doesn't recognize (think "Rent" vs. "Rent Expense").
When would I use this?
I'd like to run a quick scenario anal...
This article will show you how to create an ARR waterfall in Cube using the Running Total formula. You can apply this method to a number of different ops metrics, such as User Count or # of Booking...
Throughout the year, you'll likely want to compare Actuals data to other Scenarios such as Budget or Forecast. While Budget and Forecast data for any given month is typically imported into Cube bef...