This book provides you with highly detailed information on all of the most important BI features of the new SAP NetWeaver 2004s Release. Readers gain a profound understanding of SAP BI and quickly learn how to master the new release, while avoiding costly errors.

Familiar subjects like data modeling, ETL, web reporting, and planning are combined with expert insights on essential new BI functions and core concepts, making this reference an invaluable companion for your daily work. The authors provide exclusive details on advanced developments in BEx Analyzer and BEx Web Application Designer, as well as the BEx Report Designer, BI-integrated planning, the BI Accelerator and the SAP Visual Composer, ensuring that your most important questions are addressed with practical guidance. Real-life examples, volumes of screen captures and detailed graphics, as well as step-by-step instruction, enable you to quickly and easily familiarize yourself with all of the new BI functions.

The book is intended for SAP consultants, team members and managers in the areas of IT, BI, and controlling.

Highlights

• Business Intelligence Concepts
• New Features of SAP NetWeaver
• 2004s
• Data Modeling in the Administrator
• Workbench
• Data Retrieval
• Performance Optimization with
• Aggregates and BI Accelerator
• Redesign Functions: Repartitioning
• and Remodeling
• BEx Query Designer
• BEx Analyzer
• BEx Web Application Designer
• Report Designer
• BI-Integrated Planning
• Visual Composer

About the Author(s)

The authors are all acknowledged BI specialists of the CubeServ Group (www.cubeserv.com). Specializing in BI solutions since 1998, the CubeServ Group has gained considerable experience in hundreds of projects implementing SAP BW, SAP SEM, and SAP NetWeaver.

Table of Contents

1. Business Intelligence Concepts - Innovations ... 27
... 1.1 The Closed-Loop Business Analytics Process ... 27
... 1.2 Implementation in Modern Data-Warehousing Systems ... 32
... 1.3 New Features in SAP NetWeaver 2004s ... 36

2. New Features of SAP NetWeaver 2004s - An Overview ... 67
... 2.1 SAP NetWeaver 2004s ... 67
... 2.2 Software Components and User Interfaces ... 68
... 2.3 Enterprise Data Warehousing: Data Modeling ... 85
... 2.4 Enterprise Data Warehousing: ETL and Administration ... 101
... 2.5 Enterprise Reporting, Query, and Analysis ... 122
... 2.6 Business Planning and Analytical Services ... 142
... 2.7 Performance Optimization ... 147
... 2.8 User Management and Analysis Authorizations ... 151
... 2.9 Conclusion ... 153

3. Data Modeling in the Data Warehousing Workbench of SAP NetWeaver 2004s BI ... 155
... 3.1 Introduction ... 155
... 3.2 Sample Scenario ... 155
... 3.3 Creating an InfoObject ... 156
... 3.4 "Sales Order Header" Data Model ... 160
... 3.5 "Sales Order Items" Data Model ... 189
... 3.6 "Sales Order Header and Item" MultiProvider ... 203

4. Data Retrieval ... 213
... 4.1 Sample Scenario ... 213
... 4.2 DataSources ... 213
... 4.3 Emulating the 3.x Data Retrieval Process in SAP NetWeaver 2004s ... 217
... 4.4 Data Retrieval Processes in SAP NetWeaver 2004s ... 230

5. Performance Optimization with Aggregates and BI Accelerator ... 263
... 5.1 Introduction ... 263
... 5.2 Reporting without Performance Optimization Measures ... 264
... 5.3 Performance Optimization Using Aggregates ... 270
... 5.4 Performance Optimization Using BI Accelerator ... 279
... 5.5 Comparison and Evaluation of Performance Optimization Tools ... 294

6. Redesign Functions: Repartitioning and Remodeling ... 297
... 6.1 Redesign Requirements in SAP BW Applications ... 297
... 6.2 Repartitioning InfoProviders ... 297
... 6.3 Remodeling InfoProviders ... 308
... 6.4 The First Redesign Functions: An Interim Result ... 323

7. BEx Query Designer ... 325
... 7.1 Reporting and Analysis - An Overview ... 325
... 7.2 BEx Query Designer in Detail ... 327

8. Business Explorer Analyzer ... 365
... 8.1 Introduction ... 365
... 8.2 Running a Query in BEx Analyzer ... 366
... 8.3 The Design Mode in BEx Analyzer ... 374

9. BEx Web Application Designer ... 387
... 9.1 Getting Started ... 387
... 9.2 Simple Web Reporting ... 389
... 9.3 Complex Web Reporting ... 405
... 9.4 Structure of Web Templates ... 418
... 9.5 Portal Integration ... 419
... 9.6 Migrating 3.x Web Templates ... 419
... 9.7 BEx Broadcaster ... 421

10. Report Designer ... 425
... 10.1 Introduction ... 425
... 10.2 Enterprise Reporting - Sample Application ... 426
... 10.3 Installing and Executing BEx Report Designer ... 428
... 10.4 Formatting in BEx Report Designer ... 435

11. BI-Integrated Planning ... 451
... 11.1 Introduction ... 451
... 11.2 Sample Scenario ... 454
... 11.3 The Planning Environment ... 458
... 11.4 Planning Functions ... 480
... 11.5 Manual Planning ... 507
... 11.6 Planning on the Web ... 514
... 11.7 Planning in Microsoft Excel ... 525
... 11.8 Conclusion ... 534

12. SAP NetWeaver Visual Composer ... 535
... 12.1 Sample Scenario ... 535
... 12.2 Basis Components ... 536
... 12.3 Creating a Model in Visual Composer ... 540
... 12.4 The "Accounts Receivables by Customer" Overview ... 544
... 12.5 Development of the Payment History of a Selected Customer ... 569
... 12.6 The Customer Data Sheet ... 581
... 12.7 Changing Customer Credit Management Data in the OLTP System ... 586
... 12.8 Creating a Header Field ... 615
... 12.9 Integrating the Composite Application in the SAP Enterprise Portal ... 620
... 12.10 Running the Application ... 622
... 12.11 An Interim Result ... 627

Appendix ... 629
... A Abbreviations ... 631
... B New Terminology ... 633
... C Transaction Codes ... 635
... D Literature ... 641
... E Authors ... 643

Index ... 647