Skip to Content
Author's profile photo Former Member

Learning SAP BW: Everything that beginner needs to start career in SAP NetWeaver BW: Part I

We have many resources available(Blogs, wiki, documents, articles) on SCN network but I thought it will be great if we have any document which will give directions to SAP BW beginner to explore SAP BW world step by step and also clear many queries, questions, confusion on different aspects of SAP NetWeaver BW.   

While searching on internet normally we get lost to some other discussions and topics. So despite of having unlimited resources on internet, SAP BW beginners are facing many problems and asking basic questions on SCN.. and there is chance that basic question may get blocked because as per Rules of engagement person asking question needs to search on SCN because there are many resources already available. I think its correct rule which will avoid replication of material, similar discussions and make SCN better place where one can get correct answers without getting more confused. But because of this many beginners are suffering as they don’t get correct path which will guide them to learn SAP BW… I was one of them when I started learning SAP BW..

Link to one such discussion which got blocked: http://scn.sap.com/thread/3248559

I was involved in above discussion and I thought, I will try creating one such document which will help all SAP BW beginners and will try guiding them. This document is result of same.

So let’s start

SAP NetWeaver BW is huge topic to cover but I am trying to design all my blogs in such way that they will provide answers to many queries which are running in your mind as beginner.

First aspect or first question which comes to your mind as SAP BW beginner could be one of the following or related? :

Is it really worth enough to learn new technology?

Is SAP NetWeaver BW worth enough to look as a career path after few years of experience in SAP?

Is it good to switch to SAP NetWeaver BW after getting experience in SAP ABAP or some other SAP module?

I am functional consultant..can I get basic knowledge of SAP NetWeaver BW.?

I am new to SAP world (Fresher).. can I choose SAP BW for career path?

What is the market value for SAP BW?   What is the future?

And many related questions.. Am I right?

The answer is Yes,

In my opinion SAP BW is really worth enough to learn and choose as a career path..

Let me explain you few more things.

For any industry, business, company or Enterprise the most important thing is Data. It can be historical data, transnational data, master data, or data in any form or type. The main point is Data is important for any company to run business and to stay in business and no need to tell you that SAP NetWeaver BW(Business warehouse) is all about it.

Business data plays key role in shaping company overall strategy. All fortune 500 companies care a lot about their own business data 🙂 Now a days as companies are expanding their business globally, the volume of data which any company needs in day today business, for developing future strategy is increasing day by day. So in this kind of situation application, tool and technology which will take care of company data plays key role. SAP BW is the solution which many companies already decided to invest in.

As data volume is increasing day by day so to resolve related performance issue we have SAP HANA in place which is combination of hardware and software which will provide base architecture for BW.. SAP BW on HANA is reality in today’s world.

There are quite good demand in market for SAP BW skill set and in my opinion it will remain for next couple of years, till date these entire new products(like HANA) will get stabilize in market.  Anyways in any technology to stay in business you need to acquire knowledge about upcoming new technologies, new versions, updates and all which have potential to affect your current technology demand.  In case BW is also same. As there are many new technologies, products are in line which are related BW and have potential to affect BW demand like HANA, BI, BO and all. Does SAP HANA replacing BW? In my opinion The answers is no..Its altogether different topic to write complete blog 🙂

On internet there are survey available which will give you some more detail about current BW rate and pay scale.. Certainly everyone will think about this too.. J

This is all about Market demand, market condition…

Now let’s go through Pre-Requisite to Learn SAP BW.

Pre-Requisite:

  • In my opinion to learn anything the first and mandatory pre requisite is passion towards it. If you have passion you can learn this technology even if you don’t have following other skill set.. I mean you can build following skill set and still can reach to your goal if you have passion.
  • We have few task in BW for which we need ABAP knowledge. That is extraction, Routine (Field level Routine, Start and End routine in transformation step).  ABAP knowledge will be great. If you don’t have ABAP knowledge then also you can lean remaining things in SAP BW and even learn basic of ABAP. In my opinion if you have experience in ABAP then it is really good while learning any new technology in SAP because you will come to know what is happening in background and you get some more confidence.
  • Experience in Data-warehousing tools will help you understand database related concepts.
  • Functional knowledge of at least one SAP module will give you good start while exploring and understanding SAP BW and it will help you in modeling also.
  • Analysis skills if you want to understand the reporting needs of your customers or end-users in one go.. 🙂   without rework. This plays very important role as in BW because after looking at the report if end users says you need to change few things you will need to change on every level which adds time and money and energy. So to understand business requirement in one go analysis and functional knowledge will help a lot.

