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 is difference between transfer rules and update rules?

601


What will happen if we remove eventfilters ?

598


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

611


What is a/p invoice ?

625


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

639






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

1771


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

614


hi frnds dc's suma could u tell me. 1. expalin u have created any customize cube? 2. what is ur exp in bex and wad? 3. howmany reports u have created? give one scenario abour calculated key figure and formula? 4. tell me some recently what u have done tickets give me 2 tickets explain briefly? 5.what they (off shore team) have done ? what is cell formatting? and advantages?

2185


What are the sap business one modules?

627


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

772


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?

1821


What are the limitations of di server?

655


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

601


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

609


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

694