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

Which property of matrix gives the total number of rows in the matrix ?

604


In sap business one sdk, which object is used for executing sql queries and stored procedures ?

571


What are the limitations of di server?

645


What is difference between transfer rules and update rules?

593


Can sap business one be customized?

603






What will happen if we remove eventfilters ?

590


How types of reports we can create in BOBJ

2112


Where does di server executes i.e. Client or server ?

609


What is ‘sap business one’?

610


What are the different types of datasources ?

607


Which table saves the details of country ?

585


What is the function of observerdll.dll ?

805


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

596


Which tool is provided by sap for keeping the track of events ?

617


What are the different objects in di api ?

583