SAP NetWeaver Business Warehouse: Administration and Monitoring

... 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