
SAP NetWeaver Business Warehouse: Administration and Monitoring
SAP PRESS
1st Edition
Published on 25. January 2010
Book
Hardback
600 pages
978-1-59229-330-8 (ISBN)
Description
This book offers a complete understanding of all administration tasks that arise in a live SAP NetWeaver BW system and provides guidance on ways to solve any problems that might occur. Coverage includes all topics relevant to administration and monitoring of SAP NetWeaver BW, including basic principles, tasks, analysis, and troubleshooting.
1. Basic Principles
Understand the basic principles and technology components necessary for administering and
monitoring SAP NetWeaver BW.
2. Platform
Learn about SAP NetWeaver AS ABAP and SAP NetWeaver AS Java, which have long proven
themselves as high-performance platforms for ABAP-based and J2EE-based applications and represent a complete infrastructure for SAP NetWeaver BW.
3. Database Management
Explore the fundamentals of SAP NetWeaver BW database management, with a special emphasis
on indices, which are of high signifi cance both for data loading processes and for reporting.
4. System Connections and Access
Master a basic knowledge of the technologies around system connections, including IDocs,
which ensure the required quality for administration and monitoring of loading processes.
5. Monitoring and Analysis Tools
Benefit from an overview of the monitoring and analysis tools that are most important for a BW
administrator.
Highlights:
Indices
DB Storage Parameters for BW Objects
Buffering of InfoObject Tables
Web Services, SOAP, etc.
DataStore Object
InfoCubes
Authorizations in SAP NetWeaver BW
Role Maintenance in Transaction PFCG
Nearline Storage (NLS)
Java Support Packages
More details
Series
Language
English
Place of publication
Bonn
Germany
Target group
Professional and scholarly
Edition type
New edition
Dimensions
Height: 22.9 cm
Width: 17.5 cm
Thickness: 35 mm
ISBN-13
978-1-59229-330-8 (9781592293308)
Schweitzer Classification
Persons
Author
Milco Österholm is an SAP BI solution architect and cofuonder of the Swedish consulting company E1NS (www.eins.se). As a project leader, he has managed large SAP implementation projects for many years. Currently, alongside his work in BI architecture teams, he manages the operation of SAP NetWeaver BW for various clients. Milco Österholm has been active in technical consulting and project management in the BI area of SAP for several years, He also has many years of experience of FI-CO and SD development.
Olaf Klostermann is an SAP BI solution architect at K-42 eG (www.k-42.com), where he is a cofounder and board member. His consulting specializations are technical issues in SAP NetWeaver BW, particularly architecture and performance. He has many years of international project experience in the design and implementation of SAP NetWeaver BW, including several years at SAP in Germany. Previously, he worked for a long period as a developer and technical consultant for database systems and BI solutions.
Content
... Preface ... 19
PART I ... Basic Principles ... 23
1 ... SAP Implementation Concept ... 25
... 1.1 ... IT Practices and Scenarios ... 25
... 1.2 ... Usage Types ... 30
2 ... Overview of AS ABAP and AS Java ... 31
... 2.1 ... SAP NetWeaver Application Server ABAP ... 31
... 2.2 ... SAP NetWeaver Application Server Java ... 33
... 2.3 ... Cooperation of Both Platforms ... 34
... 2.4 ... SAP NetWeaver Portal ... 37
... 2.5 ... Basis Parameters ... 41
... 2.6 ... RSADMIN Parameters ... 50
... 2.7 ... Lock Management ... 67
... 2.8 ... Number Range Buffer ... 70
3 ... Database Management ... 75
... 3.1 ... Indexes ... 75
... 3.2 ... Database Memory Parameters for BW Objects ... 90
... 3.3 ... Buffering InfoObject Tables ... 92
... 3.4 ... DBA Cockpit ... 93
... 3.5 ... Provider-Specific Information ... 96
... 3.6 ... Backup and Recovery Strategies ... 100
4 ... System Connections and Access ... 103
... 4.1 ... SAP NetWeaver BW Source Systems ... 103
... 4.2 ... IDoc, ALE, RFC, and Similar Technology ... 107
... 4.3 ... Web Services, SOAP, and Similar Technology ... 116
... 4.4 ... BAPI, MDX, and Similar Technology ... 118
5 ... Monitoring and Analysis Tools ... 123
... 5.1 ... General Tools (SAP Basis) ... 125
... 5.2 ... Special SAP NetWeaver BW System Tools ... 154
6 ... Basic Principles of Processes and Objects ... 185
... 6.1 ... DataStore Object ... 185
... 6.2 ... InfoCubes ... 188
... 6.3 ... Aggregates ... 189
... 6.4 ... SAP NetWeaver BW Accelerator ... 190
... 6.5 ... Open Hub Destinations and InfoSpokes ... 194
... 6.6 ... Reporting ... 196
PART II ... SAP NetWeaver BW Administration ... 205
7 ... User Administration and Authorization Management ... 207
... 7.1 ... Basic Principles ... 207
... 7.2 ... Basic Principles of Authorizations in the SAP NetWeaver BW System ... 219
... 7.3 ... Role Maintenance in Transaction PFCG ... 220
... 7.4 ... Analysis Authorizations ... 226
8 ... Archiving and Data Maintenance ... 249
... 8.1 ... Archiving Concepts ... 249
... 8.2 ... Data Archiving Process ... 252
... 8.3 ... Archive Development Kit ... 255
... 8.4 ... Nearline Storage ... 266
... 8.5 ... Archiving Request Management Data ... 270
... 8.6 ... Archiving PSA Data ... 272
... 8.7 ... Scheduling Archiving Using Process Chains ... 273
... 8.8 ... Decision-Making Support for Archiving Concept ... 275
... 8.9 ... Partitioning and Clustering ... 276
... 8.10 ... Master Data Cleansing ... 288
9 ... Maintenance ... 291
... 9.1 ... Support Package Stacks, Support Packages, and Patches ... 292
... 9.2 ... ABAP Support Packages ... 294
... 9.3 ... Java Support Packages ... 300
... 9.4 ... Transport System ... 303
... 9.5 ... Maintenance Optimizer ... 326
... 9.6 ... SAP NetWeaver BW Accelerator Revisions ... 329
... 9.7 ... System Copies ... 329
10 ... Technical Content and BI Administration Cockpit ... 333
... 10.1 ... Updating Statistics Data ... 334
... 10.2 ... Installing the Technical Content ... 335
... 10.3 ... Runtimes of Queries ... 340
... 10.4 ... Data Load Status ... 345
... 10.5 ... Data Load Statistics ... 348
... 10.6 ... Evaluation of CPH Data ... 354
... 10.7 ... Workload Monitor (Transaction ST03) ... 356
... 10.8 ... Loading and Deleting Statistics Data ... 357
... 10.9 ... Enhancements ... 358
11 ... Process Chains ... 361
... 11.1 ... Processes Relevant for the Operation ... 362
... 11.2 ... Administration of Process Chains ... 368
... 11.3 ... Jobs in Process Chains ... 375
12 ... Administration of SAP NetWeaver BW Processes in Detail ... 377
... 12.1 ... Extraction and Load Processes ... 377
... 12.2 ... Change Run ... 404
... 12.3 ... Administration of InfoCubes ... 412
... 12.4 ... Performance Settings for InfoCubes ... 420
... 12.5 ... Compressing InfoCubes ... 422
... 12.6 ... Further Processing of Data in a DSO ... 426
... 12.7 ... Deleting Data from a DSO ... 433
... 12.8 ... Monitoring Analysis Processes ... 438
13 ... Reporting Monitoring and Administration ... 443
... 13.1 ... Administration of the BEx Analyzer ... 443
... 13.2 ... Query Administration ... 448
... 13.3 ... Internet Communication Frameworks Administration ... 455
... 13.4 ... OLAP Caching ... 460
... 13.5 ... Aggregates ... 465
... 13.6 ... SAP NetWeaver BW Accelerator ... 482
... 13.7 ... Information Broadcasting ... 506
... 13.8 ... Results in Reporting ... 509
... 13.9 ... Integrating SAP NetWeaver BW Contents into SAP NetWeaver Portal ... 515
... 13.10 ... Analysis and Monitoring in the Portal ... 517
... 13.11 ... Communication Problems with BEx Web Java ... 520
... 13.12 ... Performance of Web Applications ... 525
PART III ... Management and Support ... 529
14 ... SAP Support ... 531
... 14.1 ... Tools for the Support ... 531
... 14.2 ... SAP Solution Manager ... 533
... 14.3 ... SAP Active Global Support ... 534
... 14.4 ... SAP Service Marketplace ... 538
... 14.5 ... Service Connections ... 541
... 14.6 ... Customer Messages ... 547
... 14.7 ... Additional Functions in the SAP Service Marketplace ... 555
... 14.8 ... BI Diagnostics & Support Desktop Tool ... 559
... 14.9 ... SAP EarlyWatch Alert and other Solutions ... 561
15 ... Organizing SAP NetWeaver BW Administration Teams ... 565
... 15.1 ... Teams and Responsibilities ... 565
... 15.2 ... Best Practices (ITIL) ... 566
... 15.3 ... Operating Documentation ... 569
... 15.4 ... Regular Tasks ... 571
... Appendices ... 575
... A ... Transactions, Reports, and Function Modules ... 575
... B ... Glossary ... 581
... C ... Bibliography ... 589
... D ... The Authors ... 591
... Index ... 593