Exporting Dataset Definitions to SuiteQL

You can export saved dataset definitions to a SuiteQL TXT file. This helps you understand how fields are joined so you can build SuiteQL queries. SuiteQL queries are available through the SuiteScript Analytic API, SuiteAnalytics Connect, and SuiteTalk REST Web Services.

To export a dataset definition to a SuiteQL TXT file, open your dataset, click Export and choose Export dataset to SuiteQL TXT. For more information, see Defining a Dataset.

Note:

For SuiteAnalytics Connect, this option applies to the NetSuite2.com data source only. The export option is only available for users that have the AnalyticsAdmin permission assigned to their roles. For more information about Permissions, see Setting Permissions.

When you export your dataset definitions, you must consider the following:

You can only export dataset definitions that are saved. Unsaved datasets won’t show the export option..
Exported datasets may include internal records or fields not available everywhere. Check the Records Catalog to see which ones are exposed. For information about the Records Catalog, see Records Catalog Overview.
Some dataset exports might be incomplete, so you may have to fill in criteria values manually. For example, in this query you’ll need to replace "?" with a corresponding value:
```
              AND TransactionAccountingLine.posting = ? 

            
```
With SuiteAnalytics Connect, right outer joins aren’t supported. For example, the following Oracle SQL doesn't work in SuiteQL:
```
              select a1.id from account a1, account a2 where a1.id (+) = a2.id 

            
```
For information about syntax requirements for SuiteAnalytics Connect, see SuiteQL Performance and Best Practices for Connect.

Related Topics