Section Object Members for Workbook in SuiteScript

The Section object in SuiteScript provides essential functionalities for managing and structuring data within a workbook. By utilizing the workbook.Section members, developers can effectively create dynamic data representations, making it easier to manipulate and visualize data in SuiteAnalytics.

What Are the Section Object Members?

The Section object comes equipped with a set of members that enable the definition and management of data dimensions, total lines, and other critical aspects. These members are categorized as follows:

Available Members

Usage Example

Here’s a code snippet demonstrating how to create a Section object with specific children and a total line configuration:

1// Add additional code
2...
3var mySection = workbook.createSection({
4    children: [myDataDimension, myMeasure],
5    totalLine: workbook.TotalLine.HIDDEN
6});
7...
8// Add additional code

In this example, mySection is being defined with its children set to an array of data measures and dimensions, while totalLine is configured to be hidden.

Related Concepts

A Section object is essential when creating various data visualizations, such as pivot tables or data dimensions within a workbook. It plays a pivotal role in how data is presented and interacted with.

Who This Affects

• Developers: Integrate and utilize section objects within SuiteScript workflows.
• Analytics Professionals: Create and configure data visualizations effectively.

Key Takeaways

• The Section object enhances the ability to manage data within workbooks.
• Two primary members, children and totalLine, control the structure and presentation of sections.
• Clear understanding of these members enables better data visualizations in SuiteAnalytics.

Source: This article is based on Oracle's official NetSuite documentation.