Workflow and Data Integration

I've seen a post about triggering a DM process from Control-M.  I wanted to see if anyone else is triggering a Control-M process from a Data Management job, and if you have a snippet you can share.

Hi All: I have created a new Datasource of Trail Balance which is excel source. I have written a complex expression in the logical operator. the logic is, if there is an amount in the debit column, bring that amount in, but if debit column is blank, bring the credit amount ((not negative)) in as a credit amount. I have below DataSource connection:   the code in the Logical operator: Dim debitColPosition As Integer = 2Dim creditColPosition As Integer = 3 Dim AmountDR As String = api.Parser.DelimitedParsedValues(debitColPosition)Dim AmountCR As String = api.Parser.DelimitedParsedValues(creditColPosition) If (IsNumeric(AmountDR) AndAlso Not AmountDR = "0") ThenReturn CDec(AmountDR)ElseIf (IsNumeric(AmountCR) AndAlso Not AmountCR = "0") ThenReturn CDec(AmountCR)ElseReturn 0.0End If when I am running through workflow, the source is trail balance file. I am getting the below error. any suggestions please if anything I am missing here. Error: Unable to execute formula. Index was out of

Hi, I have a workflow step set to workspace ->Import-> Validate->Load. I am running a DM job in the workspace.  How do I mark the workspace as complete once the DM job is completed? Please advise.

Difference between batch file loading in hyperion vs onestream

Hi all, Noticed the data cells in my input forms are turned read only and cell status also shows the same. Please suggest on how to make it enabled for input. Thanks

Hi, I have a scenario member which workflow properties are setup as follow: However, this means we will have to Reset the scenario next year to change WF Time to 2025 and t change the WF start and end times. Is there a way of using the Range in the workflow scenario settings and not having to Reset the scenario every year? We would be ok with users overwriting the overlapping periods (when working in 2025 they would overwrite the period from 2024M11 to 2025M4 which where previously within the Range of the 2024 WF Time), we are just trying to avoid having the extra step of resetting the scenario every year. Thank you

Hi, we have just added some local configuration values to local Gateway like in the following example: I am trying to retrieve those values. My understanding is that a Smart Integration Function must be created and that can than be called from a dashboard extender rule for example. However, the example provided in the OneStream documentation for the SIC function confuses me:  shouldn't the RunOperation function return the Result? Anyway, even setting the function type to String and returning the Result string, I am still having some issue in the getting the value over to a dashboard business rule. I am following another OneStream example in this case. First of all the "ObjectResult" does not exist as a member of "RemoteRequestResultDto" I have therefore tried to use a different member like "objectResultValue". I can compile the rule this one, but I get the following error when trying to run the business rule: "Object reference not set to an instance of an object."   Anyon

Hi, I am trying to use Smart Integration Connector for connecting to an SFTP server. We have followed the instructions on setting up the Local Gateway servers and the SIC have been created (see picture below). I have written a SIC function to retrieve the configuration values which are stored on the Local Gateway: I am then trying to invoke the SIC function in a dashboard extender rule as follow: 'Setup the objects to read Gateway Details from BRAPIs Dim objGatewayDetails As GatewayDetails = BRApi.Utilities.GetGatewayConnectionInfo(si, "ebs_prod_sftp_test") Dim objRemoteRequestResultDto As RemoteRequestResultDto = BRApi.Utilities.ExecRemoteGatewayBusinessRule(si, "RemoteGatewayValueFetcher", Nothing, objGatewayDetails.RemoteGatewayHost, String.Empty, String.Empty, False, 600) If (objRemoteRequestResultDto.RemoteResultStatus = RemoteMessageResultType.Success) Then If (Not objRemoteRequestResultDto.ResultSet Is Nothing And objRemoteRequestResultDto.ResultType = RemoteResultType.

Hi, is there a way to set a parameter via task scheduler and pass it to the data management sequence and also its' steps? I've been able to pass a parameter to the sequence but I need it to reach the DM-step. (pictures to prove example)

Hello folks, Is there an explanation why SetDataCellsUsingMemberScript() writes to the cube only the last value from a list? If the list is formed by 10 records only the last one is written. It seems it keeps writing to the same intersection by continuously overwriting instead of adding.

