Mastering the SAP Business Information Warehouse: Leveraging the Business Intelligence Capabilities of SAP NetWeaver / Edition 2

Paperback (Print)
Rent from
(Save 67%)
Est. Return Date: 07/24/2015
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 96%)
Other sellers (Paperback)
  • All (18) from $1.99   
  • New (8) from $40.46   
  • Used (10) from $1.99   


"This book is the definitive guide for SAP NetWeaver BI professionals. Based on their extraordinary expertise with the product, the authors provide deep insights about key innovations in the areas of user experience, query performance, integrated planning, and enterprise-wide data warehousing."
—Stefan Sigg, Vice President, SAP NetWeaver Business Intelligence

The long-anticipated publication of this second edition reflects the growing success of SAP NetWeaver as well as the various Business Intelligence (BI) capabilities that are embedded with SAP BW version 7.0. Written by SAP insiders, this comprehensive guide takes into account the ever-changing features, functionality, and toolsets of SAP NetWeaver to bring you the most updated information on how to use SAP BW to design, build, deploy, populate, access, analyze, present, and administer data. You'll discover the options that are available in SAP NetWeaver and uncover a new means to improve business performance.

This book reflects the process an organization goes through during an implementation of the software. The authors begin with an introduction to BI and SAP NetWeaver and quickly progress to information modeling and enterprise data warehouse concepts. You'll learn how to access and deliver meaningful analytic information to the organization, as well as perform integrated planning functions. Finally, the authors share invaluable insight on warehouse administration, performance, and security.

With more than 50 percent new or revised material, this second edition of Mastering the SAP Business Information Warehouse shows you how to:

  • Extract data from online transaction processing systems
  • Store transformed data in a way that best supports reporting and analysis
  • Use the various Business Explorer tools such as BEx Report Designer, BEx Analyzer, BEx Broadcaster, and BEx Web Application Designer
  • Schedule, monitor, troubleshoot, and archive data loads

The companion Web site contains sample chapters in Wiki format and the authors' blog where readers may enter discussions about the book and SAP.

Wiley Technology Publishing Timely. Practical. Reliable.

Visit our Web site at

Visit the companion Web site at

The companion Web site contains the sample code presented in the text of the book, plus implementation templates.

Read More Show Less

Product Details

  • ISBN-13: 9780764596377
  • Publisher: Wiley
  • Publication date: 8/28/2006
  • Edition description: REV
  • Edition number: 2
  • Pages: 720
  • Sales rank: 1,272,965
  • Product dimensions: 9.25 (w) x 7.50 (h) x 1.47 (d)

Meet the Author

Kevin McDonald is a consultant and entrepreneur. Hecofounded and was the CEO of COMPENDIT, Inc., a consulting servicesfirm acquired by Inforte Corp. in 2004. He was an Ernst and YoungEntrepreneur of the Year regional finalist and was recognized byEntrepreneur magazine for having created a “Hot100” fastest-growing new business. He has instructed,implemented, and designed enterprise decisionprocessing systems fordozens of clients. Prior to co-founding COMPENDIT, Kevin was theDirector of New Dimension Technology and a corporate spokespersonfor SAP, where he had worked in both America and Germany. He wasprogram manager during the successful market launch of SAP BusinessInformation Warehouse (SAP BW), and he authored the SAP BW productmap that was first used to define the scope and developmentdirection for the software.
Kevin started his career at Baxter Healthcare, where he heldpositions in both IT and finance functions. He has authorednumerous articles about SAP’s Business Intelligence Solutionfor The Data Warehouse Institute’s newsletter, and he hasmade presentations on business intelligence at DCI’s DataWarehouse World, HP World, ERP World, TDWI conferences, ASUG, SAPTechEd, SAP Sapphire, Decision Processing 98 and 99, andInformatica World. Kevin is an advisor to the Cognos InnovationCenter and may be contacted at

