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
Can we do aggregation in sap crm planning cube?
What are the different types of datasources ?
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
What is difference between ap or a/p and ar or a/r?
Which table saves the details of country ?
What is company object in sap business one ?
What is the function of ui api i.e. User interface api ?
What is dtw in sap business one?
What is a/r invoice ?
Why sap business one?
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?
What are the benefits of sap business one?
Hi Friends, 1) What precautions i should take as a BI Consultant when it is to UPGRADE the version of ECC (Eg: from R/3 to ECC 6.0)? 2) Will this upgradation affect BI system anyway?
Which tool is provided by sap for keeping the track of events ?
What are the sap business one modules?