Hi, I'm trying to execute DM Step using Rest API using below URL and Body Text but I'm getting an error with error code 400 and with the message unsupported API version. Can you please let me know what could ne the issue? Thanks for your help! URL: https://servername/onestreamapi/api/DataManagement/ExecuteStep?api-version=8.2.2 Body Text:; {"BaseWebServerUrl": [https://servername/onestreamweb],"ApplicationName":[Consol],"DataManagementGroupName": [DataCopy],"StepName": [Test_Copy],"CustomSubstVarsAsCommaSeparatedPairs": [""l} Error Message: Request Status: 400 Bad RequestResult: Non-200 response code received: 400 URI 'https://servername/onestreamapi/api/DataManagement/ExecuteStep' does not support the API version '8.2.2'.","code":"UnsupportedApiVersion","traceId":"00-a6552d7760a854272b00c71c0b9fc82f-b8030eb56b2b0a75-00"}  

Hello, Is there a way to allow a group of users to quick post journals under a certain threshold amount, but if higher than the threshold the journal needs approval? I used a rule previously that will reject the journal if the user attempts to quick post above a certain amount, but then I can't figure out how the next step would be for X group to go in and approve it for them?   Thanks!

When building a Data Source bound to a Connector business rule, if a need arises to use a Complex Expression, and that expression requires referencing several unbound fields, what is the proper statement to use to retrieve those field values in the expression? I had been told to use the args.Line.Split function. For example, if I needed the Entity field in the data set, and Entity was the 10th field in the list, the expression would be: Dim entity As String = args.Line.Split(",")(9)The "9" is used instead of "10" because the zero-base index.I'm finding this args.Line.Split statement does not work properly if the field value contains a comma. The field imports correctly into the data set, but the args.Line.Split statement cannot differentiate a comma delimiter from one embedded in the field value and it ends up returning the wrong field. Is there another statement that can be used in Connector based Data Sources to reference fields in complex expressions?  

Is there a way to get Workflow Status Method Query, I have requirement to modify the Profile Name in the output to include Description along with Profile Name.

Hey I a running a stored procedure on Oracle EBS in OS using SIC. Me as a admin can run the job succesfuly. However other than admin users cannot.  Smart Integration Connector remote query failed.ORA-03135: Connection lost contactORA-03135: Connection lost contactAn existing connection was forcibly closed by the remote host What could be the possible issues. I checked the BRs and DMs used for the same I can see the changes the access groups are set to Everyone.SIC log: [2024-07-03 06:08:38 ERR] RunDBCommand Exception invoking SQL: Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-03135: Connection lost contact ---> OracleInternal.Network.NetworkException (0x80004005): ORA-03135: Connection lost contact ---> System.Net.Sockets.SocketException (0x80004005): An existing connection was forcibly closed by the remote host    at OracleInternal.Network.ReaderStream.Read(OraBuf OB, Int32& InbandErr, String& InbandErrMsg)    at OracleInterna

Is it possible to load one file twice without creating two separate loads?We want to load one file but with separate columns used in each load. Load 1: Amount- column G, Source - column B, other columns the sameLoad 2: Amount- column H, Source - column C, other columns the same Would I have to import this file twice with 2 of everything...WP, Data sources, etc. ?

Hi Team, Can someone please help to guide how to read the view last source & log file using business rules and save it back onto File Explorer for a user to access it. Regards  Darpan Bhansali  

Hi there,We are trying to test data provider endpoints using Postman but they always fail with Error: connect ETIMEDOUT xx.xxx.xxx.xxx:50001.I have read the documentation, manage to call Authentication API with Personal Access Token but no luck with other endpoints. OneStream support has enabled calls in IIS and has no clue what's wrong.For example:POST "https://{OurBaseWebServer}:50001/onestreamapi/api/DataProvider/ GetAdoDataSetForSqlCommand?api-version=5.2.0"Request Body: { "BaseWebServerUrl": "{OurBaseServerURL}/OneStreamWeb", "ApplicationName": "OneStream Test", "SqlQuery ": "SELECT * FROM Dim", "DbLocation": "Application", "ResultDataTableName": "ResultDataTableName", "XFExternalConnectionName": "", "CustomSubstVarsAsCommaSeparatedPairs": "" } Any idea?  

