Section Object Members for Workbook in SuiteScript
Section object members allow developers to define the structure of data sections in SuiteScript, enhancing workbook functionality and data representations.
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
| Member Name | Type | Return Type / Value Type | Supported Script Types | Description |
|---|---|---|---|---|
| Section.children | Array<workbook.CalculatedMeasure | workbook.DataMeasure | workbook.DataDimension | workbook.DataDimensionItem |
| Section.totalLine | string | Server scripts | Specifies the formatting option for the total line associated with the section. Set this using the workbook.TotalLine enum. |
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 code2...3var mySection = workbook.createSection({4 children: [myDataDimension, myMeasure],5 totalLine: workbook.TotalLine.HIDDEN6});7...8// Add additional codeIn 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,
childrenandtotalLine, control the structure and presentation of sections. - Clear understanding of these members enables better data visualizations in SuiteAnalytics.
Frequently Asked Questions (4)
What is the purpose of the Section object in SuiteScript?
Which members of the Section object are used to define and manage data in a workbook?
Do I need to use server scripts to utilize the Section object members?
Can Section objects in SuiteScript be used for creating pivot tables?
Was this article helpful?
More in SuiteAnalytics
- Class, Department, Location Features in NetSuite 2026.1
Class, Department, and Location features enhance financial processes in NetSuite 2026.1 for improved insights and reporting.
- New HTML Formulas in Search for NetSuite 2025.1
New HTML Formulas in Search introduced in NetSuite 2025.1 enhances security for saved searches. Starting in NetSuite 2025.1, the HTML Formulas in Search feature
- Export Pivot Tables to Excel in NetSuite 2024.2
Export Workbook pivot tables to Excel XLSX format starting with NetSuite 2024.2, enhancing data analysis and reporting capabilities.
- Consolidated Reports and SuiteQL in NetSuite 2026.1
Consolidated reports and SuiteQL enhance data access in NetSuite 2026.1. Discover key integration features.
Advertising
Reach SuiteAnalytics Professionals
Put your product in front of NetSuite experts who work with SuiteAnalytics every day.
Sponsor This Category