-
Move to SME Sandbox before the SME Branch framework is retired
If your organization uses the Semantic Model Extension (SME) Branch framework in NetSuite Analytics Warehouse, plan to migrate your customizations to the Sandbox framework by September 1, 2026. The SME Branch framework will be retired after this date. Sandbox will become the only supported framework for semantic model…
-
What are possible ways to ingest data into NSAW, my source has a custom ODBC/JDBC Driver?
My Customer wants to injest Home Depot data using the provided Custom JDBC /ODBC driver. Customer has Standard variant of NSAW. Anyway to injest the data into the ADW?
-
Last Year-to-Date Sales in NSAW Report
We have created a formula in NSAW report to calculate Last Year-to-Date Sales: AGO( TODATE( IFNULL( Invoice Transaction Currency Amount- Credit Memo Transaction Currency Amount, 0 ), Fiscal Year ), Fiscal Year, 1 ) However, the formula is returning data for the entire previous fiscal year. For example, as of today…
-
Filter or Parameter to remove items without price in NSAW
I am creating a report in NSAW based on the Sales Order dataset. Customer, Item, Qty, Line Amount in Base Currency I want to see all items a customer has purchased, with total qty and line amount. I have this as a pivot table. Within this report, it is breaking out components from assemblies, these components are blank /…
-
Get Started with the NetSuite AI Connector Service for NetSuite Analytics Warehouse
Ready to analyze NetSuite Analytics Warehouse data with your own LLM? You’ve invested in NetSuite Analytics Warehouse, a powerful platform that helps turn your business data into actionable insights. But what if you could explore that data conversationally with your own LLM? The NetSuite AI Connector Service for NetSuite…
-
NSAW - Connect to shipping address
I want to connect the address for transactions. I see the table DW_NS_TRANSACTIONSHIPPINGSADDRESS has the value NKEY. What value does this relate to in order to connect to the shipaddress on the transaction table? It looks like the same value as the Source Record ID, but when I connect by the source record ID, the data…
-
count distinct lines in NSAW
In NSAW, how do I create a pivot table to count lines on sales orders? I want to know by week and shipping location, how many orders are processed with one line, two lines, 3 lines, etc. I can count lines with a count(distinct) function when the order is in the table, but I loose it when I take the order out, and show at a…
-
NSAW Email Server Inquiry
Hi everyone - can't seem to find any documentation or resources around the email server for NSAW. Does anyone know if NSAW provides an email server and you just need to configure it, or do you have to get one yourself? Any guidance is appreciated, thank you!
-
How to reset NetSuite Analytics Warehouse instance in NetSuite?
Hello, we have an unused NSAW instance connected to our NetSuite sandbox and want to change that to the instance that is being actively worked on. How do I do that? I'm new to NSAW. Thanks in advance!!
-
MS Excel Add-in
Hi, I need to connect Microsoft Excel to NSAW to create pivot tables with refreshable data. Is this supported? If yes, what are the steps (eg. Excel add-ins, connection URL)? Are there any limitations I should be aware of?