Can ERP transactional data be loaded into OS?
Hi, my company's OS data integration with the ERP system has been set-up to load monthly TB's into OS and for transactional tables to sit outside of OS but with the ability for OS to query and drill-...
Forum Discussion
I agree with DanielWillis
There are so many ways you can report on this external data from inside OneStream that there is absolutely no need to duplicate your entire dataset inside OneStream. Just because something is possible doesn't mean it's necessarily a good idea.
IL have you consulted with a Partner (if you are a Customer) or Partner Enablement (if you are a partner) for some design advice here?
Sam
Thanks Sam, yes, am currently consulting with a partner. Aim is to try and get as much detailed analysis done within OS as possible, rather than using OS just for high-level reporting (because it's slow and difficult to get to the transactional detail), and then reverting to a datawarehouse table of transactions held outside of OS and producing analysis/reports via Excel instead.
IL - if it is for informational purposes only (e.g., not used for other derived computations or functions like transaction matching, etc.), it may be better to launch a direct query from within OneStream to the narrowed scope of transactions at source if your source ERP allows for that type of query (aka Option 1.1 from DanielWillis )
Cheers,
A.
