Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need help to decide on SAP BI / BW / BO

Hi All SAP consutants,

I would like to switch to SAP BI, however I have the below questions

1) What is SAP BI, what do consultants work on, what technologies they use ?

2) I would like to know what are the pre requisites knowledge (like ABAP/Java or any Datawarehousing knowledge etc) to do SAP BI ?

3) Which kind of people are suitable to do SAP BI ?

4) What are the prospects of SAP BI when compare to SAP ABAP and EP, heard that SAP BI is going to be obselete and now only SAP BO (biz objects) will be used in future ?

Highly appreciate your response.

Thanks

Edited by: zayed Khan on Jun 26, 2011 10:38 PM

Edited by: zayed Khan on Jun 26, 2011 10:40 PM

Former Member
Former Member replied

1) What is SAP BI, what do consultants work on, what technologies they use ?

SAP stands for System Applications and product in Data processing.

BI/BW  stands for Business Intelligence or Business Intelligence warehouse or Business warehouse. It is an readymade software for Data warehousing or in simple language it is an Data storehouse.

The most Important word for a BI consultant from above is Data .  Data of business, most important Data on which different important decisions of a Company depents on. 

Mostly in BI there is Historic Data or Old data. But some times you have to work also with realtime Data.

Actually we as an BI consultant extract or perform Data aquisition from another system, which is known as R/3 System or any other company realtime systems.

I dont want to go much in detail in R/3 systems.

OVERVIEW

In real time data is stored in R/3 system (in day to day business life cycle) for eg : Assuming that you are a dealer of Audi cars in USA ,If you have orderd some 100 Audi cars Q7 from Audi plant in Germany.  then they will take some Personal details from you and they will process your request, as soon as they accept your request this information wil be pass to different sections of business, for eg: to Material management, sales and distributions etc.This all information regarding a business with you is stored in third layer which is known as Database layer of  R/3 System. Now Because R/3 system is very very sensitive system because it records all transactions online that is  OLTP  Online Transaction Process , now if we want to have some report from the Database then we go into the R/3 sys and make reports from that Data and it will slowdown the performance of R/3 system.

Because of this problem SAP had offered or made BI/BW  OLAP online Application Process System so that you can bring the extracted copy or extract exact Data in another system called as BI/BW and then do what ever you want, i mean you can create reports or use data for different calculations etc.

What SAP BI/BW do is , Preparing (Modelling) ready to your BI/BW system for aqusition (Extraction) of Data from another system and creating Reports (Reporting) on it as it is needed by a Manager.So Job of an BI/BW consultant is

1 Modelling

2 Extraction

3 Reporting

You just have to no, how fast and accurate you can play with the BI/BW software. Because it offers wide space .

2) I would like to know what are the pre requisites knowledge (like ABAP/Java or any Datawarehousing knowledge etc) to do SAP BI ?

Yes if you have the knowledge of only ABAP for BI  (no need to have full knowledge of ABAP) or knowledge of JAVA to some extend then it is better. If you dont have the knowledge of any of this languages also, then also you can become an BI consultant. You should have the qualities of understanding the business that all.

If you are doning also BO Business Objects then it would be better if you have the knowledge of SQL.

SO Littel knowledge of JAVA, SQL, ABAP is better.

3) Which kind of people are suitable to do SAP BI ?

If You are a person who understands logic related to software and Logic releted to business. And understand exactly what someone needs from you from your job then BI/BW is right place.

4) What are the prospects of SAP BI when compare to SAP ABAP and EP, heard that SAP BI is going to be obselete and now only SAP BO (biz objects) will be used in future ?

ABAP is a programming language that is used in some parts of BI When it is neede, for eg To perform multiple Querysat one time or calling different data from different sources.

BI is a platform that is needed for Data management or Datawarehousing and making that Data ready for Reporting . BI also performs reporting activities but to some extend.

BO is a Platform where only reporting is possible but with multiple options and with best of reports that is not awailable in BI

So they are and cannot perfome all activities alone whether it is BI, BO, ABAP.

Take care

Mir Ahmed.

4 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question