Skip to main content
Newcomer
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

T_Kress
OneStream Employee
OneStream Employee
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
Newcomer
October 16, 2024

Thank you, Teresa!