Skip to main content
October 15, 2024

Level of data imported from ERP to OS

  • October 15, 2024
  • 1 reply
  • 0 views

What level of data do most of the companies import from their ERPs to OS, e.g. balances or transactions?  

1 reply

October 16, 2024

To support a consolidation process it would typically be balances (e.g. trial balance level of detail).  If transactions are brought it, it typically would be as a secondary load perhaps using BI Blend or to support account rec sub-ledger feeds.  If transactions are loaded to OneStream, typically they should be to Stage only (e.g. BI Blend) and not loaded to the cube as that can have performance implications.  But with drill back to ERP being a viable option in OS, there may not be a good reason to bring in transactions to OS at all.

TashkinAuthor
October 16, 2024

Thank you, Teresa!