After pre-requisite let me explain different aspect of SAP BW:

–      SAP BW architecture:

It is important to understand basic architecture of SAP NetWeaver BW. This will help you throughout your career with SAP BW.

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

–      Extraction:

This part of BW is all about extracting needed data from different source system. Source system can be ECC system, any other ERP, Files and all. There are   different types of extractor and related knowledge will help you in extracting correct data. It involves complex logic related to delta mechanism, LO cockpit and all.. Data retrieval is one of the data warehousing processes in SAP. SAP provides mechanisms for retrieving data (master data, transaction data, metadata) from various sources. You can differentiate as to whether the SAP BW is the target or the source of the data transfer: If data from various sources is retrieved from various sources for transfer into a SAP BW system, the SAP BW system is the target of the data transfer. If the data from SAP BW is retrieved for distribution within the SAP BW or for distribution into analytical applications or other applications, the SAP BW system is the source or hub in relation to data transfer.

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

–      Modeling:

This Part of BW is very important because in this you will create data model by using different objects like info-object, infoSource, datasource, DSO, Cube, Multi-provider, etc… DTP and transformation also comes into the picture. It required good knowledge about all these objects because every object has its own advantage and different process of working. If you know all of them you will be able to build robust data model. Writing routine is also part of modeling. Routines can be field level, start or end routine. Along with this you will need knowledge about of PSA, all modeling objects, DTP, transformation. Process chains,

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/1251421705be30e10000000a155106/frameset.htm

Reporting:

This part of BW deals with actual reporting skills where you actually build queries using BEx or BI, BO and use it to display reports for end users.

SAP BW uses BEx tool (Business explore) for reporting purpose. The Business Explorer is the SAP Business Information Warehouse component that provides flexible reporting and analysis tools for strategic analyses and decision-making support within a company. These tools include query, reporting, and analysis functions. You can use BEx Information Broadcasting to distribute Business Intelligence content from SAP BW by e-mail either as precalculated documents with past data, or as links with live data. You can also publish it to the Enterprise Portal.

The Business Explorer gives a large spectrum of users access to the information in SAP BW: Using the Enterprise Portal, using the Intranet (Web Application Design) or using mobile devices (WAP or iMode-enabled mobile telephones, Personal Digital Assistants). Now a days BI and BO is also in market which many companies are considering for advance anlysis and many new advance fetures:

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

Some more good links

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/304444f7-e02d-2d10-9c97-d5e3ecf09882?QuickLink=index&overridelayout=true

https://help.sap.com/saphelp_nw73ehp1/helpdata/en/b2/e50138fede083de10000009b38f8cf/frameset.htm

http://help.sap.com/nw73bwhana

Good books for SAP BW:

A Practical Guide to SAP NetWeaver Business Warehouse 7.0

By Bharat Patel, Amol Palekar, and Shreekant Shiralkar

http://www.sap-press.com/products/A-Practical-Guide-to-SAP-NetWeaver-Business-Warehouse-7.0.html

Data Modeling in SAP NetWeaver BW

by Frank K. Wolf, Stefan Yamada

http://www.sap-press.com/products/Data-Modeling-in-SAP-NetWeaver-BW.html

SAP Certified Application Associate — Business Intelligence with SAP NetWeaver 7.

By Lisette Bellissimo

http://www.sap-press.com/products/SAP-Certified-Application-Associate-%E2%80%94-Business-Intelligence-with-SAP-NetWeaver-7.0.html

Inside SAP BusinessObjects Advanced Analysis

by Ingo Hilgefort

