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
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.
What is the difference between a client & customer in a SAP BI Project?? Is it same?
What is difference between transfer rules and update rules?
Can we do aggregation in sap crm planning cube?
What is company object in sap business one ?
What is ‘sap business one’?
Which tool is provided by sap for keeping the track of events ?
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?
Why sap business one?
Which are the dll’s used in sap business one sdk?
How is sap business one implemented ?
What are the functions of data interface api (di api)?
What is used in sdk for developing a form ?
Is it possible to alter the standard behaviour of sap business one using sdk ?
What are the limitations of di server?