Unable to load Data into OneStream
Hi, We are currently attempting to load data into the OneStream Workflow Profile using a CSV file. However, we are encountering the following error during the process: We checked many videos and the training courses but couldn't identify where the issues is, Could you please assist us in identifying and resolving the issue? RegardsSolved76Views0likes3CommentsSmart Integration Cloud (SIC) error
Hello, I am trying to query a local app which have 200k rows on SQL server using SIC (Smart Integration Cloud). However, I get the message : "Received an unexpected EOF or 0 bytes from the transport stream." There is an online troubleshooting which I added below. It seems this is a memory issue. However, there's no mention on how to add memory (on the server ? on my local machine ? how to do it ?). --> could you please help me sorting this out ? Regards, EDIT : I get the same error message when querying a table of only 1 row, 1 column. Memory Issues If you receive any of the following errors, increase the memory in your Smart Integration Connector Local Gateway Server. For queries returning over 1 million records, 32 GB or more RAM is recommended. "Error while copying content to a stream. Received an unexpected EOF or 0 bytes from the transport stream." "An error occurred while sending the request. The response ended prematurely."846Views0likes6CommentsComposite Mapping
Can I use Attribute dimension to write composite mapping with other dimension? Context- I am reading extra column from a TB load to drive the mapping.I want store this additional information in Attribute dimension (and not using any free UD) and use that to do composite mapping. Is it possible?18Views0likes1CommentAccessing multiple import file names via DA
HI Guys, Is there anyway via a method query or rule in a data adaptor that I can specify parameters to give me all file names related to a workflow. I preferably want all file names in a specific workflow for all years in a data table of columns: (Workflow,Year,Filename). Presumably doable with a dashboard data set rule but Ive never played with the staging engine before! Guessing also that its probably a case of looping years and appending tables. Thanks, TomPrompts for Power BI
Dear community, My company has just switched over to v8 and we are in the works of switching over from a current rest API to the Power BI connector. Is there any guide or thread that goes through how to set the prompts for the connector? I get a little bit confused as to what needs to be filled in. For example, the prompt asks me to fill in "Entity" and many other dimension parameters - however, our business consists of many, many entities and I would not like to create one data connection for each one of them. Same goes for "Account" and many other fields, none of which I am able to leave blank. Any advice? Rasmus50Views0likes1CommentNetSuite to OneStream Integration
Hello all, I need to verify and confirm the method of choice to set up an NS to OS 8.5 integration WITHOUT the SIC in play. Here is what I have uncovered thus far.... A SuiteAnalytics Connect is being considered via ODBC so OS can pull data from NS. I read a few things about this. One is that a BR would be set up in OS to call on a SuiteScript in NS initiate the data pull. Now, the missing piece is how to set up the connection in OS if there is no ODBC installed. Another thing is that SIC would not be needed. I also perused a blog that stated that Support can set up s direct connection to NS from OS, provided they have the NS info. Can anyone please confirm this approach? Rest API could be leveraged but looking for an alternative. Any input would be greatly appreciated. Thanks, Ed P47Views0likes0CommentsLoading Annotations Only via a Workflow
Is it possible to create a data source to load annotations only from a flat file. I am tagging the annotations in the flat file with the View dimension. It seems like the data source always wants an "Amount". Is this case I have no amount so when I Ioad the data file, I get an error that "No Valid Data Keys in File". It seems that this should be possible. Maybe I should do this via Excel loads.Solved3.6KViews1like7CommentsExtract table of one app and import to another app
Good Day I would like to know if it is possible to extract a table out of a DEV onestream app and then upload that table in a UAT onestream app? If not, are there any tools on marketplace which can assist in doing so? Regards RehaanSolved1.7KViews1like3Comments