Open all
Close all
Part I: Initial System Setup
19
1 Configuring Your System Environment
21
1.1 Infrastructure Architecture
22
1.1.1 SAP NetWeaver 7.40 Components
23
1.1.3 SAP BW Data Model
30
1.1.5 New Versions, New Features
37
1.2.1 Promote to Production Strategy
44
1.2.2 Source System Interface
44
1.2.3 Post-Copy Automation
46
1.2.4 Change Management
51
1.2.5 Transport Organizer
58
1.3.3 Productive Sizing
90
1.4.1 Profile Parameters
99
1.4.2 Implementation Guide
101
1.4.3 BI Basis Customizing
103
1.4.4 Global Settings and Exchange Rates
106
2 Data Architecture and Loading
109
2.1 Data Flow in SAP BW
110
2.1.1 The Data Flow Diagram
110
2.1.2 Data Flow Components
111
2.1.3 New Features for SAP BW 7.40
115
2.2 Layer Architectures of a Data Warehouse
117
2.2.1 Layered Scalable Architecture
117
2.2.2 Layered Scalable Architecture with SAP HANA
123
2.3 Graphical Modeling
125
2.3.1 Data Flow Templates
127
2.3.2 SAP-Delivered Data Flow Templates
128
2.4 Data Load Automation
134
2.4.2 Process Variants in Detail
140
3.1.1 Master Data Design
159
3.1.2 Master Data Loading
170
3.1.3 Master Data Maintenance
176
3.2.1 InfoProvider Partitioning
184
3.2.3 InfoProvider Maintenance
191
3.3.1 SAP BW Archiving Objects
201
3.3.2 Archiving Request Administration Data
202
3.3.3 Statistics and Technical Content
204
3.4 Data Retention Strategy
205
3.5 Near-Line Storage
212
4 Roles and Authorizations
217
4.1 Authorization Concept in AS ABAP
217
4.1.1 Authorization Fields
220
4.1.2 Activity Fields
220
4.2 Standard Authorization Objects
221
4.2.1 Developer and Administrator Authorizations
222
4.2.2 Reporting Authorizations
224
4.3 Analysis Authorizations
225
4.3.1 Creating an InfoObject for Analysis Authorizations
225
4.3.2 Defining Analysis Authorizations
228
4.3.3 Automatically Generating Analysis Authorization
229
4.4.1 Administrator Roles
232
4.5 User Administration
236
4.5.2 Assigning Analysis Authorizations to Users
238
4.5.3 User Administration Tools
241
4.6 Troubleshooting Authorization Problems
242
4.6.1 Standard Authorization Errors
242
4.6.2 SAP BW Analysis Authorization Errors
246
Part II: Performance Tuning
251
5 Data Modeling and Loading for Performance
253
5.1 Data Modeling for Performance
253
5.1.1 Enhanced Data Modeling with SAP BW 7.40
257
5.1.2 Semantic Partitioning
262
5.1.3 InfoCube Modeling
267
5.1.5 Virtual InfoProviders
291
5.2 Data Loading for Performance
317
5.2.1 Extraction Processing
317
5.2.2 Transfer Processing
332
5.2.3 Load Processing
346
5.2.4 ABAP Guidelines
352
6 Reporting Performance Tuning
357
6.1 Identifying Performance Problems
357
6.1.1 Using SAP BW-Specific Tools
357
6.1.2 Using Workload Monitors
368
6.1.3 Performance Testing
384
6.1.4 Analyzing Query-Specific Performance Issues
385
6.2 Reporting Performance Tuning
405
6.2.1 Database Optimizations
405
6.2.2 Query Optimization
411
6.2.3 Frontend Tool Optimization
414
Part III: Administration Tasks in Your SAP BW System
423
7.1 Daily Administration Tasks
425
7.1.1 Checking Database Storage
426
7.1.2 Checking Workload
430
7.1.4 Performing System Checks
439
7.1.5 Automating Daily Tasks
445
7.2 Daily Data Load Monitoring Tasks
446
7.2.1 Monitoring SAP BW CCMS Alerts
446
7.2.2 Monitoring Process Chains
448
7.2.3 Monitoring InfoPackages and RDA Daemons
449
7.2.4 Monitoring DSO Activations
451
7.2.5 Checking Aggregates
451
8.1 Weekly Administration Tasks
455
8.1.1 Reviewing SAP EarlyWatch Alert
456
8.1.2 Rebuilding BWA Indexes
461
8.1.3 Cleaning PSA and Change Logs
464
8.1.4 Cleaning Application Logs
467
8.1.5 Executing BW Housekeeping Task List
469
8.1.6 Executing Other Housekeeping Tasks
470
8.1.7 Executing RSRV Consistency Checks
472
8.2 Weekly Performance Tuning
473
8.2.1 Monitoring BI Statistics
474
8.2.2 Compressing InfoCubes
477
8.2.3 Rebuilding DB Indexes and Statistics
477
8.2.4 Monitoring Cache Usage
478
9.1 Monthly Administration Tasks
482
9.1.1 Scheduling System Restart
482
9.1.2 Changing Portal Settings
489
9.1.3 Checking SAP Notes
490
9.1.4 Taking Action on the EarlyWatch Alert
493
9.1.5 Executing RSRV Cleanup Tasks
493
9.1.6 Collecting BWA Usage
495
9.1.7 Forecasting Storage Capacity
497
9.2 Monthly Performance Tuning
499
9.2.1 Conducting File System Housekeeping
500
9.2.2 Archiving/Near-Lining Data
503
9.2.3 Monitoring Data Load Statistics
505
10.1 Quarterly Administration Tasks
509
10.1.1 Managing Users and Licenses
510
10.1.2 Testing System Refresh
515
10.1.3 Maintaining Hardware
523
10.1.4 Updating SAP Kernels
524
10.1.5 Applying Database Updates and Parameters
525
10.1.6 Patching Operating System
528
10.1.7 Validating System Parameters
528
10.1.8 Reviewing Open Transport Requests
530
10.2 Quarterly Performance Tuning Tasks
530
10.2.1 Reorganizing the Database
531
10.2.2 Deleting Obsolete Queries and Reports
532
10.2.3 Deleting Obsolete Data Flows
536
10.2.4 Reviewing Configuration Settings
536
11.1 Yearly Administration Tasks
548
11.1.1 Upgrading SAP BW
548
11.1.2 Applying SAP BW Support Packs
553
11.1.3 Performing SAPgui Maintenance
558
11.1.4 Testing High Availability and Disaster Recovery
563
11.1.5 Assessing System Risks
564
11.2 Yearly Performance Tuning Tasks
564
11.2.1 Reviewing Data Flow
564
11.2.2 Reviewing External Performance and Optimization
565
11.2.3 Re-Partitioning InfoProviders
566
Part IV: Support for Your BI Initiatives
573
12 BI Competency Center
575
12.1 Centralized Support Organization
577
12.1.1 BICC Governance
579
12.1.2 Project Delivery
581
12.1.3 Service Delivery
584
12.2 Roles and Skill Sets
585
12.2.1 Business Roles
586
12.3.1 BICC Governance
596
12.3.2 Project Delivery
597
12.3.3 Service Delivery
598
12.4.1 Vision and Strategy
599
A.1 Development Checklists
607
A.2 Housekeeping Checklists
614
C Reports and Utilities
629