Using SuiteAnalytics Datasets with Profitability and Cost Management Sync
Besides the saved searches in NetSuite, Profitability and Cost Management Sync lets you use SuiteAnalytics datasets to load data and metadata from NetSuite into your Profitability and Cost Management. To use SuiteAnalytics datasets with Profitability and Cost Management Sync, you need to prefix each dataset with _nspc_. Every dataset the ID of which includes this prefix is then listed in Data Exchange. You can configure and call it from Data Exchange in the same way as you configure and call saved searches.
The filters you set on your datasets in NetSuite aren't available in Data Exchange.
Make sure that field relationships in dataset criteria don't include lengthy filter names exceeding 65 characters in a single line. Exceeding this character limit may cause issues when loading the datasets into Data Exchange during the initial setup. To prevent the data load issues, consider breaking down complex criteria into multiple smaller filters within your datasets.
Profitability and Cost Management Sync includes predefined datasets that you can use to load metadata from NetSuite into your Profitability and Cost Management. For information, see the following help topics:
For general information about using SuiteAnalytics datasets, see Custom Workbooks and Datasets.
Related Topics
- Profitability and Cost Management Sync Installation and Setup
- Role Permissions for Profitability and Cost Management Sync Users
- Profitability and Cost Management Sync Configuration Checklist
- Saved Searches for Profitability and Cost Management Sync
- Saved Search Settings in Profitability and Cost Management Sync
- Metadata Export to Profitability and Cost Management
- Account Metadata Hierarchy in Profitability and Cost Management Sync
- Managing SuiteQL Queries in Profitability and Cost Management Sync
- Portlets for Profitability and Cost Management Sync