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

Hi everybody, This is Srinu,recently i got selected for a small comapny with sap b1 but i was new to the technology.I knew c#.net,asp.net,Sql server 2005.My question is what are the pre-required knowledge to learn SAP B1 please suggest me. Thanks & Regards.

1630


What are the features of sap business one include?

698


Can we do aggregation in sap crm planning cube?

2538


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

761


Can we load the datatable directly using sql query ?

831






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

754


What is dtw in sap business one?

848


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?

1995


What are the different parts of di api ?

847


What is used in sdk for developing a form ?

701


can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase

1896


Can sap business one be customized?

763


What are the different types of transactions supported by di api ?

918


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

737


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

746