Analytics Data Source Overview
The analytics data source is a collection of NetSuite data that is grouped according to record types and fields. The structure of the analytics data source enhances the capabilities of analyzing your NetSuite data which you can query using SuiteQL. This advanced query language lets you run complex SQL queries.
The analytics data source has been used in SuiteAnalytics Workbook since 2019.1. You can also retrieve data from the analytics data source using SuiteAnalytics Connect, SuiteScript, and SuiteTalk REST web services.
To help you understand the analytics data source, see the following topics:
-
You can use the Records Catalog to see the fields and joins available for each record type. The Records Catalog displays also information such as the cardinality, field level help, and so on. Due to Records Catalog's reliance on the NetSuite role-based permissions, you can see only the record types for the data that you can access in the NetSuite user interface. The Records Catalog is supported for the SuiteScript Analytic API and the REST Query API only. Therefore, the record types available in the Records Catalog and the dataset user interface may differ slightly. For more information, see SuiteScript 2.x Analytic APIs.
Note:The Records Catalog is available for all users that have the Records Catalog permission assigned to their role. For more information, see Records Catalog Overview.
-
You can use SuiteQL to run queries against the analytics data source through SuiteAnalytics Connect, SuiteScript, and SuiteTalk REST web services. For more information, see SuiteQL.
-
In Workbook, you can further customize the record types and fields available in the analytics data source for use in your workbooks. For more information, see The Analytics Data Source and SuiteAnalytics Workbook.
-
Some record types have been created specifically for Workbook and exist only in the analytics data source. For more information, see Analytical Record Types.
-
To locate fields in the analytics data source using the Workbook user interface, you can browse and search the Records and Fields list on the Dataset tab. For more information, see Locating Fields in Workbook.