Workflow and Data Integration

Hi! has anyone tried to download dimension data?  For example the entity dimension i want to extract in a relatively decent format ? and ideas on how?

Hello everyone, Is there a way to import data in such a way that we have more than 2 decimal places in the import step?  Our .csv files have 4 decimal places and OS is rounding those amounts to 2 decimal places. We would like to keep that level of detail Thanks in advance

Hi, Recently we upgraded our onestream to 8.2.2 and after upgrade we were not able to create files on SIC server thru this function ExecRemoteGatewayJob. please help me with this issue.   Thanks, Manju K

The goal is to get underlying dashboard data, I'm developing business rule using VB to call respective data adapter. The issue is, the data adapter has 1 parameter, not sure if it's possible to pass parameter value to it in BR. Below is my BR code and sample sql scripts for the data adapter, Dim isSystemLevel As Boolean = False Dim workspaceID As Guid = BRApi.Dashboards.Workspaces.GetWorkspaceIDFromName(si, isSystemLevel, "Default") Dim adapterName As String = "da01_entity_hierarchy_filtered" Dim rsTableName As String = "OutputTable" Dim dctVars As New Dictionary(Of String, String) Using ds As DataSet = brapi.Dashboards.Process.GetAdoDataSetForAdapter(si, isSystemLevel, workspaceID, adapterName, rsTableName, dctVars) If ds.Tables.Count > 0 Then 'If there are >0 tables in the results Using dt As DataTable = ds.Tables(0).Copy() op_table = dt.Copy() ' Clone the DataTable End Using End If End Using     SELECT C.NAME FROM Member C WHERE C.Name = '|!Sel

We would like to enabled SIC in on-premises hosted environment. I see Azure relay setup is needed, is there any documentation or steps to perform those? Please advise. Thanks, Vasanth

    Post deleted by the user

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 everyone, I have a question regarding confirmation rules - is it possible to run confirmation rules from outside a workflow via a dashboard button or some other method? Some of our users who would like to see the status of their confirmation rules without having to complete the form and workflow. Currently, they have to mark all forms as complete, complete the workflow, and process the cube to see confirmation rule status. Then, once they see which rules are failing, they have to revert the forms workflow, then revert individual forms - it seems like a lot of extra steps. The forms nodes on our workflows are set up as "Form Input, Process, Confirm, Certify". One possibility we've considered is a dashboard where users can click a button that runs the confirmation rules for their current workflow, then return the status of those rules in a grid view, all without having to complete the forms workflow. I've created a grid view to show confirmation rule status for the currently selected

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

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  

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.

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.

I'm building an integration that uses an OAuth 2.0 endpoint to return an access token for a 3rd-Party REST API service. I'm unlikely to be able to get a client-credentials grant for machine-to-machine RSET interactions (which would be ideal, so I have to proceed this way). It's Xero (don't ask....) The authentication endpoint uses a user/password followed by 2FA challenge in order to allow the API scope to be set, and an access token (and refresh token) to be returned to a redirect URL. I can do this easily in PostMan because PostMan - whilst not having a valid redirect URL - can intercept the request and extract the information in the URL/response Headers sufficiently for them to be used in subsequent API Requests. I'd rather not do this in PostMan going forward, and I'd like to handle the login/challenge in a Web Component in a Dashboard. I can get as far as opening the login Web Page, completing the 2FA challenge and then authorising the scope of source Entities, BUT when I hit OK t

Hello, I am looking to connect with any OneStream customers who are using OneStream as the source for their final trial balances. Currently we book a few top-sided entries in OneStream and then push them down to their appropriate ledgers the following month. This results in our trial balances coming from our ERPs to always be in balance. We are considering having our Shared Services Team take over some entries from our Controllers that would be top-sided in OneStream and we are considering not pushing them down to the ledgers. We are essentially looking at OneStream as being the source for our final trial balances. We currently use the Account Reconciliations Solution, so we would still reconcile the trial balance and all the tops-sided entries. Is anyone currently doing this? I've seen this done in HFM, curious if any OneStream customers are. Thanks! Regards, Ronnie Karpinski