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
- 16965 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 dbdatasource ?
What is the use of company object in sap business one ?
What are the different objects in di api ?
Why sap business one?
What is the function of observerdll.dll ?
What is company object in sap business one ?
What will happen if we remove eventfilters ?
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 are the different parts of di api ?
can any one explain end routine...like when it is used...and give an examole.......similarly for end routine..
How is sap business one implemented ?
What is the value returned when any method of an di api object executes successfully ?
What is used in sdk for developing a form ?
How types of reports we can create in BOBJ
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
