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 / praneeth
OLTP
IT is a two dimensional table included with ER-model(entity relationship model).here we can analyse only two dimensions.
OLAP
It is a multi-dimensional table included with 4 schemas i.e,
star schema, extended star schema, snow flake and highbrid.
In bi we can use extended star schema.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is di server in sap business one ?
What is ‘sap business one’?
my name is sandeep i want to join SAP Bi/BO hyd. can anyone suggest best institue or tranier with material also .sucess rate of them should be very good.. bcoz its very hard select insistiue in ameerpet...one and other all are same many people are misguided.. failling in interviews...if any one know please help answer this question so this will help others also
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?
can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase
For performing heavy duty operations what is suitable di api or di server ?
What are the limitations of di server?
Which are the dll’s used in sap business one sdk?
What are the features of sap business one include?
How is sap business one implemented ?
What is the difference between a client & customer in a SAP BI Project?? Is it same?
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?
What is difference between matrix and grid in sap business one?
What is dtw in sap business one?
What is the function of observerdll.dll ?