What is the difference between data on SAP R/3 and data on SAP Business Information Warehouse or, as it's now called,
NetWeaver Business Intelligence?
SAP R/3 is a transactional system and BW (or NetWeaver BI) is a data warehouse system. Data on R/3, which is an online transaction processing (OLTP) system, is used for day-to-day business operations and is highly normalized. BW data is used for analysis, and most of it is aggregated and de-normalized.
Dig deeper on Business Objects and SAP business intelligence
Related Q&A from Jay Narayanan
An SAP user is looking to change the values of a characteristic in an SAP InfoCube and wants to know if it's possible to use virtual InfoCubes to ...continue reading
An SAP user is looking to assess the hardware requirements for an SAP BW application and wants to know what the parameters are of sizing hardware for...continue reading
Find out if a department running SAP R/3 4.7 needs an additional server to install SAP Business Information Warehouse (SAP BW).continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.