Workflow and Data Integration - Page 21 - OneStream Community

Workflow and Data Integration

Discuss data loading and processing into the application

Forum Posts

Sorted by:

Create a post

File move from local system to onestream harvest folder.

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 t...

Transformation Rule Mapping Null

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; s...

Resolved! Confirmation rules for unrelated entities

Hi everyone, Just hoping for a few pointers in case others have come across this before... I have a "Group Overlay" workflow set-up specifically to post central adjustments at year-end (for tax purposes mostly). It works fine as it has a specific wor...

SAP connector

We have been using the SAP connector for fetching the GL data and few other information like units and install base. The connectors were working fine until Oct 2023. We noticed duplicate and/or missing rows. The row counts would match. It would only ...

How to setup transformation rule to map if an item is a child member of a (another) dimension parent

I am looking to create a transformation rule for Accounts to map to a destination if the Department on the record is a child of a specific parent in the OS department dimension.ACCT600 DEPT101 --> ACT_EXP600_100ACTT600 DEPT321 --> ACT_EXP600_100Where...

Top Kudoed Authors

User

Count

11

5

3

3

3