SuiteAnalytics Sneak Peek: NetSuite 2021 Release 2 Expands Workbook Capabilities

Himanshu Pande, Senior Principal Product Manager, SuiteAnalytics, Oracle NetSuite

July 21, 2021

SuiteAnalytics is a powerful tool for visualizing and gaining insights into your business data. By providing real-time ERP data to tables, pivots and charts within easy-to-understand dashboards, it’s a superior tool to alternatives like Excel. In NetSuite 2021 Release 2, SuiteAnalytics delivers new enhancements, making it easier to create reports and make data discovery and visualization even more powerful.

  • Connecting multiple datasets into a single table or Workbook pivot table

    Most SuiteAnalytics users are familiar with datasets and Workbook data visualization. Datasets uses the NetSuite data model to create automatic joins between records.

    However, users need to explicitly join two datasets to display data in a single Workbook table or Workbook pivot. A common denominator is required to combine multiple datasets. For instance, an ID or a date in both datasets (records and their fields). Typical use cases include “budget vs. actual,” “planned vs. actual” or “reported vs. completed” types of reports.

In this release, two datasets can also be programmatically joined by using an enhanced SuiteScript API and displaying the results in a Workbook Table or Workbook Pivot Table. As an example, here is a SuiteScript template to demonstrate the dataset linking two datasets (Employee Record and Transaction) shown in a Workbook.

  • Data export from Workbook

    NetSuite 2021 Release 2 also expands the ability to process, integrate and examine Workbook data in third-party applications by introducing a comma separated values (CSV) format export from the Workbook UI.

    With CSV data export, the data from real-time Workbooks can be used in non-real time scenarios, such as formatting for a PowerPoint presentation, creating highly customized charts in Microsoft Office, sharing data with users with no NetSuite access, machine learning data processing or simply archiving a snapshot of the Workbook pivot report.

    The CSV export is now available for datasets and pivot table and is a one-click action.


  • Performance improvements

    Sometimes, Workbooks need to process very large datasets or perform complex calculations, which may result in a slower rendering. To cover scenarios like this, NetSuite has added the ability to cache datasets on demand. This enables fast response times for near real-time data (maximum of one hour old) when opening or manipulating Workbook tables or charts.

    The dataset cache is an optional feature. When cached mode is active and you need to load the latest available data, NetSuite provides an option to enforce a data refresh at any time.

In addition to these new features, NetSuite has added a few minor SuiteAnalytics UI improvements, and provided better translation support for portlets, SuiteScript API improvements and bug fixes.

The version of SuiteAnalytics will be automatically activated on all accounts upon upgrade.

Ready for the release? Find out more.

Any customer who's gone through previous NetSuite refreshes knows that no blog post can do justice to all of the new functions and capabilities in NetSuite 2021 Release 2.

For a more complete picture of what the new features are in the release, read the release notes(opens in new tab)

Most importantly, don't forget to request access to your Release Preview(opens in new tab) test account. Nothing substitutes for hands-on access to see how all the new features will work with your data, workflows and customizations.

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation.

NetSuite has packaged the experience gained from tens of thousands of worldwide deployments over two decades into a set of leading practices that pave a clear path to success and are proven to deliver rapid business value. With NetSuite, you go live in a predictable timeframe — smart, stepped implementations begin with sales and span the entire customer lifecycle, so there's continuity from sales to services to support.