Ways to speed up reports in NSAW from a flattened dataset?

AI generated answer (using internal Slack threads):

Based on the conversations, speeding up reports in NetSuite Analytics Warehouse (NSAW) from a flattened dataset can be achieved by optimizing the data import process. Here are some ways to do that: 1. Use Custom Records for Data Migration: Instead of bringing detailed transaction history into actual transaction records, consider bringing it into custom records. This approach can save time as it requires fewer steps and has fewer failure points. You can create a custom record with text or number fields and import them. Optionally, you can create a link to the new NetSuite customer records using External IDs and import the data. 2. Optimize Data Syncing: NSAW syncs data from NetSuite into its own tables. There isn't any integration other than syncing the data. Therefore, optimizing the data syncing process can help speed up reports. 3. Avoid Unnecessary Joins: When building facts to import into a semantic model from a NetSuite derived data source, avoid unnecessary joins. The data may fail to import into a semantic model due to "join" issues, even if there are no joins. Remember, NSAW is a separate portal that syncs data from NetSuite into its own tables. Reports within NetSuite cannot fetch data from NSAW. You have to go into the NSAW interface to use it. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******