Can anybody explain the what is "OLTP"(Online Transaction
Processing) and "OLAP"(Online Abaytical Processing) in SAP
BW/BI? and also plz explain What is the differences between
those two?


Thanks in advance,
Phani

Answer Posted / sadaddin

OLAP(online Transaction processing):
It contains the current data.Any system Supports INSERT,DELETE,UPDATE & SELECT operations is also known as OLTP.Because of "Update" & "DELETE" statements it contains Current data.

OLTP(online Analyitical Processing):Report to Report comparision is called Analysis.Data WArehouse contains current data+ historical data for Analysis is named as OLAP

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which are the dll’s used in sap business one sdk?

798


What is the difference between a client & customer in a SAP BI Project?? Is it same?

3663


What are the functions of data interface api (di api)?

776


What is a/p invoice ?

760


Why sap business one?

832






What is di api in sap business one?

759


For performing heavy duty operations what is suitable di api or di server ?

800


What is ‘sap business one’?

835


What is the value returned by a method when it executes successfully?

793


What is di server in sap business one ?

781


How to fill data in recordset ?

883


can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..

2140


What are the different parts of di api ?

889


If we are Extracting Data From SD Application component.ie Ex:- sales and billing 2lis_11_vahdr & 2lis_13_vdhdr Data Sources.Can I load From These 2 Data Sources to sales overview Cube 0sd_c03.Can you Explain the procedure.

3198


What are the limitations of di server?

821