Are there restrictions in using the AGO function on NetSuite subject area datasets? I've been able to use AGO successfully with CSV based datasets, but not NetSuite subject area dataset.
Here's a very simple report from the NetSuite - Customer Invoice dataset that works before trying to introduce a calculation using AGO.
Date filter is Start at 1/1/25
Month is NetSuite - Customer Invoice > Gregorian Calendar > Month
# Total Number of Customer Invoices is NetSuite - Customer Invoice > Transaction > Total Number of Customer Invoices
Here's the calculation that validates successfully.
As soon as the calculation is added as a row in the table, a Query Error is generated.
where the details are:
Error during query processing (SQLExecDirectW). |
|---|
|
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. |
(HY000) |
|
State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS [ecid:e25f7eb0-e95a-41f4-b5da-2c478b86c81f-0002efe6,0:1:1:6 ts:2025-08-26T16:48:13.567-00:00]. |
(HY000) |
|
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: |
(HY000) |
|
State: HY000. Code: 27037. [nQSError: 27037] Unresolved level: 0:0. (HY000) |
|
SQL Issued: SET VARIABLE ENABLE_DIMENSIONALITY=1;SELECT |
0 s_0, |
"NetSuite - Customer Invoice"."Gregorian Calendar"."Month" s_1, |
"NetSuite - Customer Invoice"."Transaction"."Total Number of Customer Invoices" s_2, |
AGO("NetSuite - Customer Invoice"."Transaction"."Total Number of Customer Invoices",Month,1) s_3 |
FROM "NetSuite - Customer Invoice" |
WHERE |
("NetSuite - Customer Invoice"."Gregorian Calendar"."Full Date" >= date '2025-01-01') |
FETCH FIRST 500001 ROWS ONLY |
|
I'm I doing something wrong, or is AGO not usable with NetSuite subject area datasets for some reason? If the latter, how does one create period-over-period comparisons with those subject area datasets?
Thank you!
