Add-in submit lines limit

OSAdmin
Valued Contributor
Originally posted by Armando Ortiz

Hi community,

Does anyone knows if there is a limit on the number of lines that can be submitted to OS from an Excel sheet and what is that limit?

Thanks in advance for your valuable help.

1 REPLY 1

TonyToniTone
Contributor II

OneStream can handle the maximum number of rows that Excel has to offer, which is 1,048,576 rows.  During the Import step through a Workflow, OneStream can interpret an Excel template file that is configured with the proper OneStream Excel headers to import the data into Stage.  

If the data is coming from Excel using the XFSetCell functionality, the data cell records are set within the Cube and not into Stage.  This process requires data to pass through a Web Server and depends on the throughput from the users machine all the way through the OneStream Application Servers.  In this case, there isn't necessarily a limit but there are many factors that impact the time to load the data to the Cube.  So the answer is, it depends.