http://www.sap-press.com/products/Inside-SAP-BusinessObjects-Advanced-Analysis.html

SAP BW: A Step by Step Guide for BW 2.0 (Paperback)

by Biao Fu, Henry Fu http://www.amazon.com/gp/product/0201703661/ref=pd_sim_b_3/102-7679650-5957713?%5Fencoding=UTF8&v=glance&n=283155

SAP BW Data Modeling

by Norbert Egger, Jean-Marie Fiechter, and Jens Rohlf

http://www.sappress.com/product.cfm?account=&product=H989

Data Modeling in SAP NetWeaver BW

By Frank K. Wolf, Stefan Yamada

You can use following SAP Press link to look for latest books on BW.

http://www.sap-press.com/categories/SAP-NetWeaver-BI%7B47%7DBW/

http://www.sap-press.com/

That’s it for this blog. I am planning to write some more blogs/wiki which will guide SAP BW beginner a better way.. Stay tuned for Part II and much more..:)

Please feel free to add your comments.

happy learning 🙂

Thanks,

Bhupesh

Assigned tags

      65 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Vishal Deshmukh
      Vishal Deshmukh

      Good One Bhupesh. Really impressive stuff...

      Keep it up..

      Thanks,

      Vishal

      Author's profile photo Former Member
      Former Member

      Hi Vishal,

      Thanks a lot !!

      Thanks,

      Bhupesh

      Author's profile photo Marco Verzieri
      Marco Verzieri

      Thats a good start into BW and good overview for other beginners.

      Thanks,

      Marco

      Author's profile photo Former Member
      Former Member

      Hi Marco,

      Thank you very much.. 🙂

      Thanks,

      Bhupesh

      Author's profile photo Ethan Jewett
      Ethan Jewett

      Bhupesh,

      This is great stuff. Exactly what we need more of in this community. Thanks for stepping up and starting to create an introduction to the material available for those learning BW.

      Cheers,

      Ethan

      Author's profile photo Former Member
      Former Member

      Thanks Ethan,

      Thanks,

      Bhupesh

      Author's profile photo Vikas Singh
      Vikas Singh

      Thanks for writing it. It's also really helpful for people who may have experience in other SAP areas and wanted to have a quick start guide .

      Really appreciate your efforts in writing this .

      Cheers

      Vikas

      Author's profile photo Raj Kumar Salla
      Raj Kumar Salla

      Hi Bhupesh,

      Good job. Can you please include the latest version of BW.

      Here is the link.

      Regards

      Raj

      Author's profile photo Former Member
      Former Member

      Thanks Bhupesh, It is really good overview for beginners.

      Regards,

      Rakesh

      Author's profile photo Former Member
      Former Member

      This is a great outline! 

      I gave this link to some recent college grads on my team and told them to review all this material and come back to me with questions.

      Thanks for taking the time to put all this together!

      Regards,

      Mike

      Author's profile photo Former Member
      Former Member

      Thanks Mike !!

      Hope this blog will help them.. 🙂

      Thanks again !!

      Thanks,

      Bhupesh

      Author's profile photo Harish Allachervu
      Harish Allachervu

      Hi Bhupesh,

      thumbs up..... 😛 it is really informative and helpful for the beginners who will start the career in SAP BW/BI.

      Regards,

      Harish

      Author's profile photo Former Member
      Former Member

      Thanks Harish!!

      Thanks,

      Bhupesh

      Author's profile photo Former Member
      Former Member

      Hi Bupesh,

      It was really informative and allt he links u gave was perfect. Thanks a lot.

      Thanks,

      Randeep M K

      Author's profile photo Former Member
      Former Member

      Thanks a lot Bhupesh for such a brief overview. For a fresher like me it was really encouraging going through this article.

      Regards,

      Pratik

      Author's profile photo Former Member
      Former Member

      Thanks Pratik. Hope this article provides you good start.

      Thanks,

      Bhupesh

      Author's profile photo Former Member
      Former Member

      Thank you so much..Bhupesh..its worth reading for a fresher like me.

      Keep up the good job!

      Regards,

      Ravi

      Author's profile photo Former Member
      Former Member

      Mind blowing Bhupesh! You have not only articulated the facts but the base level is easy for everyone to grasp the content and get an overall idea about BI. This tool is indeed a very complex and wonders can be done playing with this tool.

      Author's profile photo Former Member
      Former Member

      Thanks Subhadip. and yes you are right about your opnion about this tool.

      Thanks,

      Bhupesh

      Author's profile photo Rishabh S
      Rishabh S

      very helpful document.

      Thanks for sharing.

      Author's profile photo Former Member
      Former Member

      Good effort in making the Document and very helpful.

      Thanks a Million.

      RUK

      Author's profile photo Former Member
      Former Member

      Hi Bhupesh

      I felt very bad after reading your blog because I wasted more than two weeks in searching the same data what you have presented here....but better late than never I got all stuff at the same place .....I will definatly forward this link to my juniors who are facing the same problem as I faced some days back.

      Really much appreciated blog.Keep it up

      Kind Regards

      Kuldeep

      Author's profile photo CH Raman
      CH Raman

      Might be. But if you search with right terms on Google you may get the right docs. no problem you got. read and sharpens your skills.

      All the best Kuldeep.

      Author's profile photo Former Member
      Former Member

      Thanks Ramanjaneyulu for your concern .I got required docs earlier but it took lot of time for me and it was not assembeled under one doc.

      Author's profile photo CH Raman
      CH Raman

      Yes, but now days everything possible on SCN. just keep loggin to SCN and check at related forums.you will get more useful information.

      Author's profile photo Former Member
      Former Member

      Thanks Kuldeep.

      Thanks,

      Bhupesh

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Excellent write up Bhupesh. I think newbies to BW should bookmark this document. You ehave kept it simple and explained evrything in lay-man terms, but the data modeling part is a bit is a little vague for learners I think.

      Regards,

      Benedict

      Author's profile photo Former Member
      Former Member

      Thank alot !! yes and agree on your opinion on data modeling part but I thought I will just give brief overview and how much it is important and how complex it is. and how the process start from requirement gathering and by using it build model. But you are right for learner it will be too much at one go.. I am also planning to write separate blog only for modeling. let’s see.. Thanks again.

      Thanks,

      Bhupesh

      Author's profile photo Former Member
      Former Member

      Good stuff

      Author's profile photo Former Member
      Former Member

      i want to know if software tester can also do a SAP course and if they can then which  SAP course they can do

      Author's profile photo abilash n
      abilash n

      Very well collection placed at single blog. Thanks for sharing. I am sharing this to all my friends.

      Please add below link for DTP.(i am not owner of that blog but just sharing it as you have collected all)

      http://scn.sap.com/people/community.user/blog/2007/06/22/sap-netweaver-70-bi-data-transfer-process-dtp-blog-series

      Author's profile photo Former Member
      Former Member

      Thanks a lot, it's really a great helpful document.

      Author's profile photo Former Member
      Former Member

      Gud one... thanks a lot for sharing.

      Author's profile photo Javed Chowdhary
      Javed Chowdhary

      Good Stuff,really Helpful.

      Regards,

      Javed

      Author's profile photo Former Member
      Former Member

      Thanks 🙂

      Thanks,

      Bhupesh

      Author's profile photo Former Member
      Former Member

      Hi Bhupesg ,

      good stuff thanks ..do you have sap BI abap related links or documents

      Regards,

      Niikithi

      Author's profile photo Vikrant Mohite
      Vikrant Mohite

      Hello Niiikitha,

      This may be useful.

      SAPexperts | What Every BW/BI Developer Needs to Know About ABAP in BW

      Thanks,

      Vikrant

      Author's profile photo Former Member
      Former Member

      Nice blog post

      Author's profile photo Former Member
      Former Member

      Good one.

      Author's profile photo Former Member
      Former Member

      This is really great , I was really looking for this kind of consolidated blog .Thanks for sharing .

      Author's profile photo Yogesh Narwani
      Yogesh Narwani

      Nice Blog.. It is great help for beginners and certification aspirants..!

      Regards

      YN

      Author's profile photo Former Member
      Former Member

      Thanks. It helps me a lot to begin.

      Author's profile photo Former Member
      Former Member

      Hello Bhupesh,

      Really very very Thank you for writing this blog its very help full to go in  "Right Direction" ..

      Thanks a lot once again.

      Please write more for us...

      Thank you.

      Thanks & regards,

      Santhosh.

      Author's profile photo Veera Venkata S Kondapi
      Veera Venkata S Kondapi

      Very informative and resourceful. Thanks Bhupesh!

      Author's profile photo Former Member
      Former Member

      Thanks.

      Author's profile photo Former Member
      Former Member

      Very helpful

      Author's profile photo Former Member
      Former Member

      thanks.

      Author's profile photo Former Member
      Former Member

      Really useful resources.. Keep posting 🙂

      Author's profile photo Former Member
      Former Member

      Simply Superb, have no words to say anything......

      Just fantastic......

      Thanks

      Mohan Kona

      Author's profile photo Former Member
      Former Member

      Very helpful

      Author's profile photo Former Member
      Former Member

      Superd!

      i just started my carrer in sap Netweaver 1 month back after completing training in ABAP and i  really need help on the same to inspire me abt my carrer path in this..

      Thanks for sharing..and contine to blog on same Best Luck!!!!!

      Author's profile photo Former Member
      Former Member

      Thanks Gitesh and wish you great exciting SAP career.

      Thanks,

      Bhupesh

      Author's profile photo Balaji Vivekanandan
      Balaji Vivekanandan

      hi Bhupesh,

      Thanks for your Part I, try to spend some time for us and write Part II in more detail.
      Actually i am new to this SAP BW, from your Part I, i got an overview of the BW learning resources, but still some confusion because there are different area available in BW(Modeling ,reporting and Administration).
      here you are asking to start learn the basic concepts of ABAP, ABAP also new to me, so where i need to start from here(ABAP Basic/Programming), ABAP is the programming based rite? kindly guide me

      Regards,

      Balaji.V

      Author's profile photo Former Member
      Former Member

      Thanks Bhupesh.. Very helpful.

      Author's profile photo Giuliano Gaudino
      Giuliano Gaudino

      very good job.

      Thanks

      Author's profile photo Former Member
      Former Member

      Hi Bhupesh

      Somehow the links not opening for me. Has there been any change? Or Am I missing something

      Author's profile photo Former Member
      Former Member

      Hi Bhupesh

      Same here

      Somehow the intial few links not opening for me. Has there been any change? Or Am I missing something

      Please reply as it is making this beautiful document incomplete

      Regards

      Bharat

      Author's profile photo Former Member
      Former Member

      Hi Bupesh

      same here not able to open the links

      Regards,

      Sindu

      Author's profile photo Former Member
      Former Member

      Hi Bupesh,

      Thanks a lot giving for clarity of SAP BW system and if possible u can provide the Basics of HANA differentiated from BW.

      Regards,

      Karim

      Author's profile photo Rama Thota
      Rama Thota

      Hi Bupesh,

      Nice write-up about Data-warehousing, the links are some how not opening. Please update the links.

      Thanks

      Rk.

      Author's profile photo Former Member
      Former Member

      Hi Bupesh..

      Its very needful information SAP BI Learners.

      Regards

      Sasikanth

      Author's profile photo Giuliano Gaudino
      Giuliano Gaudino

      Hi Bupesh,

      good job. Just one thing, the link in the first part "Architecture BW...." do not work.

      Regards

      Giuliano

      Author's profile photo Former Member
      Former Member

      hi Bupesh,

      I am new to BW. It seems that some of your links are broken. Could you please fix them?

      Author's profile photo Issam Ahmad
      Issam Ahmad

      some of this link was broken, would you please provide us again with new or correct links

      thanks in advance for your support...

      Author's profile photo Vicky Upadhyay
      Vicky Upadhyay

      Hi Bhupesh,

      good one bhupesh .

      Vicky