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
Explain different parts of di api?
What are the limitations of di server?
What is the value returned when any method of an di api object executes successfully ?
What is used in sdk for developing a form ?
What are the benefits of sap business one?
Where does di server executes i.e. Client or server ?
What are the different types of datasources ?
How types of reports we can create in BOBJ
What is company object in sap business one ?
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?
Which tool is provided by sap for keeping the track of events ?
What is reconcile Adjustment Account in SAP Business One
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
What is the use of company object in sap business one ?
What are the different objects in di api ?