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

4684


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

615


What is difference between matrix and grid in sap business one?

594


Explain different parts of di api?

633


What is the function of ui api i.e. User interface api ?

631






How to fill data in recordset ?

679


What are the benefits of sap business one?

583


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

1947


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

586


What are the different parts of di api ?

675


What is ‘sap business one’?

599


Is it possible to alter the standard behaviour of sap business one using sdk ?

589


What is a/r invoice ?

608


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

559


Can sap business one be customized?

588