Workflow and Data Integration

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

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    

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 

I am trying to load data into a new cube from the vStageSourceAndTargetDataWithAttributes table.  I am seeing most lines duplicated numerous times and the only field I am seeing with different values is the 'Ri' field.  I have not been able to find a listing of the definitions of the fields in this table and so am struggling to determine why the data is duplicated in Stage.  I have checked the actual data import from Snowflake and it does not show duplicates at any stage of the import process. The SQL I am using to pull the data is: SELECT TOP 100 *FROM"vStageSourceAndTargetDataWithAttributes"WHERE Si = 'SF_Rev_Summary'AND Ac = 'ACCT0334_AC'AND Et = '0034_ME'AND Tm = '2023M1'The results from the data adapter are below, the first 5 rows are duplicated apparently due to the 'Ri' fieldI appreciate an insight or feedback folks may have. Thanks

HiI am executing a data management sequence from a business rule and I would like to display the task progress dialog box. Is this possible?e.g. When I click run from the Data Management tab I get the following:I would like the user to see the same thing when I run the data management sequence from a business rule.Regards,Mark 

Outside if BI Blend, is there a use for the Attribute Dimensions and Attribute Value Dimensions?All of the documentation that I am reading, the search for Attribute Dimension only shows up in the BI Blend Section.

Does anyone have a solution to having the workflow period default to the global time? It's a minor annoyance, but for those switching workflow profiles often, it's annoying that it just always defaults back to Jan, and then you have switch to the current period. I understand that not all workflows are set monthly, but if your scenario Input frequency is monthly, it would be nice if it could read of the global time as the default period it goes to, versus just going back to a locked period.

Hello,We noticed that Workflow on entity can be unlocked and relocked even if the parent workflow (period) is locked. We need to have a direct dependency between the parent and child workflows for the lock of the period.

Hi, I am starting last month as Admin. I am trying to help one of our internal users with an issue. The amount that was imported by accounts and by base level LE_PC_CC that belongs to the gray area in this Workflow can't be seen or opened in this WF form to be manually adjusted. Is there something wrong with the configuration of the Workflow?  Thanks in advance!  

Hello everyone,We are trying to upload data to OS through a csv but I'm getting the following errorI checked the file both with excel and directly with a text editor and it seems the amount is correctly formattedDo you guys have any idea why OS is giving us this error?

Hi - Is there a way to override security to show the IC Partners' Workflow Statuses in a Dashboard so each workflow can view altogether the status of all Partners?  I created a data adapter using a WorkflowAndEntityStatus Method Query but they can only see the Workflows they are in the Access Group of.  Can I replicate what is happening behind the scenes in the IC Matching > Show Partner Workflow Status?Thanks in advance to anyone that can help! 

Of all the File Share types, the one I least understand is the "Contents" folder.  What is it used for? There are even three System Security Roles controlling its use, but no clue in the Design and Reference guide as to what we are meant to use that folder for.  Can someone please educate me?  

I've seen an earlier post around this issue.  Was there a bug?  Is there a solution? thank you.

I have scheduled a data management sequence to run every 120 minutes between a specified time range (7 am to 9 am) -- But the data management sequence is not being executed. There are no parameters needed in the data management sequence, and I have confirmed that manually running the sequence works without error. When I check the grid view in Task Scheduler, I can see the "Next Start Date/Time" column is correct. However, when the system finally reaches that time, the task is not executed, the "Count" column remains as zero, and the "Next Start Date/Time" column updates to 120 minutes later. I receive no system errors on why the task is not executing.I have confirmed the scheduling a one time task, or even a daily task works successfully.  Any help on this would be great.

Is there any check that we can put in the WF confirmation step to check the if the data that was loaded through import was actually validated?I have configured the confirmation rules group which will show error/warning based on the threshold amount for the v_ Accounts.But if the data is not loaded to the cube, the variance accounts would still have zero balance, so the confirmations rules are still green as its technically within the threshold amount. Need to check if there is a way to not allow the users run the confirmation rules at all without passing the complete Import-Validate- Load sequence.

Hello there,I made an Event Handler capable of retrieving all 'Transformation' & 'Validation' rejects in order to treat these irregularities automatically. The script creates a 'List' type of transfo rule in the concerned dimensions and populates it with all the rejected source values. The script works just fine for most cases. However, if the group of transformation rules has One-To-One mappings then the 'List' rule is just ignored (since One-To-One is prioritized over Lists).My questions: - Since I cannot afford to go over original One-To-One mappings & change target value to 'ByPass', how can I modify the order of transformation rule types(List then O-t-O then composite etc...) ? If not possible, how can I retransform my data at the end of import using 'List' transfo rules only ? 

Hello, I'm trying to figure out a way to have OneStream perform profit in inventory eliminations.Currently we manually compile data in excel to calculate how much profit sitting in the inventory and at what common parent we need to eliminate it. These manual eliminations are ultimately loaded in OneStream via upload files.One thought is to setup custom input form in the workflows that would collect ins-&-outs of profit in the inventory and utilize Flow dimensionality. But I'm not sure if there is a better approach to this problem.  

Hi All, My team and I need to create a dashboard that will help the user in bulk certify workflow profiles. the whole interface is similar to Workflow Multi-Period Processing(screenshot) but with few changes, which will only focus on Certify the workflow profiles for import trial balance step for multiple LEs at once and not multiple steps for 1 LE. This needs to be created under Dashboard process. Is there any guide or marketplace solution for this? any help will be greatly appreciated.     

Hi Team,   I would like to know does anyone Implemented the OneStream Integration with NetSuite Cloud using RESTlets and I am looking for the right documentation and the details required from NetSuite cloud. Thanks  

Quick Question I have a WF with a Form Profile and the form has Jan - Dec with an account. 1. I Created WF Profile and assigned it too the WF Profile form 2. Made the account as No Data Lock.  3. Input the data and saved and locked the WF Profile Form. 4. When I navigate to Feb I still able to see input data for Jan and the Form is not locked? Any Idea what I am missing?

Originally posted by Stan AllanWe have a client that wants to develop and interface from Dynamics 365 F&O to provide the GL transaction data to OneStream. Is there an out of the box solution? Has this been done before? We have done D365 to ePBCS but it required an export to a data file from D365 that is a manual process. The client wants this process fully automated. Thanks 

Hey all,So we have built a data seedning between cubes for Predictive 1 2 3 and are using DataManagement data exports via Data mgmt export sequence to our input workflow profile.We have a hierarchy of maybe 100 member where we want to seed the parent member only (the total) excluding 5 accounts in oreder to make the transformation rules as friendly as possible. Are there any way in a member filter in the DM data export to exclude members from the hierarchy? I have tried .remove etc with no luck.Thanks in advance!

Reaching out to the community to see if someone has created a BR to trigger cube loads in a batch or sequence for several WF. Found this snippet but unsure how to use it: Dim objLoadCubeProcessInfo As LoadCubeProcessInfo = BRApi.Import.Process.LoadCube(si, wfClusterPk)

Hello,I have a REST API which has been tested in POSTMAN. The problem is data is being pushed into OneStream. So how would this work in the BR. Any help would be appreciated. Thank You,Indu