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
- 6 Answers
- 17901 Views
- I also Faced
- E-Mail Answers
Answer Posted / shanu
Security Needs in mySAP ERP (OLTP) – Online transaction
processing
•Transaction-based security
•Driven by:
•Transaction codes
•Specific field values
•Which activities a user can perform
•Focused on getting daily work completed as quickly and
efficiently as possible.
Security Needs in SAP NetWeaver BI (OLAP) – Online
analytical processing
•Analysis-based security
•Driven by:
•InfoProviders
•Queries
•Data
•Different business purpose and goals than OLTP
•Focused on displaying, planning, and analyzing data
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is difference between matrix and grid in 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
What is the function of ui api i.e. User interface api ?
What is di api in sap business one?
What is ‘sap business one’?
What is a/p invoice ?
What are the different objects in di api ?
What is used in sdk for developing a form ?
Explain different parts of di api?
What is a/r invoice ?
What are the features of sap business one include?
What is difference between transfer rules and update rules?
What is di server in sap business one ?
can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..
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?
