PivotIntersection Object Members...

The PivotIntersection object is essential for handling data intersections within pivot tables in NetSuite's SuiteScript. Understanding its members allows developers to work effectively with data dimensions and measure values in reports and analytics.

What Is the PivotIntersection Object?

The PivotIntersection object represents the intersection of rows and columns in a pivot table. It is particularly useful in data analysis scenarios where multiple dimensions are evaluated simultaneously. When calling the Workbook.runPivot(options) method, an array of PivotIntersection objects is returned, enabling developers to access specific data efficiently.

Key Members of the PivotIntersection Object

The following table outlines the primary members available within the PivotIntersection object:

Member Name	Return Type / Value Type	Supported Script Types	Description
PivotIntersection.column	`workbook.DataDimensionValue` or `workbook.SectionValue`	Server scripts	The value for the column dimension.
PivotIntersection.measureValues	`workbook.MeasureValue[]`	Server scripts	An array of measure values at the intersection.
PivotIntersection.row	`workbook.DataDimensionValue` or `workbook.SectionValue`	Server scripts	The value for the row dimension.

Properties and Behavior

Column and Row Properties: Both the column and row properties yield a workbook.DataDimensionValue or workbook.SectionValue, providing insights into specific data points within the pivot's structure.
Measure Values: The measureValues property returns an array of MeasureValue objects, representing numerical data calculated at the intersection point, crucial for detailed analytics.

Error Handling

When working with the PivotIntersection object, it's important to note that attempting to modify a property after the object has been created will result in a READ_ONLY_PROPERTY error. This ensures data integrity during processing and analysis.

Conclusion

Utilizing the PivotIntersection object effectively can yield deeper insights into business data, making it a pivotal component for developers working in SuiteScript on analytics and reporting tasks.

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

Key Takeaways

The PivotIntersection object aids in data analysis by representing row-column intersections in pivot tables.
Key members include column, row, and measureValues, each serving distinct data functions.
Understanding read-only properties is essential to avoid common errors in scripting.

Frequently Asked Questions (4)

Can the properties of a PivotIntersection object be modified after initialization?

No, properties of a PivotIntersection object are read-only after initialization. Attempting to modify them will result in a READ_ONLY_PROPERTY error, which ensures data integrity during processing and analysis.

What are the main properties of the PivotIntersection object useful for analytics?

The main properties of the PivotIntersection object are 'column', 'row', and 'measureValues'. These properties provide data dimension values for columns and rows, and an array of measure values at the intersection, which are crucial for detailed data analysis.

Which script types support the PivotIntersection object?

The PivotIntersection object is supported in server scripts, allowing developers to handle data intersections within pivot tables effectively for reporting and analytics in SuiteScript.

What does the measureValues property of the PivotIntersection object return?

The measureValues property returns an array of MeasureValue objects. These represent the numerical data calculated at the intersection point, which is essential for detailed analytics.

PivotIntersection Object Members Reference for SuiteScript