Workflow and Data Integration

Hi,  I am using Derivative Rules in order to generate additional records in Stage. In this example, I have two derivative rules per I/C transaction. The account mappings will bypass the original source value and one condition will be met and therefore loaded to the cube. If the value is greater than 0, then the value will go to 40L1CA.001A_DER. If the value is less than 0, then it will go to 40L1CA.001L_DER. Derivative Rules: Account Mappings: IC Mapping:   The value shown below is $224,469.18 therefore the rule is correct. However, the IC is this case is mapping to None. I was expecting IC to map to IC partner 170 based on the IC mapping shown above. How can I ensure that the IC partner is mapped correctly to the cube? I want to ultimately tie out IC matching report.

Hi there  I need to write a composite UD1 composite mapping rule based on a another dimension (Entity)  Example :  looks to see if the Entity is a base of Parent A , then map it to UD1 X , otherwise if the entity is a Base member of Parent B, then map it to UD1 = Y Please help    

HiCan anyone advice how to push OS data back to SQL server by using SIC gateway?We setup the SIC to import data from SQL servers to OS successfully in SIC business rule, but no idea how to push back data from OS to SQL by the SIC.Business rules created in Extensibility do not work like BRApi.Database.SaveCustomDataTable function.Thanks 

Hi All,  We are using FdxExecuteDataUnit to export data to SQL tables for consumption by downstream systems. Is it safe to run FDX queries while consolidation/Data Loads is in progress ? Regards Sridhar 

Hi All, We are facing an error "Unable to execute Business Rule 'BusinessRuleName'. Select a valid workflow, scenario and year, when executing step from PowerShell/REST API. We are passing the parameters using the option "CustomSubstVarsAsCommaSeparatedPairs". Please help if the execute step and the execute sequence works for business rules with parameters using Data Management api from PowerShell. Please help me with sample code. Thanks & Regards, Lova Ramisetti.

Hi there, I have a Workflow Import process that runs automatically via Task Scheduler. My question is, is there a way to capture the Invalid Intersections then send it via email? The idea is to get alerted via email without opening the application that the Validation failed. Regards Jesse

Hello Community - I am using multi select combo Box to pass periods selected by user back to business rules, receiving the selected periods in the BR but while executing getting error "Error processing Data Management Step".  Under Data Management I have set Time Filter as WFTimeYear_CopyFAPC=|!ml_WFTimeYear_CopyFAPC!| and  Parameters = WFTimeYear_CopyFAPC=[|!ml_WFTimeYear_CopyFAPC!|]. It looks like the Time Filter is not processing multiple periods from the Parameters, what is the correct way to pass these periods into the Time Filter under Data Units section. Thanks.

Hello, Is it possible to get the user who completed a 'Form Input' step in OneStream ? To clarify, I am able to do so for 'Import/Validate/Load' steps but I'm under the impression that it's impossible for Forms or Journals. Anyone with a similar experience ? Thanks Here goes my desperate attempt: Dim wfstatus As WorkflowInfo = BRApi.Workflow.Status.GetWorkflowStatus(si, mywfstep) Dim logusername as String = wfstatus.LastExecutedStep.StepLogItems(0).UserName ' (wfstatus.LastExecutedStep.StepLogItems is Nothing) = True    

Hi Does anyone know where all of the below information is stored?    Thank you, Mikki  

Hi Onestream expects,I have a .xlsx file located on my local system's C drive that needs to be moved to the Onestream Harvest folder in order to import it into the workflow. Kindly provide an  Extender Business Rule code on this.It is really helpful to my requirement     

Hi,  I am trying to load a CSV file to OneStream through my Workflow. I have a few rows in my csv file where the IC column is empty. I am trying to map those IC lines to go in "None". How would you do this? I have tried through a one-to-one mapping; source: |null| and target: None, but it doesn't seem to be working. Thank you

Hello Everyone,I am having issues retaining the previously selected parameter value in the dashboard, which is linked to a button component. I have a dashboard that has a parameter to pick an entity, and this parameter is attached to a button component in the dashboard. Let's say I run the dashboard and pick an entity X from the button for the first time. If I try to open the same dashboard again and again, the same entity X gets displayed by default, which is expected.Now the problem is when I attach this dashboard to a workflow. From WorkFLow, the entity that I picked for the first time in Dashboard is not getting retained when I open the same dashboard multiple times from through WorkFlow. Is this behavior expected, or am I missing something here? It would be great if anyone could help here.Thanks, Balaji V

Originally posted by Rich House4/22/2020 Hi, I have a query I'd like to solve. I have a data source where the Entity and UD5 are in general driven from the same column ""Profit Center"", column 6, in a delimited file. However there are instances when the ""Profit Center"" column is BLANK. Is it possible for those instances to use a different column i.e. use the ""Company Code"" column 1. If its possible, what is the best approach? Or perhaps, can I populate ""Profit Center"" with the ""company code""? I could then use 100 and 600 in my transformation rule

