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 / anand

OLTP:--
1.Its a Two dimensional Analysis.
2.We can store the data in a limited Period.
3.Here detailed Level of information is available.

OLAT:--
1.Its a multidimensional Analysis.
2.we can store the data more than 5 years.
3.Here Summerised level of information is available.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the complex reports you developed in Business Objects.Please tell me 3 reports you developed and the complexity you faced and the solution

4777


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

726


What will happen if we remove eventfilters ?

703


What are the features of sap business one include?

632


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

3573






What is the use of company object in sap business one ?

696


What is di server in sap business one ?

697


What are the different components of sap business one client software ?

719


What is difference between ap or a/p and ar or a/r?

690


What is the value returned when any method of a di api object executes successfully?

772


What is the function of observerdll.dll ?

897


hi guys, now i am working in very small company for SAP_BusinessOne...after getting 3 years of exp in this company ..can i move to LEVEL5 Big Mnc's? any chance is there? or can i change technology instead of B1?

1907


Explain core modules of sap business one?

640


What are the different parts of di api ?

786


Can we do aggregation in sap crm planning cube?

2487