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
Thanks in advance,
Answers were Sorted based on User's Feedback
Answer / hema
oltp -- example for oltp is sap r/3.it is optimised by
data storage.read,write access is possible.contains limited
historical data.data base size is finite.
olap--- example for olap is sap bw/bi.It is optimised by
reporting.Only read access is possible.Contains lots of
historical data.Data base size in infinite
|Is This Answer Correct ?||17 Yes||2 No|
Answer / ashok kumar j
It Is Exclusively designed for Transaction purpose only,when we use this for analytical process it will have load on data base.
We can Maintain only transactional data i.e current data.
Integration across different modules is tough task.
OLAP:: It is used for analytical processing.
In This we can maintain the historical data.
Integration across different modules is easy.
|Is This Answer Correct ?||5 Yes||0 No|
1.Its a Two dimensional Analysis.
2.We can store the data in a limited Period.
3.Here detailed Level of information is available.
1.Its a multidimensional Analysis.
2.we can store the data more than 5 years.
3.Here Summerised level of information is available.
|Is This Answer Correct ?||4 Yes||1 No|
Answer / shanu
Security Needs in mySAP ERP (OLTP) – Online transaction
•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
•Different business purpose and goals than OLTP
•Focused on displaying, planning, and analyzing data
|Is This Answer Correct ?||1 Yes||1 No|
Answer / sadaddin
OLAP(online Transaction processing):
It contains the current data.Any system Supports INSERT,DELETE,UPDATE & SELECT operations is also known as OLTP.Because of "Update" & "DELETE" statements it contains Current data.
OLTP(online Analyitical Processing):Report to Report comparision is called Analysis.Data WArehouse contains current data+ historical data for Analysis is named as OLAP
|Is This Answer Correct ?||0 Yes||0 No|
Answer / praneeth
IT is a two dimensional table included with ER-model(entity relationship model).here we can analyse only two dimensions.
It is a multi-dimensional table included with 4 schemas i.e,
star schema, extended star schema, snow flake and highbrid.
In bi we can use extended star schema.
|Is This Answer Correct ?||0 Yes||1 No|
What is di server in sap business one ?
what advantage of ic with aggregates
Which property of matrix gives the total number of rows in the matrix ?
what is cumulative and non-cumulative key figures in sap bi?
Hi Experts, 1. Can any one tell about how to know the Cube size 2. How to delete single Wrong transaction in Cube
Hi, I am currently working in midsized company in SAP Business One after getting two years experience can i move to MNC company with SAP B1 or can i change technology to SAP ABAP na Please suggest me......
can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase
Where does di server executes i.e. Client or server ?
Name of the tool used for unit testing
What are the limitations of di server?
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
Which table saves the details of country ?