SAP-BI@OLTPvsOLAP

Existance of an entity is not the business, but these entities should interact with each other to perform transactions, set of these transactions becomes business.
OLTP:-
----
When ever we perform a transaction, we record this transaction into the database.
* In OLTP System we generate Transaction data.
* Transaction Data:- data representing a particular transaction.
* Master Data:- Detailed Information about the Entities.
Customer, Material, Vendor,
OLAP:-
-----
* Online Analytical Processing
* As part of OLAP we extract all the transaction data from different OLTP Systems and store data and provide Analytical Data.
* Analytical Data:- Data which can be used for Analysis.
* SAP BW is an OLAP Application.
OLTP V/s OLAP or Why OLAP or Why SAP BW:-
---------------
1. When we do Reporting in OLTP it degrades the Performance of OLTP System, So we extract all the transaction data from different OLTP Systems and store data in OLAP and provide Analytical Data.
2. In OLTP we dont store TD for Longer time, So in OLAP we store Historical Data fro 5 - 10 Yrs.
3. In OLAP we can Integrate/Consolidate the data coming from different OLTP Systems in OLAP.
4. In OLAP we can provide authorizations based on the Data, But in OLTP we provide authorizations based on the reports/Transactions. because of this if we do reporting in OLTP system it affects ROI.
5. In OLAP we can have more Analytical reports like one of the Top customer did not buy one of your Top Product.