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

Answer / 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.

Answer / anand

OLTP:--
1.Its a Two dimensional Analysis.
2.We can store the data in a limited Period.
3.Here detailed Level of information is available.

OLAT:--
1.Its a multidimensional Analysis.
2.we can store the data more than 5 years.
3.Here Summerised level of information is available.

Answer / 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

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

Answer / praneeth

OLTP
IT is a two dimensional table included with ER-model(entity relationship model).here we can analyse only two dimensions.
OLAP
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.

What is difference between matrix and grid in sap business one?

0 Answers  

what advantage of ic with aggregates

6 Answers   Patni,

Where does di server executes i.e. Client or server ?

0 Answers  

Can we format BEx reports/graphs using HTML and CSS

1 Answers  

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

0 Answers  

what is UI and DI objects

2 Answers   Nastech, Nastek,

What are the features of sap business one include?

0 Answers  

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?

0 Answers   HCL,

What are the different parts of di api ?

0 Answers  

can we have separate cubes for Delivery & Billing Data Sources.

2 Answers  

process chain failure notifications

1 Answers   iGate,

what is concept behind incoming payment and outgoing payment?

2 Answers   Wipro,