Learn the ins and outs of SAP Business Information Warehouse (BW), and gain the knowledge to leverage the full potential of this key technology. Whether it's in terms of project management, data modeling or reporting, you'll benefit from volumes of basic and advanced information. All content is presented in an easy-tofollow format, illustrated by proven examples, sample solutions and clear graphics and screen shots.
In addition, gain exclusive insights into possible error sources, and the optimization of workloads, functions and processes. This highly versatile book is designed for BW teams, SAP consultants, as well as for IT staff members and executives who rely on BW as their data warehouse.
Highlights include:
Detailed introduction to SAP BW: InfoObjects, InfoProvider, InfoCubes, Star Scheme, DataSources, InfoSources, Web Items, and a lot more
SAP BW sample application: rules for transferal and extrapolation, InfoPackages, BEx Query, data collection, and Query-request
Data modeling: Implementation of a column-oriented Infosource in an account-oriented InfoCube; Illustration of the SAP product hierarchy in data modeling, data collection, and reporting
Functions of the Query Designers
Functions of the SAP BW Web Application Designers
Expandable SAP BW WebCockpit
Reihe
Sprache
Verlagsort
Zielgruppe
Editions-Typ
Maße
Höhe: 24 cm
Breite: 16.8 cm
ISBN-13
978-1-59229-017-8 (9781592290178)
Schweitzer Klassifikation
Autor*in
Norbert Egger is the Managing Director of the CubeServ Group, which specializes in BI solutions. In 1996, he established the world's first data warehouse based on SAP. Since then, he has implemented hundreds of projects with SAP BW and SAP SEM. He has many years of experience in the operation of SAP-based BI solutions.
Foreword 13
Preface 15
Part 1 Conceptual Overview 17
1 Successful Strategic Information Management 19
... 1.1 Foundations of Management Decision-Making 19
. 1.2 Changed Demands on Information Management 20
. 1.3 Conceptual Foundations 26
. 1.4 Required Enhancements 29
. 1.5 Translating Strategy into Action - The Balanced Scorecard Method of Management 33
. 1.6 Successful Implementation and Operation of Business Intelligence Solutions 37
Part 2 Introduction to SAP BW 39
2 SAP Business Information Warehouse-Overview 41
. 2.1 Architecture of SAP BW 41
. 2.2 Storing Data in SAP BW 42
. 2.3 Data Retrieval 49
. 2.4 Reporting and Analysis Tools 54
. 2.5 Additional Functions and Components 65
. 2.6 SAP Business Content 66
. 2.7 The Position of SAP Business Information Warehouse 68
3 Step-by-Step: Profitability Analysis with SAP BW 71
. 3.1 Introduction 71
. 3.2 Data Modeling 72
. 3.3 Setting Up the Retrieval of Master Data 91
. 3.4 Retrieving Actual Data from SAP R/3 CO-PA 107
. 3.5 Uploading Plan Data from a File 123
. 3.6 Creating an SAP Business Explorer Query 129
. 3.7 Executing the Query 134
Part 3 Data Modeling and Data Retrieval 141
4 Data Modeling and Conversion from a Column-Oriented InfoSource to an Account-Oriented InfoCube 143
. 4.1 The Account-Oriented Data Model Versus the Column-Oriented Data Model 143
. 4.2 Practical Example: Combination of the Account-Oriented and the Column-Oriented Data Model 148
. 4.3 Implementation: InfoCubes 151
. 4.4 Implementation: Data Retrieval 155
. 4.5 Executing Data Retrieval 160
. 4.6 Performance Optimization and Reporting 162
5 Appropriate Mapping of the SAP Product Hierarchy in Data Modeling, Data Retrieval, and Reporting 167
. 5.1 The Material Attribute "Product Hierarchy" in SAP R/3 167
. 5.2 Storing the Material Attribute "Product Hierarchy" in SAP BW Using the SAP Business Content Navigation Attribute 169
. 5.3 Storing the Material Attribute "Product Hierarchy" in SAP BW Using the SAP Business Content Hierarchy 176
. 5.4 Solution Using a Step-Based Product Hierarchy as a Material Attribute 184
. 5.5 Advantages and Disadvantages of the Different Variants for Mapping the Product Hierarchy 200
Part 4 Reporting and Web Applications with the SAP Business Explorer 203
6 Using Sample Solutions to Show the Important Functions of the Query Designer in SAP BW 3.x 205
. 6.1 Introduction 205
. 6.2 Reusable Objects 211
. 6.3 Properties of Query Elements 224
. 6.4 Hierarchies 232
. 6.5 Conditions 238
. 6.6 Exceptions 243
. 6.7 Variables 245
. 6.8 Additional Selected Innovations in the Query Designer 262
7 Selected Functions of the SAP BW Web Application Designer in SAP BW 3.x 275
. 7.1 The Web Application Designer in the Framework of the SAP Business Explorer Components 275
. 7.2 The Functionality of the Web Application Designer: Overview 277
. 7.3 First Steps in the Web Application Designer 282
. 7.4 Web Items in the Web Application Designer 286
. 7.5 HTML Coding in the Web Application Designer 358
. 7.6 Conclusion 366
8 Sample Solution for an Extendable Web Cockpit in SAP BW 367
. 8.1 Introduction 367
. 8.2 Creating the Queries and the Query Views 367
. 8.3 Creating the Web Template with the Charts 372
. 8.4 Creating the Web Template with the Role Menu 387
. 8.5 Creating the Title Web Template 388
. 8.6 Creating the Frameset 389
. 8.7 Linking with Other Reports Using the Report/Report Interface 390
. 8.8 Navigation in the WebCockpit 392
. 8.9 The Functions of the Sample WebCockpit 393
Appendix 395
A Structure of the InfoCubes from Chapter 3 397
. A.1 InfoCube "Result calculation actual data (ZCBWTIPP1)" 397
. A.2 InfoCube "Result calculation plan data (ZCBWTIPP2)" 399
. A.3 Multiprovider "Result calculation actual and plan data (ZCBWTIPP3)" 400
B Structure of the InfoCubes from Chapter 4 403
. B.1 InfoCube "Result calculation invoice data (ZCBWTIPP5)" 403
. B.2 InfoCube "Result calculation data proj./job accounting (ZCBWTIPP6)" 404
. B.3 InfoCube "Result calculation overhead costs (ZCBWTIPP7)" 406
. B.4 MultiProvider "Result calculation for all transaction types (ZCBWTIPP8)" 407
C Bibliography 409
D The Author 411
Index 413
