Tutorial: Creating a Dataset Using the Workbook API

Note:

The content in this help topic applies to SuiteScript 2.x.

In this tutorial, you'll learn how to:

Load the N/dataset module
Create an initial dataset
Create dataset components (joins, columns, and conditions)
Add dataset components to the initial dataset
Save and run the dataset

You can write your script in a text editor of your choice. When the script is complete, you will use the SuiteScript Debugger to run the script and create the dataset. Finally, you will use the SuiteAnalytics Workbook UI to verify that the dataset was created successfully.

Navigating the Tutorial

This tutorial includes navigation links at the bottom of each page. You can use these links to go forward to the next step in the tutorial or go back to the previous step.

Use the following table to go to a specific step in the tutorial.

Step	Description
Prerequisites	This topic lists the prerequisites for this tutorial, including required NetSuite features and permissions.
Create an initial dataset	This step describes how to create an initial dataset with no components.
Create joins with other record types	This step describes how to create joins with other record types so you can include more fields in the dataset.
Create columns	This step describes how to create columns, which represent the fields to include in the dataset.
Create conditions	This step describes how to create conditions to filter the dataset.
Add components to the initial dataset	This step describes how to add the joins, conditions, and columns to the dataset.
Save and run the dataset	This step describes how to save the dataset and run it to obtain the results.

Step

Description

Prerequisites

This topic lists the prerequisites for this tutorial, including required NetSuite features and permissions.

Create an initial dataset

This step describes how to create an initial dataset with no components.

Create joins with other record types

This step describes how to create joins with other record types so you can include more fields in the dataset.

Create columns

This step describes how to create columns, which represent the fields to include in the dataset.

Create conditions

This step describes how to create conditions to filter the dataset.