In a data connector rule, we need to run the api.Parser.ProcessDataTable funciton that can process a DataTable. However, using SIC funciton, we have to get data from the source into a XFDataTable: Dim xfDT As xfDataTable = Nothing . . . xfDT = New xfDataTable(si,objJobStatus.RemoteJobResult.ResultSet,Nothing,1000) The XFDataTable is created and we can see that it has rows in it. We convert the XFDataTable to a DataTable using: Dim dt As datatable = xfdt.ConvertToDataTable(si)  When we run the new DataTable thorugh the ProcessDataTable, we get an error: "Data load Ado.Net DataTable is invalid or null." When we try to count the rows on the DataTable, we get an error: "Object reference not set to an instance of an object" Is there any information out there about the differences between a DataTable and a xfDataTable? Is there another way to convert a xfDataTable to a DataTable that will no result in errors?  

We would like to automate the load process but there are always a few validation errors.  Is there a way to get the data to load excluding the ones with errors and email a report of the validation errors.  We would be able to load the good data and work on the errors before the following day load.

Dear community members, I have a DM Export Sequence defined in a workspace.  However, i am not able to save the data source after assigning the DM sequence to the Data Mgmt Settings:Data Export Sequence. While i am able to select the sequence, when i try to save  i get this error message:  And while the new workspaces are awesome i dont seem to be able to correctly interpret this helpful note in the design & Reference Guide.  If OneStream lets me select my DM sequence, does that mean that my DM sequence follows these rules? I have a Non-Default Workspace and a DM Sequence Name. But alas ....We are on 8.2.2.  Any tips or references to a solution that may already be here on community would be much appreciated.  

Under Calculation Definitions, there are options to run a task for either Loaded entities or Assigned entities. 1.  I am assuming that loaded entities stops to filter through only those entities that are part of the data load?  Am I correct in this assumption?  I saw nothing explicit in the documentation to that effect, but maybe I wasn't looking in the right place. 2.  Has anyone ever tested to see what the performance impact of using loaded entities might be?  Up to this point, I have only ever seen assigned entities in a workflow.  

I have couple of Connector DS and multiple Flat file DS in OS.Currently, the client wants to include Eurpoean culture for some of the users. I noticed that the dataload is behaving weirdly. The same data load now multiplies the data into 100 for a Eurpoean user/ what are the possible places where this should be fixed? Please note that I have multiple Parser,Conditional BR running on DS and TR as well.  

I am using below sql to get validation messages from the workflow transformation process to be used in  Transformation Event Handler. But, I need to put the output of this dictionary into a flat file. How I can read the contents of this dictionary created. Thanks so much for your help! sqlValidation.Append("Select * ") sqlValidation.Append("From StageToFinanceValidationError ") sqlValidation.Append("Where StageToFinanceValidationError.WorkflowProfileKey = '" & wfPk.ProfileKey.ToString & "' ") sqlValidation.Append("And StageToFinanceValidationError.WorkflowTimeKey = '" & wfPk.TimeKey.ToString & "' ") sqlValidation.Append("And StageToFinanceValidationError.WorkflowScenarioKey = '" & wfPk.ScenarioKey.ToString & "' ")   Using dbConnApp As DBConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si) dtValidation = BRAPi.Database.ExecuteSqlUsingReader(dbConnApp, sqlValidation.ToString, False) Dim sb_ValErrorsReport As New Text.StringBuilder() For E

Hello everyone,  newbie here,  We about to embark on phase 2 of our implementation with the first task of creating drill back capabilities to our Oracle EBS 12.2 (on Prem) application.  I want to try to organize as much of this as possible up front since my IT resources are extremely busy at this point.  I have been searching for guidance on the best options for setting this up, but have run into so much disparate information.   Is there any one of you fellow Oracle EBS users who would mind jumping on a call with me to discuss some of my options?  1.  Where can I find Oracle SQL code examples to drill back to trial balance, journal and subledger information 2. Where could I find OneStream code snippets that could be incorporated into my application for this drillback data.  Any help would be greatly appreciated.