OneStream - NetSuite

Hi Ghalbrooks,

Good that you joined the community! As your post does not contain any question, I think we would like to know what issue you are experiencing on OneStream. Obviously it will be complicated to help on NetSuite... but let's see 🙂

Yes we use NetSuite and OneStream for close and planning, people planning and account reconciliations. We use SuiteAnalytics Connect (to be installed on your NetSuite cloud instance) and ODBC drivers to connect to NetSuite from OneStream. Imports are mainly central and running a nightly batch process for monthly data and during close we often refresh manually 2 to 3 times a day.

• Import periodic transactions into stage. This data just sits in the stage i.e. no cube load - Periodic scenario
  • Entity, Account, UD1 to UD8, 8 Attribute Dims and 1 Value Dim
  • On average 200K records per month
  • Load time between 5 and 10 mins
• Load the above data into a YTD scenario to calculate YTD and load to cube.
  • Entity, Account, UD1 to UD8
  • On average 25K records as we drop all the attribute and value dimensions
  • Load, validate and process roughly 10 to 15 mins (depends on consolidation times)

The process looks a bit daunting but once you get your head around it will be simple. If you have specific questions let me know.

Sai

You can also use NetSuite integration capabilities outside of ODBC.

Yeah, have utilised the REST API in the past to integrate with NetSuite although not from OneStream. From memory one of the challenges was NetSuite timing out queries if they took too long and I think possibly lowering that timeout at some point. This was a while ago though.

Hi There:

I've created a YTD Trial Balance pull using this code on GITHUB. This should point you in the right direction. I would suggest making the connection via ODBC if possible; we had an API integration prior to implementing this and even with a relatively limited dataset, the upper threshold on the time to query in addition to the number of records became problematic.

Let me know if you have any questions:

https://github.com/nserpsolutions/public/blob/main/generic/nse_sa_trial_balance.sql

Hi all,

We have seen similar items with api usage as well.  There are paths to utilize the api while making sure it is reliable and sustainable.  We have done this with implementations to multiple cloud sources using their api.

Thanks,

Tommy

We use NetSuite and OneStream.  We actually have a lot of experience with NetSuite and OneStream.  I'm not sure I have the YTD piece solved for you, I am happy to share some of the practices we use for the connection of the two.  We have automated metadata updates and data loads from NetSuite to OneStream.

GhalbrooksI have a NetSuite Suite Script that will pull everything out YTD for you. The idea is that you need a business rule connector in OneStream to run the NetSuite SuiteScript that you'll have to install in your NetSuite Instance. I am happy to walk through it with you, but, it should give you everything you need without having to install ODBC drivers or anything like that. Also, the data is YTD.

Hi, Wondering how you ended up resolving this issue?