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
Thanks. I have heard of other companies using a BI viewer to look at transactions but would you know if it is common to upload transactions into OS instead (given there could be millions of rows) and reasons not to do this?
Would you also happen to know if it is possible to report on transactions via quick views or if transactions would just sit in a table that needs to be filtered on and exported into Excel to see transactions across multiple dimensions at the same time (sorry, lots of questions🙂)?
Since a lot of people are telling you not to do it, doesn't that mean something? :) Just because it uses SQL Server behind the scenes, it doesn't mean that it can be a warehouse. Yes, there are ways to do it. However, you need to remember that the more data you add to the server, the higher SQL server tier you will have to go to if you are on the cloud.
Quick views and Cube views are cube-only options, so the items in relational views won't show up there unless you come up with a relational blend, but that won't work if you want to report on transactions. A dynamic cube is an option. However, it is still bound by all the cube constructs, so you won't get much leverage there. Keep in mind transactions are not cube-based. Why don't you add the database as an external source and use dashboards to show the detailed information when needed, as a linked dashboard in CubeViews?