Question Re: OLAP /OLTP query in Additional Q&A

OLAP /OLTP query

Former Member — Mon, 17 Sep 2007 11:11:15 GMT

Hello All,

Can somebody pl. add thoughts for my below Quires

How can we differentiate between OLAP and OLTP system.

Is there a way to decide if perticular SAP product is OLAP or OLTP.

Thanks in advance.

Regards,

Tushar

Message was edited by:

Tushar Chavan

Message was edited by:

Tushar Chavan

Re: OLAP /OLTP query

Former Member — Mon, 17 Sep 2007 12:39:06 GMT

R/3 based systems are OLTP

BW based systems are OLAP

APO/SCM/SEM are also OLAP

transation systems = OLTP

warehouse/analytical systems are OLAP

Re: OLAP /OLTP query

Former Member — Mon, 17 Sep 2007 12:46:07 GMT

Hello,

Thanks a lot.

Now does it mean that every system having soft. component SAP_BW is OLAP system?

R3 system which is upgraded to ECC6 ( has sap_BW) is OLAP or OLTP.

Regards,

Tushar

Re: OLAP /OLTP query

Former Member — Mon, 17 Sep 2007 13:12:26 GMT

if you have a Netweaver system with both R/3 (ECC) and BW (BI), then you system is mixed.

I do not recommended mixing OLAP and OLTP systems on the same instance.

Re: OLAP /OLTP query

Former Member — Mon, 17 Sep 2007 14:56:21 GMT

Hello Eric,

I think I should rephrase the query.

R3 ( 4.7 ) system is OLTP. Now this is upgraded to ECC6 which has sap_bw integrated. So ECC6 is OLTP or OLAP.?

Regards.

Tushar

Re: OLAP /OLTP query

Former Member — Mon, 17 Sep 2007 16:41:49 GMT

ECC 6.0 or 5.0 do not have BW integrated. It has functionality so that a BW system can pull data from it (from the ECC system). Therefore, an ECC system is OLTP

I hope this helps

Andreas

Message was edited by:

Andreas Malandrinos

Re: OLAP /OLTP query

markus_doehr2 — Mon, 17 Sep 2007 16:46:14 GMT

> ECC 6.0 or 5.0 do not have BW integrated. It has

> functionality so that a BW system can pull data from

> it (from the ECC system). Therefore, an ECC system is

> OLTP

This is not true.

The component SAP_BW, which is integrated as of Netweaver 04, is in fact the OLAP processor, that IS the BW/BI. There's no content but with a system containing SAP_BW you can do what you would do with a normal BW. If you install BI_CONT ass AddOn with SAINT, you can run everything in one system.

One can run ECC and BW in the same instance, however, from a database parametrization view, this is not optimal - but technically possible.

Markus

Re: OLAP /OLTP query

Former Member — Mon, 17 Sep 2007 20:01:08 GMT

Marcus, that's very interesting, I didn't know it. Would you have any link in SAP Help giving some more information on this?

Many thanks

Andreas

Re: OLAP /OLTP query

markus_doehr2 — Mon, 17 Sep 2007 21:25:48 GMT

It´s the standard Netweaver (2004 or 2004s/6.40 or 7.00) documentation.

Check with System - Status - Components in any 6.40 or 7.00 system, the component SAP_BW is integrated. You can even execute RSA1 on those systems.

Markus

Re: OLAP /OLTP query

Former Member — Tue, 18 Sep 2007 14:29:02 GMT

Hello All,

Thanks a lot for adding your thoughts.

So now R3 system is OLTP system .Correct?

Now R3 system is upgraded to ECC 6.0 ( it has sap_bw soft. component )

So now ECC 6.0 is OLTP or OLAP system?Thanks

Regards,

Tushar

Re: OLAP /OLTP query

Former Member — Tue, 18 Sep 2007 14:39:52 GMT

If you have an R/3 system (OLTP) and you are upgrading it and you are using it as you used to, it is still an OLTP. As Marcus and Eric said, the other scenario (activate BW functionality) is technically possible, but it doesn't make sense as the settings for the database are very different between BW and R/3

In short, the answer is that the new system is OLTP

Regards

Andreas

Message was edited by:

Andreas Malandrinos