Application Developer Interview Question:

What are major benefits of reporting with BW over R/3? Would it be sufficient just to Web-enable R/3 Reports?

Submitted by: Administrator

Performance - Heavy reporting along with regular OLTP transactions can produce a lot of load both on the R/3 and the database (cpu, memory, disks, etc). Just take a look at the load put on your system during a month end, quarter end, or year-end - now imagine that occurring even more frequently. Data analysis - BW uses a Data Warehouse and OLAP concepts for storing and analyzing data, where R/3 was designed for transaction processing. With a lot of work you can get the same analysis out of R/3 but most likely would be easier from a BW.
Submitted by: