Hi
check if this is helpful
1.R/3 is an OnLine Transaction Processing System while BW is an OnLine Analytical Processing system.The former refers to an operational environment while the latter refers to a decision support environment.
2.R/3 reports represent a detailed transaction data.
EG: Daily bank balance for a year .
BW reports can be used to represent summarized form of data.EG:Weekly balance for 7 years.
Thus R/3 requires current data with minimal history whereas BW on the otherhand requires significant history
3.R/3 reporting changes with business events while in BW, it is fixed at a specific point of time.
4.In R/3,there is minimal integration with data from other modules/applications while in BW,there is significant interaction with data from other modules/applications.
5.Data in R/3 is highly normalized for performance, while in BW it can be denormalized or restructured for queries.
6.Update/insert/delete options are possible in R/3,while BW is read only
7) The structure of the OLTP database is optimized for transaction processing - not report generation which gives you the analysis of huge data - which leads to more "joins" and "table scans" .
😎 Processing transactions and generating analysis reports on the same database can lead to contention problems (e.g., "deadlocks" and "timeouts")
9) Generating the I/O-intensive reports on the OLTP system puts a significant load on the OLTP database ... thereby slowing the system's ability to process transactions in a timely manner.
10) Better front-end reporting within BW. Although the BW excel front-end has it's problems, it provides more flexibility and analysis capability than the R/3 reporting screens.
11) BW has ability to pull data from other SAP or non-SAP sources into a consolidated cube.
Regards
Dinesh
Bluesky
