Is it possible to schedule SuiteAnalytics Workbook...
# suiteanalyticsj
James Morris
08/08/2023, 1:40 PMIs it possible to schedule SuiteAnalytics Workbooks? I'm assuming no since I haven't been able to find anything about how to do it, but I'd love to be wrong.
m
Mark C
08/08/2023, 2:37 PMI don't believe so. It loads with current data when you open the workbook. What's the use case? Emailing results?
j
James Morris
08/08/2023, 2:39 PMyeah, I have some pretty long-running workbooks that need to be run for close, so it'd be nice to have those ready to go at the appropriate time each month.
m
Mark C
08/08/2023, 2:48 PMAh. As far as I know, you can't email SuiteAnalytics. You could duplicate the functionality in a N/query script and have that email.
There's a pretty good plugin for exporting workbook tables to SuiteQL. Search for 'NetSuite: Workbook Export'. But I think it only works on tables, and I'm guessing you want the visualizations?
j
James Morris
08/08/2023, 2:51 PMI need pivots. It'll only output the raw dataset?
James Morris
08/08/2023, 2:51 PMI've seen that option, but haven't explored it before (not much of a developer tbh, I usually just duct-tape other people's code snippets together if I really have to code something).
m
Mark C
08/08/2023, 2:54 PMYeah, I get it. Even pivot export drops it as a 'pivot-ready' CSV file. The functionality just isn't there yet.
j
James Morris
08/08/2023, 2:55 PMoh pivots finally export okay now (in the UI at least)
James Morris
08/08/2023, 2:55 PMthat used to be an issue, but isn't anymore
James Morris
08/08/2023, 2:56 PMit's the only reason I now use workbooks 😂 Just wasn't worth it before they fixed that.
m
Mark C
08/08/2023, 2:56 PMooh, I need to try that!
Mark C
08/08/2023, 2:57 PMAlthough we're using NSAW now, so Analytics isn't getting much use now.
j
James Morris
08/08/2023, 3:01 PMbut yeah I had a good long yell at support when they said in the release notes that you could export pivots and then it was just a duplicate of the button that already existed that exported the dataset. But finally fixed now, so yay.
3 Views