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 / ashok kumar j

OLTP::

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the benefits of sap business one?

573


What are the sap business one modules?

588


Is it possible to alter the standard behaviour of sap business one using sdk ?

579


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.

2992


What is reconcile Adjustment Account in SAP Business One

2543






Can we do aggregation in sap crm planning cube?

2375


What is the value returned when any method of a di api object executes successfully?

662


What is dbdatasource ?

879


Can sap business one be customized?

564


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

570


How to fill data in recordset ?

662


Can we load the datatable directly using sql query ?

641


what is cell formatting? and advantages?

4215


What is company object in sap business one ?

581


What is the function of ui api i.e. User interface api ?

625