SAP BW: A Step-by-Step Guide: A Step-by-Step Guide
Product Author Bios
Biao Fu is a partner with Fuguji LLC, an IT consulting firm specialized in ERP, data warehousing, business intelligence, and supply chain management. Prior to Fuguji LLC, he was a principal consultant with PricewaterhouseCoopers (PwC). At PwC Global Training Center, he was a solutions architect, as well as the lead instructor of SAP BW Technical Infrastructure (BWTI) class, where he was granted the Award of Excellence for his contributions to BWTI and other BW classes. He is an SAP Certified Technical Consultant and SAP Certified BW Consultant.
Henry Fu is a partner with Fuguji LLC, an IT consulting firm specialized in ERP, data warehousing, business intelligence, and supply chain management. He is an Oracle Certified Database Administrator and Oracle Certified Application Developer. He has been involved in the development and implementation of several large-scale data warehousing projects. He is a licensed professional engineer (Ontario, Canada), and has two M.S. degrees majoring in management science and engineering.
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:
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.
24 of 25 people found the following review helpful
Hottest SAP Book in Town !!!,
This review is from: SAP BW: A Step-by-Step Guide: A Step-by-Step Guide (Paperback)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... Read more
11 of 13 people found the following review helpful
What SAP BW version ???,
By A Customer
This review is from: SAP BW: A Step-by-Step Guide: A Step-by-Step Guide (Paperback)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)...
5 of 5 people found the following review helpful
Best overview of BW hands-on tasks,
This review is from: SAP BW: A Step-by-Step Guide: A Step-by-Step Guide (Paperback)With this book, you can seat down in front of the terminal and begin using BW right away.
On the other hand, you better have some experience building Data Warehouses prior to using BW. There might be 2 or 3 ways to build a business solution and this book is not necessarily a good source for "best practices" or architecture concepts. A good book that could complement this one is "Mastering the SAP Business Information Warehouse".
› See all 18 customer reviews...
Online Sample Chapter
Table of Contents
(NOTE: Each chapter concludes with a Summary.)
I. GUIDED TOURS.
II. ADVANCED TOPICS.
This book is a how-to guide. It uses step-by-step procedures with screen captures to illustrate SAP BW functionalities. This book focuses on the core SAP BW technology. It discusses other SAP technologies, such as Basis, ABAP (Advanced Business Application Programming), and ALE (Application Link Enabling) when necessary. It will not discuss 3rd-party reporting tools and BAPI (Business Application Programming Interface).
This book is written for BW implementation teams and those who need a product to understand data warehousing concept.
BW is built on Basis 3-tier architecture and coded in ABAP language. ALE and BAPI are used to link BW with SAP systems (R/3 or BW) and non-SAP systems.
This book, however, does not require readers have knowledge in these areas. BW has made the development of a data warehouse so easy that people with experience in database design and computer programming can use it.
As shown in the table of contents, this book is organized into two parts:
Part I contains guided tours. We start from a simplified business scenario, then go on to illustrates how to create an InfoCube, load data into the InfoCube, check accuracy of the loaded data, create queries to generate reports, and finally how to manage user authorization.
Part II contains advanced topics. There we discuss InfoCube design techniques, aggregates, multi-cubes, operational data store (ODS), Business Content, generic R/3 data extraction, data maintenance, performance tuning, and object transport.
In the appendices, we introduce ASAP (AcceleratedSAP) for BW, one of the derivatives of the ASAP implementation methodology developed by SAP, and give an overview of Basis 3-tier architecture.
Downloadable Sample Chapter
Click below for Sample Chapter(s) related to this title:
Click below to download the Index file related to this title:
This book includes free shipping!
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.