Hi,
R/3 – OLTP (Online Transactional Data Processing)
1.The OLTP layer stores data with a very high level of detail (Transactional Data)
2.Reports from R/3 ia done by ABAP codes which is coplex and report retirval time is very high.
3.OLTP serever is very busy in handling transactions so if you use that for analysis thatis for reproting the preformance of the server goes down.
BW – OLAP (Online Analytical Processing)
1.Data in the data warehouse(OLAP) is compressed for high-performance access (agrregation).
2.It is designed specifically for query processing, not data updating and OLTP. Within BW, the data structures are designed differently and are much better suited for reporting than R/3 data structures. For example, BW utilizes star schema design which includes fact and dimension tables with bit-mapped indexes. Other important factors include the built-in support for aggregates, database partitioning, more efficient ABAP code by utilizing TRFC processing versus IDOC.
3.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.
4.BW has ability to pull data from other SAP or non-SAP sources into a consolidated cube.
5.reporting time is very less also server fuction is only for reporting and data extraction from various source system.
Assign points if it helps
Thanks & Regards,
santo
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.