SAP(R) BW: A Step-by-Step Guide (Paperback)

~ Biao Fu (Author), (Author)

Editorial Reviews

Product Description

Practitioner's guide uses step by step instructions complete with a plethora of screen captures to illustrate key SAP BW functionalities. Softcover.

From the Back Cover

SAP BW has recently come to the fore as a valuable tool for developing data warehouses that accurately and effectively support critical business decision making. It facilitates easy-to-use and high-performance extraction, transfer, transformation, and loading of data from a variety of data sources, including such comprehensive business management systems as SAP R/3.

This practitioner's guide uses step-by-step instructions complete with a plethora of screen captures to illustrate key SAP BW functionalities. It demonstrates how SAP BW implements the fundamental star schema and solves the major challenges inherent in the creation of data warehouses: performance, reliability, and error-handling. Using a real-world business scenario as a running example, SAP® BW presents a comprehensive view of the technology, from underlying concepts and basic techniques through its most sophisticated capabilities.

Specific topics covered include:

Creating an InfoCube and loading the data

Checking the accuracy of data with BW Monitor and the Persistent Staging Area (PSA)

Creating queries to generate reports using Business Explorer (BEx)

Managing user authorization with the Profile Generator

Advanced InfoCube design techniques

Aggregates and multicubes

Working with the Operational Data Store (ODS)

Installing business content and creating an R/3 source system in BW

Loading data from SAP R/3 into SAP BW

Data maintenance

Performance tuning, including parallel query option and data packet sizing

Object transport

Although the focus is on the core SAP BW technology, this book also discusses other relevant technologies, including Basis, ABAP (Advanced Business Application Programming), ALE (Application Link Enabling), and ASAP (Accelerated SAP) for BW.

With the clear explanations and practical techniques presented in SAP® BW information systems professionals will gain both the general understanding and specific skills necessary to create high quality data warehouses that support effective decision making.

0201703661B07092002

See all Editorial Reviews

Product Details

• Paperback: 480 pages
• Publisher: Addison-Wesley Professional (August 2, 2002)
• Language: English
• ISBN-10: 0201703661
• ISBN-13: 978-0201703665
• Product Dimensions: 9.2 x 7.3 x 0.9 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 2.4 out of 5 stars  See all reviews (16 customer reviews)
• Amazon.com Sales Rank: #531,073 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #36 in	Books > Computers & Internet > Networking > Data in the Enterprise > SAP R3
  #98 in	Books > Computers & Internet > Databases > Distributed Databases

Customer Reviews

Most Helpful Customer Reviews

23 of 24 people found the following review helpful:

4.0 out of 5 stars Hottest SAP Book in Town !!!, August 29, 2002

By	Shankar G.B. (CHENNAI, Tamil Nadu India) - See all my reviews

I am a SAP Consultant for FICO for the last few years and I have experience in Data Warehousing projects. Now I have entered into the world of SAP-BIW, with my past experience in DW. I am involved currently in a SAP-BIW project.

SAP- BIW has a Back End called 'Administrator Work Bench', which is all about Data Modelling, Data Targets which leads Info cubes, Info source and Data source. The back end process is all about gathering data from the data sources and put them in BIW thru R/3. The Front End is called 'Business Explorer' and this helps in viewing the data gathered for decision processing.

Critical points about the Book: The Book deals only in Back End processes and it does not teach about Front End, except querying (chapter 5). To know about Front End extensivley, one has to read "SAP BW Reporting Made Easy, 2.0B/2.1C" by SAP Labs Inc. Simplification Group.

Further even in Back End, it is not giving any info abt data modelling or data designing. It merely teaches how to transfer the data from Data source to BIW thru R/3. Regret that, it is not covering complicated transfers. This book is in-complete in many aspects. In other words, the book teaches the core functions required from BIW Consultant for handling the Back end processes.

Positive points: Authors deserve appreciation for having written a book needed in the crucial time, since SAP- BIW is getting implemented in many places. The book is concise and clear in whatever topics they deal with.

I should also say that this book can be useful from beginners to intermediate level. Beginners mean, those who have prior experince in SAP or in Data Warehousing but new to SAP- BIW.

Thanks for reading.

9 of 10 people found the following review helpful:

2.0 out of 5 stars What SAP BW version ???, October 13, 2003

By A Customer

Nowhere in the book, nor on Amazon detailed info nor in the "view pages inside" is mentioned that the book treats BW 2.0 and IS NOT GOOD for BW 3.1 or later.

I had to read all the buyers reviews and to find out about the BW version, only after I had the book ordered and sent to me. So Because I use 3.2 I have sent back this book. It's not up-to-date, there seems not to be a reprint for BW 3.0

So it was not useful to me. I am very disappointed.

The book can show you some tasks to do in BW 2.0 but it learns you nothing if you have other cubes to make in different SAP applications.

Also, it does not mention the transaction names behind the screens printed. Pitty, since this could have helped us when working in BW 3.0 (screens and menus can change but often the TX's remain the same)...

7 of 8 people found the following review helpful:

2.0 out of 5 stars Seriously out of date, January 21, 2004

By A Customer

The book is ok. Its not great. You can get something out of it ...

Two main issues:
(1) If you are going to use this book with any BW versions 3.x, you are going to have trouble. This is so because (1.1) some of the screenshots are out of date, and (1.2) there are somethings that 2.x did and used that are not done and used anymore - for example the CS Unit of Measure is no longer used. If you dont know that, you will become old sitting in front of your screen trying to figure out why something is not working.

(2) The books fails to omit some major steps. For example, in going from Ch.4 to Ch. 5 - Queries, you need to load some other data. At no point is this mentioned. I mean its quite obvious that more data needs to be entered, otherwise, Ch. 5 aint going to work - but thats just the problem - its too obvious. Sometimes - when we have been behind the screen for too many hours, we fail to see things precisely because they are TOO obvious. So ... you can wind up spending too much time futzing around trying to figure out why something is not working.