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 difference between matrix and grid in sap business one?

743


If we are Extracting Data From SD Application component.ie Ex:- sales and billing 2lis_11_vahdr & 2lis_13_vdhdr Data Sources.Can I load From These 2 Data Sources to sales overview Cube 0sd_c03.Can you Explain the procedure.

3173


Which table saves the details of country ?

709


What are the functions of data interface api (di api)?

737


What is a/r invoice ?

758






What are the sap business one modules?

752


What is used in sdk for developing a form ?

701


What are the different types of datasources ?

726


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

738


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.

1633


What is the function of observerdll.dll ?

940


What is company object in sap business one ?

718


can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..

2111


What is the use of company object in sap business one ?

746


What are the different components of sap business one client software ?

779