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 are the different components of sap business one client software ?

630


Can we load the datatable directly using sql query ?

678


Which property of matrix gives the total number of rows in the matrix ?

609


What will happen if we remove eventfilters ?

590


What is company object in sap business one ?

607






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

599


What are the features of sap business one include?

556


What is used in sdk for developing a form ?

583


What are the sap business one modules?

621


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

569


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

2173


What is the function of observerdll.dll ?

809


What are the complex reports you developed in Business Objects.Please tell me 3 reports you developed and the complexity you faced and the solution

4702


What is reconcile Adjustment Account in SAP Business One

2573


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

766