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 / 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


Please Help Members By Posting Answers For Below Questions

what is cell formatting? and advantages?

4324


What is reconcile Adjustment Account in SAP Business One

2675


Can we load the datatable directly using sql query ?

775


What is the function of observerdll.dll ?

897


What are the benefits of sap business one?

677






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

719


What will happen if we remove eventfilters ?

703


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

772


What is the value returned by a method when it executes successfully?

695


What are the different objects in di api ?

662


How is sap business one implemented ?

685


What is ‘sap business one’?

724


Hi everybody, This is Srinu,recently i got selected for a small comapny with sap b1 but i was new to the technology.I knew c#.net,asp.net,Sql server 2005.My question is what are the pre-required knowledge to learn SAP B1 please suggest me. Thanks & Regards.

1575


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

2265


What is used in sdk for developing a form ?

654