Difference between OLAP & OLTP

Former Member · ‎2008 Apr 23

Hi,

Kindly let me know the difference between SAP BW (OLAP) and SAP R/3 (OLTP).

rajkumar_kandula · ‎2008 Apr 23

Hi,

OLAP: Stands for Online Analytical Proecss

OLTP: Online Transaction Process

OLTP

Online Transaction Processing-

a)Here we have transactional data generate from MasterData.

b)Data Stored in E-R Model.

Master data is detailed Description about any entity.

Ex: SAP R/3, any Data Base.

Online Analytical Processing-

a) Here we have Analytical data generate from Transaction data.

b) Data stored in Multidimensional model.

Transaction data generates 2 or more entities performs any transaction.

Ex: SAP BW, ETL.

For More Info Refer any of the below links: