Skip to main content
Feedback

NetSuite Analytics walkthrough

NetSuite Analytics offers real-time saved searches, reporting, key performance indicators (KPIs), dashboards, and workbook features seamlessly integrated into the NetSuite platform. These tools help users to gain actionable insights and make data-driven decisions efficiently.

Connection

To connect to NetSuite Analytics, refer to the NetSuite Analytics topic.

Configuring a NetSuite Analytics River

NetSuite Analytics supports two modes for Rivers:

  • Multi-Table mode: Load multiple tables (entities) simultaneously into your target.
  • Single Table mode: Load a single table or custom query into your target.

Multi-Table mode

The Multi-Table Mode enables simultaneous loading of multiple tables from NetSuite into the target.

Auto-Detect new fields

By default, Data Integration updates the metadata of the extracted tables before each River execution. This ensures that newly added fields are automatically included.

  • Disable Auto-Detect: To use saved metadata instead of automatic updates, turn off this feature. Manually reload metadata by clicking the Reload Metadata in the Mapping tab, then save the River.
note

Existing target column mappings, including names and data types, are preserved when new fields are added.

Mapping

In the Mapping window, select the tables to load. To update settings for a specific table, click the Edit.

Table settings

The Table Settings tab lets you:

  • Change the Extraction Method.
  • Adjust the Loading Mode.
  • Apply filters using AND / OR operators to fetch specific data.

Filters

Filters enable precise data retrieval based on specific conditions.

Ensure adherence to NetSuite’s filter syntax.

  • String and date values must be enclosed in single quotes (').
  • Numeric values must not be quoted.

For example:

(country ='United States' OR currency_id=482) AND date_last_modified='2021-07-04 08:00:00'

Single table mode

The Single Table Mode lets you load a single Table or Custom Query into a target.

Entity selection

Click on the "Entity" to view all available tables for the connection and select the desired table.

Extraction methods

Two extraction methods:

  • All: Extracts all data in the table, suitable for smaller tables.

  • Incremental: Recommended for larger tables and frequent runs.

Incremental settings

For Incremental extraction, configure:

  • Timestamp: Define a start date, end date, and timestamp field.

    • The River retrieves data up to (but does not include) the end date unless the Include End Value is enabled.

    • Interval Chunks Size (Optional): Divides data into manageable intervals. For example, a daily chunk size of 3 splits the data range into three-day intervals.

  • Running Number: Use for fields of type INT. Define a start and end value.

Filters

Insert filters to slice data based on field conditions. Combine multiple filters using AND, OR, or BETWEEN operators.

For example:

(country = 'United States' OR currency_id = 482) AND date_last_modified = '2021-07-04 08:00:00'

Mapping attributes

You can map source fields to target fields.

Procedure

  1. Click Auto Mapping.
  2. Remove multiple fields by selecting them and clicking the trash icon.
  3. Remove a single field by clicking the X button next to it.

Custom query

Custom queries must adhere to NetSuite’s syntax.

For example:

SELECT * FROM (SELECT f.currency, f.custrecord_glm_include, f.lastmodifieddate, f.legalname, f.location, f.parent, f.reconcilewithmatching, f.restricttoaccountingbook, f.revalue, f.sspecacct, f.subsidiary FROM account AS f WHERE f.lastmodifieddate >= {ts'2021-12-27 19:46:02'} AND f.lastmodifieddate < {ts'2022-03-15 19:49:27'}) WHERE custrecord_glm_include = 'F'

Deleted record report

The Deleted Record report in NetSuite Analytics provides insights into deleted records, including:

  • Deletion Date: When the record was deleted.

  • User: The user responsible for deletion.

  • Context: The environment in which the deletion occurred.

  • Record Type: The type of record deleted.

  • Record Name: The specific name of the deleted record.

The report is available in:

  • Single Table mode: Simplified data view.

  • Multi-Table mode: Detailed data breakdown.

On this Page