OneStream - NetSuite
Looking for others experiencing issues getting a YTD dataset out of NetSuite for loading into OS. Also looking to connect with other users who use NetSuite for the ERP and OneStream for planning. ...
Forum Discussion
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
Is it possible I can contact you? Could you explain how to bring data from netsuite automatically to OS? Where do you insert SQL code to connect netsuite tables? I am new to OS.