How to differentiate between OLAP and OLTP systems?

[Former Member]

Hi,

I am a newbie in SAP-BASIS administration.

How to differentiate between OLAP & OLTP systems?

I have one of our sytems with the following specifications:

SAP Component : SAP Netweaver 2004s

SAP_BASIS : Relase 700 Level 14.

Operating system : Windows

Database : Oracle

How to find if this system is an OLAP or OLTP system?

thanks,

with regards,

Sekar

[Former Member]

Can you please check whether sap_bw and bi_cont is there as a component or not?

[former_member204746]

wrong answer!

SAP_BW is now part of all Netweaver ABAP-bases system such as ECC ,BW, CRM, SRM etc...

BI_CONT is somewhat different... but still, not a good metric.

why are you answering a 5-months old question with a wrong answer?

[Former Member]

Hi Eric,

One sap_bw might be a part but bi_cont is specific to BW systems right?

[ashish_vikas]

Hello Arul,

One of sites describes like this :

Online transactional processing (OLTP) is designed to efficiently process high volumes of transactions, instantly recording business events (such as a sales invoice payment) and reflecting changes as they occur.

Online analytical processing (OLAP) is designed for analysis and decision support, allowing exploration of often hidden relationships in large amounts of data by providing unlimited views of multiple relationships at any cross-section of defined business dimensions.

OLTP databases are typically input sources for data warehouses or data marts. The data warehouse in turn is the typical source of data for an OLAP database. The value in an OLAP database is that many complex calculations and predefined queries are preprocessed and results are stored and are available via an OLAP exploitation application allowing quick access to cross-sections of business data. Rapid access to the aggregate information across defined business dimensions allows quick navigation and understanding of relationships.

You may like to read this thread :

So, you can differentiate between OLAP and OLTP systems based on their Oracle parameters settings also. Check SAP Note 830576 - Parameter recommendations for Oracle 10g. We keep different parameters for both systems. If you have ECC it will be a OLTP system and if u have OLAP it will be OLAP.

thanks

ashish

[Former Member]

Hi,

Thanks for your reply.

with regards,

Sekar

[Former Member]

Hi,

for the differentiation between OLAP and OLTP the system's purpose is important.

If the system is used as a business warehouse (or business intelligence) then it is an OLAP system.

If it is on the other hand used as an ERP (ECC) system then it is considered an OLTP system.

Check the system -> status -> component version in your SAP GUI to find out whether you use a BW or an ERP system.

Kind regards,