Andreas Wilmsmeier is a managing director of InforteDeutschland. Andreas has been a member of the initial SAP BW coredevelopment team, where he has been responsible for designing andimplementing parts of the Staging Engine (for example, the StagingBAPI). Andreas has been consulting SAP BW clients since the initialcustomer shipment of SAP BW 1.2A in early 1998 and has continued tocontribute to the development of SAP BW by providing feedback fromthe field and to the development of business content for thefinancial services and defense industries.
After receiving his diploma in computer science and businesseconomics, Andreas started his career in developing data warehouseand Internet solutions. Prior to working for Inforte, Andreas ranthe German subsidiary of COMPENDIT until its acquisition by Infortein early 2004.
His knowledge of data warehousing, data mining, and knowledgemanagement has been showcased at numerous internationalconferences, including SAP Sapphire, SAP TechEd, ASUG, Cebit inHanover, Germany, and Systems in Munich, Germany. Andreas hasauthored articles in the SAP Technical Journal, (nowfeatured on and the German-language E/3Magazine. Andreas may be contacted

David Dixon is a vice president with Inforte’s SAPPractice, where he is responsible for ensuring the quality ofInforte solutions and project deliveries. A recognized authority inbusiness intelligence, he has extensive full-lifecycle projectexperience in architecting and implementing complicated globalsolutions for Fortune 100 companies. David has also worked with theSAP SEM and SAP BI development teams on numerous occasions insupport of the latest products.
Prior to joining Inforte, David worked for COMPENDIT, a consultingfirm acquired by Inforte in March 2004, where he was a foundingteam member. Prior to joining COMPENDIT, he was a PlatinumConsultant with SAP. David started his career as a Financials andControlling (FI/CO) consultant with SAP in 1995, specializing inall of the SAP reporting and analysis applications and tools. Anaccomplished speaker, he has presented at industry-leading SAP andBI events, including SAP TechEd, ASUG, and TDWI. He may becontacted at

Bill Inmon is thought of as the “father of the datawarehouse” and is co-creator of the “corporateinformation factory.” He has more than 28 years of experiencein database technology management and data warehouse design. He isknown globally for his seminars on developing data warehouses andhas been a keynote speaker for every major computing associationand many industry conferences, seminars, and trade shows. Bill haswritten about a variety of topics on building, usage, andmaintenance of the data warehouse and the corporate informationfactory. More than 500 of his articles have been published in majorcomputer journals such as Datamation, ComputerWorld,and Byte magazine. Bill is currently a columnist withData Management Review and has been since its inception. Hehas published 39 books.
Bill founded and took public a Silicon Valley company, PrismSolutions, in 1991. Prism Solutions became Ardent Software, whichwas acquired by Informix, renamed Ascential Software, and acquiredby IBM. The software he created is still used by hundreds ofcompanies today. More recently, Bill decided to publish his vastdata warehousing information resources on his Web site The Web site has now grown to support millionsof visitors a month. Bill consults with a large number of Fortune1000 clients, offering data warehouse design and databasemanagement services.

Read More Show Less

Table of Contents

About the Authors.




Chapter 1 The Origins of Business Intelligence.

Evolution of Information Processing.

Data-Storage Advancements.

Transaction Processing Dominates.

Extract Files Appear.

The Data Warehouse Is Conceived.

What Is Data Warehousing?

The Data Model.

Different Physical Tables.

Integration and Transformation Processing.


Granular Data.

Historical Data.


Data Relationships.

Generic Data versus Specific Data.

Data Quality.

Volumes of Data.

Removing Dormant Data.

Architected Solutions.

Corporate Information Factory.

Government Information Factory.

Evolution of SAP.

Evolution of SAP Reporting and Analysis.

SAP BW and the New Dimension Applications.

The Road to Business Process Integration.


Chapter 2 The SAP NetWeaver Integration Platform.

The Architectural Roots of SAP NetWeaver.

NetWeaver Overview.

Application Platform (Technology).

Application Server Architecture.

Front-End Technologies.

Mobile Infrastructure.

System Landscape.



Process Integration.

Integration Builder.

Integration Repository.

Integration Directory.

Integration Server.

Runtime Monitor.

Information Integration.

Business Intelligence.

Master Data Management.

Knowledge Management.

People Integration.

Portal Framework.

Composite Application Framework.


Chapter 3 SAP Business Information WarehouseArchitecture.

SAP BW Architectural Components.

Metadata and Document Management.

Metadata Management.

Document Management.

Elementary Metadata Objects.

Obsolete Metadata Objects.

Design, Monitoring, and Administration.




Data Acquisition and Transformation.

Most Important Metadata Objects.

Staging Engine.

DataSource Manager.

Data Storage.

Master Data Manager.

Data Store Object Manager.

InfoCube Manager.

Aggregate Manager.

BI Accelerator.

Information Lifecycle Manager.

Data Access and Analysis.

InfoProvider Interface.


OLAP Cache.

Analytic Engine.

Analysis Process Designer.

Information Distribution.

Information Distribution Interfaces.



Presentation Metadata Objects.

BEx Analyzer and BEx Web Analyzer.

BEx Query Designer.

BEx Report Designer.

BEx Web Application Designer.

BI Patterns.

Visual Composer.


Analytic Engine.

Planning Functions.

Planning Sequences.


Chapter 4 Information Modeling.

Information Modeling Prerequisites.

Understanding the SAP BW Metadata Model.

Master-Data Data Model.

The InfoCube Data Model.

The DataStore Object Data Model.

Developing an Information Model.

Multidimensional Modeling.

Additional Information Modeling Options.


Chapter 5 Enterprise Data Warehousing.

Business Intelligence Strategy.


Layers of an EDW Architecture.


System Landscapes.

Data Integration.

Master Data Integration.

Transaction Data Integration.

Data Quality.

Modeling the Layers of an EDW.

Modeling the Data Staging Layer.

Modeling the Operational Data Store.

Modeling the Data Warehouse Layer.

InfoMart Layer.

Modeling Support for Data Integration.

Modeling with Global Keys.

Modeling with Qualified Local Keys.

Concatenation Versus Compounding.

Mapping Approaches.

Modeling Support for Data Historization.

Tracking History of Transactional Data.

Tracking History of Master Data.






Project Marketing.


Chapter 6 Data Acquisition and Transformation.

Data Acquisition.

Classes of Data.

Data Flow and Integration.

Dimensions of Data Acquisition.

OLTP Technology Considerations.


Metadata Flow.

Data and Control Flow.

Example of an Application-Specific Extractor.

Client-Specific Data Extraction Options.


Data and Control Flow.


Data and Control Flow.

Data and Control Flow.


Data and Control Flow.

Ascential DataStage.


Data and Control Flow.


Data Integration Transformations.

Application Logic Transformations.

Reference Objects for Transformations.

Architecture and Data Flow.

Persistency Considerations.

Multilevel Staging Considerations.

Conversion Routines.


Rule Types.

Transformation Routines.


Master Data Texts.

Master Data Hierarchies.


Chapter 7 Data Access, Analysis, and InformationDistribution.

Data Access.

Query Processing Overview.

InfoProvider Interface.

DataStore Objects and PSA APIs.

Information Analysis.

Knowledge-Discovery Process.

Analytic Services.

Information Distribution.


Interface Options for Third-Party Presentation Tools.

The Business Explorer API.


Chapter 8 Information Presentation.

BEx Presentation Components.

BEx Query Designer.

BEx Analyzer.

BEx Web.

Generic Presentation Options.


Print Versions — PDF Output.

Local Calculations.

Other Presentation Options.

Crystal Reports Integration.

BEx Mobile Intelligence.

Portal Integration.

Visual Composer.


Chapter 9 Integrated Planning.

Integrated Planning Positioning.

History and Trends.

Definition of Planning.

Architecture Considerations.

Integrated Planning Technology.



Planning Modeler.

Integrated Planning Data.

Information Logistics.

Information Modeling.

Data Access and Locking.

Semantic Rules.

Planning Functions.

Controlling Function Behavior.

Function Types.

Basic Functions.

Advanced Functions.

Integrated Planning User Interface.

Runtime Capabilities.

Design-Time Capabilities.

Integrated Planning Process Control.

Status and Tracking.

BW-BPS Coexistence.

Best and Worst Practices.

Delta Change Modeling.

Enterprise Design.


Chapter 10 Business Analytics.

Analytic Application Architecture.

What Is Business Content?

Business Content Progression.

Horizontal Growth.

Vertical Growth.

Using Business Content.




Customer Relationship Analytics.

Analytic Engines.

Customer Behavior Analysis.

Supply Chain Analytics.

SCOR Model.

Supply-Chain Cockpit.

Demand Planning (DP).

Network Design and Production Planning.

Financial Analytics.

Corporate Performance Management.

Enterprise Planning.

Financial Consolidation.



Chapter 11 Administration.

Application-Oriented Administration.

Process Chains.

Data Management Processes.

Application Management Processes.



System-Oriented Administration.

Information Lifecycle Management.





Chapter 12 Performance Planning and Management.

Performance Planning.

Managing User Expectations.

Information Modeling.

Process Design.

System Landscape Design and Setup.

Performance Management.

BI Statistics.

Optimizing Query Performance.

Data Loading and Data Management.

Information Lifecycle Management.

System Performance.


Appendix A Acronyms.


Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)