Workflow and Data 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 P 

Hi, I get this error when saving data into a particular WP#Workflow S#Scenario T#Time member. Cannot execute step because the specified step classification doesn't exist for the workflow profile When I click OK to the error, when I refresh the data is saved. Any ideas what the problem is? What is a step classification? Thanks G

Hello, I've successfully set up an automatic upload using the Harvest Folder. However, I want to use the Skipline functionality within the file to reduce the import size. This works perfectly when I manually import the file into the specific Import Step. But when using the automatic upload via the Harvest Folder, the Skipline functionality doesn't seem to be applied. Does anyone have an idea for a possible workaround?

When we created our application years ago for a particular source our account mapping only needed the Source Account to map.  Now I have a need to do the account mapping based on a Location Source field that denotes a location for just two records exceptions.  Can I make a Composite Rule mapping that somehow includes the location from the Source file to create a composite rule for this exception or is the only solution to now include the source location field on my data source, and modify all the current mappings to have a wildcard for that field except my exceptions that need to be mapped to a different account.

Is it possible to get this setting in a business rule?Thanks,Scott

Hi, I notice that with dashboards, when allowed to prompt the user for values for their parameters, save the  user's last used value in said dashboard and populate that as the default value when prompted. By comparison, cube views don't store that information, and populate whatever is in the default value for the parameter when prompted. Is it possible to change what behaviour is used when parameters are requested from the user from a dashboard, and how would I do so? Thanks! Alex

Dear Community, Is there any way to delete the workflow channels in bulk? Currently we are in the process of deleting the unused UD7 members in the application and the workflow channels are setup based on the UD7 members. Since the UD7 members and the channels are in huge volume. Just wanted to understand if there is any rule or a marketplace solution which can be used to delete the WF channels in bulk? Any solution would help. Thank you so much.

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?Regards

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 prematu

I have the code below in an Extender BR.  It runs fine if I run it manually in the BR or manually through a DM job.  But when it runs in the Task Scheduler it fails, and I get the "Object reference not set to an instance of an object." error.  Any thoughts?  Dim wfUnitClusterPk As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, wfProfileName, wfScenarioName, wfTimeName) Dim ImportInfo As New LoadTransformProcessInfo Try ImportInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, wfUnitClusterPk, "", Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, False) Catch ex As Exception log.AppendLine("Import Done - Status: " & ImportInfo.Status & " - RowCount: " & FormatNumber(ImportInfo.RowCount, 0,,,-1)) log.AppendLine(ImportInfo.ErrorMessage) log.AppendLine("------------------------------") log.AppendLine(ex.GetBaseException.Message.ToString.Trim) End Try  

One user has to access one entity and all products which means they can view all the products belongs to the one entity. what type of security want to use. can someone guide me.

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?

I am running some data loads using Batch Harvest. I want to be able to capture the Validate Transformation and Validate Intersections errors to include in an email.  I am able to get the Validate Intersections errors from the application table.  Does anyone know how I would get the Validate Transformation errors?   If I run the entire job within a BR then I can get the Transformation Errors, but I would rather run it through the Batch Harvest.  I appreciate any input.Thank you.Scott

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,   Tom

Hello Integration Experts,I would like to know what are the alternatives we have to Integrate Netsuite with OneStream and which is best among RESTAPI and ODBC. Thanks

Is there a way to load to multiple scenarios from one Workflow? Example, from the below Workflow POV, I want to load to the Actual_PP scenario, but also to the Forecast_PP scenario. I don't want to create a new workflow for forecast because I want to use the values from People Planning that have been calculated for Actual_PP to populate both scenarios.  I don't what to load the People Planning register twice and calculate it twice.

Hi All,I am trying to create simple Extender rule to export only the AverateRate FX rates.  I saw this post: What is the most efficient method for exporting FX rates to a CSV file in OneStream? | OneStream Community  But this does them all.  Short of exporting to this file and creating another file from that one.  Does anyone know how I can filter the export to just get the Average Rates?I see the variable xmlOptions.ExtractAllItems = True.  But if I set it to False, I don't see what options I have to filter to specific metadata. I'm open to exploring other options as well.Thanks,Scott 

Hi,I am trying to load data from BiBlend to cube using a import validate load steps on my workflow and using also a connector, but i truggle a bit onthe connector Businessrule, i would like to know how the BR can connect to my biblend table.I have already done a br connector cube to cube, but never a biblend to cube.if you have any example of the script that i can add to my BR in order to connect the BiBlend Data table it would help a lot.Thanks, 

Hi,I have an admin dashboard where I show all parameter values and information I need before I start my Data mgmt jobs. There is one value I dont figure out how to show in my dashboard. I have a Conditional input rule on the Cube. Can I create a parameter or Data Adapter or something to be able to pull the value and show in my dashboard? I only need to retrieve the Scenario value.  

Hi all,I have connector rule set up to an external source table that is working fine to pull data into stage, but I would like to automate the execution of the workflow as well so that the data in the cube is refreshed nightly.  I found the below api but it looks to me like it's meant to load a flat file into stage via an extensibility rule, not from an external table. I'm not sure how to connect it to the connector/import step I want to automate. Any thoughts? Dim WFTime As String = TimeDimHelper.GetNameFromId(api.WorkflowUnitPk.TimeKey)Dim results As WorkflowBatchFileCollection = BRApi.Utilities.ExecuteFileHarvestBatch(si, "Actual", WFTime, True, True, True, True, False, False, False)

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? Rasmus 

Hi,I've got a business rule where I use BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk) to look at the status of the parent workflow profile. However, if a user does not have access to the parent workflow profile, then they get an error "Security Access Error. User is not authorized to access workflow profile". So it seems that the function BRApi.Workflow.Metadata.GetParent(si, si.WorkflowClusterPk) is not very useful and it is a bit bizarre that it refers to user security. Is there a way to run this business rule as administrator perhaps or something else I can do?

I recently discovered that data from deleted Scenarios is not removed from many of the application data tables (XFW_PLP_Plan, XFW_PLP_Register, ...)   Does anyone know why it remains and is it safe to remove as the scenario no longer exists.   I would think removing the old data would improve performance and reduce db size.    Or am I unaware of the tools to perform such maintenance?

Hi,Is there a way that I can see all the intersection errors for all lines rather than selecting one line at a time and seeing just that one constraint error?I've checked in Application Reports and can't find anything that helps.ThanksGuy

Any ideas what attributes this message might be referring to? There are no errors in the error log and the Task activity shows reconciliation discovery was completed, yet New = (0). Thank you for any leads in advance!