SuiteAnalytics is a powerful tool that transforms data into visual information. SuiteAnalytics is a better alternative to Excel and provides real-time ERP data using tables, pivots, and charts that can all be viewed on dashboards. With today’s release of NetSuite version 2021.2, SuiteAnalytics brings more enhancements to make building the right report and scrutinize the data even more powerful.
Combining multiple datasets in a single visualization via SuiteScript
Most SuiteAnalytics users have already created visualizations from the data in their datasets and workbooks. Even though the NetSuite data model allows a lot of flexibility and provides automatic joins between records, you might need to connect two datasets in a single visualization, such as a chart. To combine multiple datasets, a common denominator is required, such as IDs or dates that are contained in both datasets. Common uses for combing datasets are “budget vs. actual,” “planned vs. actual,” and “reported vs. completed” reports.
As a first step to end-user defined dataset linking, SuiteAnalytics v2021.2 comes with the ability to define a link between two datasets programmatically via the SuiteScript API and display the results in SuiteAnalytics.
Our product teams prepared SuiteScript to demonstrate the dataset linking feature for a "budget vs. actual" workbook report as an example.
Let’s see how this looks in practice. In the following example, we created a SuiteScript definition of two Datasets: Employee and Transaction. Then, we created SuiteScript with a Workbook where we connected the Transaction and Employee datasets and created a pivot table visualization utilizing fields from both datasets.
We generally don’t use UI in writing. Is it possible to just say “display the results in SuiteAnalytics.”?
Data export from a workbook pivot table
NetSuite version 2021.2 expands the ability to process, integrate, and examine workbook pivot table data from third-party software by introducing the ability to export comma separated value format (CSV) from SuiteAnalytics Workbook.
CSV export data is standardized and enables using data from real-time Workbooks in non-real-time scenarios. These scenarios could include formatting for PowerPoint presentations, creating highly customized charts in MS Office, sharing data with users with no NetSuite access, machine-learning data processing, or simply archiving snapshots of workbook pivot reports.
The CSV export now covers both datasets and pivot tables, and it’s a one-click action as seen in the following example:
Performance improvements
SuiteAnalytics wants to deliver a slick and fast UI experience when working with data in workbooks or dashboard portlets. However, workbooks sometimes need to process a lot of data and very complex calculations. Naturally, that affects fast response times. To cover scenarios like this, we offer the ability to cache datasets on demand. Dataset caching allows the user to have near real-time data (max. 1h old) and still get a fast response time when opening or manipulating workbook tables and charts.
Dataset caching is an optional feature in SuiteAnalytics. Once enabled, it allows individual users to activate data caching in workbooks or datasets that need a performance boost. The feature doesn’t change or modify data and is nearly undetectable when in use.
If you ever need most up-to-date data in your datasets and workbooks when they are using cached data mode, there is still an option to force a data refresh. The datasets and workbooks will then be using the most recent data available.
Apart from the new features mentioned above, SuiteAnalytics comes with UI improvements, better portlet translation support, SuiteScript API improvements, and bug fixes.
As before, NetSuite version 2021.2 is automatically activated for all accounts during multiple update waves.