Hello there, In an Import WF profile, I would like to duplicate all rows where the UD3 member is different than None. In the duplicated row, I need to change the UD3 POV to 'None' I know this can be done easily through 'Derivative Rules', however I am trying to do so in the Data Source through a 'Complex Expression' or 'Business Rule'. PS: This is bad practice since source data should NOT be altered to keep Audit trails, but in my case I am just exploring possible options  

Is there a way to log messages to the Error log within a Smart Integration Function that is running on the Local Gateway?  I notice when a new SIF is created, none of the OneStream libraries are available.   I did find an example where the OneStreamGatewayService library was included.  Is there any documentation on this library? Thanks, Scott

To be able to use them in Task Scheduler, you must organize your DataManagement Steps into Sequences. Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

How do we delete the seeding data for a specific entity and month without an import workflow or resetting the whole scenario?

Hi everyone, I'm having a problem with the Harvest directory. Indeed, I have two batches running at the same time and which retrieve files from an SFTP to put them in the Harvest directory in order to load them into the WF corresponding to each file, for this I use this line coded :Dim batchInfo As WorkflowBatchFileCollection = BRApi.Utilities.ExecuteFileHarvestBatch(si, fixedScenario, systemTime, valTransform, valIntersect, loadCube, processCube, confirm, autoCertify, False) But with this line I do not filter the files present in Harvest. Is there a way to filter by file name inside Harvest which seems to be common and mandatory? Thank you for your help

I have a delimited data source as matrix data to fetch opening, debit and credit flows. The credit amount comes in as absolute, and I need to factor it with *-1, but opening and debit flows must remain unaltered. As I need the data for RCM, it needs to be converted in Stage so I cannot use a Composite TR to flip sign on A#*:F#Credit.   Any recommendations on how I'd be able to achieve this in the data source?

Has anyone had success getting Journal audit data for changes to journals (not templates but journal entries)?  I suspect they can simply be pulled from the AuditJournalHeader and AuditJournalLineItem tables but having issues.  I only get one record in the Header table no matter how often I change a particular journal and nothing populates for the LineItem table.  I feel like they are not completly working correctly or I don't understand fully how and what they are logging.  I have tried to find a report in RPTA or other solution to see if I can figure out how its done but can't find anyting from OneStream for journal changes like there is for metadata changes.  If anyone has tried to tackle this I would appreciate anything you can provide.  Thanks in advance.

Hi I am loading data into a Bi Blend table and I don't want any aggregation applied. My understanding from the documentation is that I can use 'SSOnly.' However, whenever I try use this I get an error. Below is the config: Question 1: Am I doing something wrong in my config or is my understanding of how it works is incorrect? Another idea of mine is to set the Blend Unit Dimension Token to a UD member which will only ever have 1 member (e.g. UD4 and set the Aggregation Info to 'None'), so the aggreation should never create any additional aggregated parent records. I have tested this and it appears to work but I am worried that there is a potential issue that I'm not aware of... Question 2: Is this a viable workaround and is there anything that I should be worried about if I follow this approach?   Thanks, Mark    

Currently, we have a manual process that involves a user running a Load and Transform that uses a data source with a DM Sequence as its source. That sequence uses the |WFScenario| parameter. This all works great until we try to schedule it. I pass the scenario and the time in with a parameter at the Sequence level. The first step takes this parameter (e.g., Scenario=BudgetFinal) and creates a trigger file in the Batch folder and runs ExecuteFileHarvestBatch. The correct workflow executes but appears to be pulling its data (via that first DM Sequence/Data Source using WFScenario) from my current, user WF/POV. I've tested this by navigating to correct WF/Scenario, then running the DM job I want to schedule and the data successfully imports. If I then navigate to a different scenario and run the same DM job again, the import fails with the error that there is no data. I would expect the WFScenario parameter to use the scenario of the WF that is specifically calling the parameter but that

 I have a source file that will be updated/changed with the entities being loaded every time when it is loaded via a WF.In Order to preserve the balances of the Entities previously loaded I am thinking to have Source ID same as my Entity Name as I don't see any "Merge" Mode Load Option in WF. Is there any other way or better option to load files in Merge Mode.

Hi, I'm having trouble running a relatively simple Copy Data data management step. The step's source and destinations share the same cube, entity, time period, and view. They differ only on scenario. The step copies all of the imported, forms and adjustment data. There is data at the specified intersections (cube-scenario-time-entity-view) in the source. However, when I review the destination , I do not see any data copied to the destination. What else should I be checking to ensure that my Copy Data step works?  Thanks!

Hello everyone, I am trying to create a data source with two numeric values, one being amount and the other one being volume. But I am not sure if this is possible. Objective would be to be able to look at a P&L either in currency amounts or in unit volume. Is it possible?like this