Forum Discussion

mlopez's avatar
mlopez
New Contributor II
4 months ago

Central Import and Account Reconciliations

I’m starting an Account Reconciliations implementation and the current process loads Actuals for all entities through a central import. They do have individual workflows for each entity where security is assigned at that level and used for planning and reporting.

 For RCM they want to look at their recs at that level too (WF entity) but data is not flowing through. Did the discovery both at the Central and individual levels and only the Central inventory is being populated. I guess it’s because data is not being loaded to stage into those WFs.  Is there a way to work around this or will data need to be loaded at the entity level for it to work?

 

1 Reply

  • SimonHesford's avatar
    SimonHesford
    Contributor II
    1 day ago

    That is correct. I personally don't like the native central load functionality in OneStream for precisely this reason, as you lose ability to interrogate the imported data at the Workflow level.

    What I like to do is set up a central load based on a centralized batch process which takes the data for all entities and then hands off the loads to each entity workflow based on the Entity associations. This has a number of benefits:

    1. You always have visibility of the imported data at the individual workflow level.
    2. Validation errors / missing mappings etc only stop the load for data associated with a specific Workflow not the entire central load as happens with the native Central Import.
    3. If you have large volumes of data being imported you can take advantage of the in built parallelism option present in the BRApi BatchHarvest method.
    4. You have the ability to import data through individual workflows alongside the central load function if required