Highlights
Faster Fetches allow you to work with your data more quickly
Fetches now complete more quickly with our improved method of populating the data on the spreadsheet. We have optimized the behind-the-scenes writing process allowing you to get your data into the spreadsheet more quickly so you can stop waiting and get to work.
Curious how fast Fetches are now? Our lab tests showed average performance improvements between 25% and 70%. We're excited by these numbers and have more product enhancements planned to help you more efficiently work with your data.
Note: The time it takes to Fetch a range varies based on many factors, such as the size of the Range, the complexity of the Dimensions, and the spreadsheet platform.
Status messages improved for Flatfile and NetSuite uploads
The NetSuite and Flatfile upload interfaces show when an upload is pending, making it easy to know that you’ve successfully initiated an upload. In the NetSuite interface, the new Pending Transaction uploads section shows all pending NetSuite uploads.
Pending Transaction Upload section
Pending Flatfile imports now show a status of Pending until they are in progress.
Another connector for your repertoire
Up-level the data you’ve already consolidated into Power BI by importing it into Cube for further planning and analysis. Reach out to your Customer Success Manager if you’re interested in setting this up.
What else is new?
Here's what else has changed recently.
Portal
Audit Trail makes it easy to see when a value was increased or decreased
The Audit Trail visually shows whether a value was increased or decreased with a green up arrow or red down arrow, so you can more quickly identify what change occurred.
Audit trail with events that increase and decrease the original value
Spreadsheet Add-on
Display Time Dimensions the way it works best for you
The format Time Dimension dates are displayed can affect how easy it is to read your data. You can now customize the dates in your spreadsheet to display the way you want by choosing from 68 different display formats. Check out our Date formats supported by the Cube Add-on guide to pick your favorite and start using it today.
Examples of three new display formats
Augment your data by including relevant date metadata
The Cube Add-on now fully supports a range with non-Dimension dates to allow you to easily include relevant metadata next to your Cube data. By default, Cube assumes any dates on your spreadsheet are Time Dimensions. Tell Cube to ignore dates by setting the cell format to Text. It’s that easy!
Not sure how to format a cell? Learn more about cell formatting for Google Sheets and Excel.
Note: The cell value cannot match the name of a Time Dimension.
Example of formatting dates as text
Google Sheets Add-on now shows you when it’s ready
The Google Sheets Add-on has been updated to make it easy to know when it is ready. It now shows a loading page after you authenticate while it’s getting ready. You can start Fetching and Publishing as soon as the loading screen disappears.
Google Sheets Add-on loading