[go: up one dir, main page]
Scribd
Upload
71 views7 pages

Optimization: Administration Performance

This document provides an overview of SAP BW administration and performance optimization. It covers topics such as initial system setup, data modeling, authorization management, performance tuning, and administration best practices. The document is technical in nature and intended for SAP BW administrators.

Uploaded by

Mani Kandan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
71 views7 pages

Optimization: Administration Performance

This document provides an overview of SAP BW administration and performance optimization. It covers topics such as initial system setup, data modeling, authorization management, performance tuning, and administration best practices. The document is technical in nature and intended for SAP BW administrators.

Uploaded by

Mani Kandan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 7

Joe Darlak and

Jesper Christensen

SAP BW: Administration and

Performance

Optimization

Galileo Press
Bonn

Boston

Contents

Foreword

13

Preface

15

PART I

1.1

1.2

1.3

1.4

Initial

System Setup

2.2

23

1.1.1

SAP NetWeaver 7.40

1.1.2

SAP BW

28

1.1.3

SAP BW Data Model

30

1.1.4

Bl Content

35

1.1.5

New

Components

37

Versions, New Features

42

System Landscape
1.2.1

Promote to Production

44

1.2.2

Source

44

Strategy
System Interface

46

1.2.3

Post-Copy

1.2.4

Change Management

51

1.2.5

Transport Organizer

58

Automation

78

System Sizing
1.3.1

SAP Benchmarks

82

1.3.2

Quick

86

1.3.3

Productive

1.3.4

BWA

Sizer

90

Sizing

95

Sizing

98

System Settings
1.4.1

2.1

22

Infrastructure Architecture

99

Profile Parameters

1.4.2

Implementation Guide

101

1.4.3

Bl Basis

103

1.4.4

Global

Customizing

Settings

and

Exchange

Rates

106

110

Data Flow in SAP BW

Diagram

110

Components

111

2.1.1

The Data Flow

2.1.2

Data Flow

2.1.3

New Features

Layer

Architectures of

for SAP BW 7.40


a

Data Warehouse

115
117

Contents

Layered Scalable Architecture


2.2.2
Layered Scalable Architecture with SAP
Graphical Modeling
2.3.1
Data Flow Templates
2.3.2
SAP-Delivered Data Flow Templates

117

2.2.1

2.3

2.4

3.1

3.2

128
135

2.4.2

Process Variants in Detail

140

Master Data

158

3.1.1

Master Data

Design

159

3.1.2

Master Data

Loading

3.1.3

Master Data Maintenance

170
176
184

Transaction Data

Partitioning
Repartitioning

184

3.2.2
3.2.3

InfoProvider Maintenance

191

3.2.4

Aggregates

194

3.2.5

BW Accelerator

195

InfoProvider

Temporary

187

196

Data

3.3.1

SAP BW

3.3.2

Archiving Request

3.3.3

Statistics and Technical Content

3.5

Near-Line

4.1

Authorization

201

Archiving Objects
Administration Data

202

204
205

Strategy

212

Storage

Concept

in AS ABAP

217

4.1.1

Authorization Fields

220

4.1.2

Activity Fields

220

Standard Authorization
4.2.1

Developer

221

Objects

and Administrator Authorizations

4.2.2

Reporting Authorizations

Analysis

Authorizations

4.3.1

Creating
InfoObject
Defining Analysis Authorizations
Automatically Generating Analysis Authorization

4.3.2
4.3.3

127

Process Chains

Data Retention

4.3

125

2.4.1

3.4

4.2

123

134

Data Load Automation

3.2.1

3.3

HANA

an

222
224
225

for

Analysis

Authorizations

225
228
229

Contents

4.4

4.5

Roles
Administrator Roles

232

4.4.2

End-User Roles

232

4.4.3

Role

233

4.5.2

4.5.3

PART II

5.1

6.1

236

Defining
Assigning Analysis Authorizations
Users

User Administration Tools

238
241
242

4.6.1

Standard Authorization Errors

242

4.6.2

SAP BW

Performance

Data

Analysis

Authorization Errors

246

Tuning

Modeling

for Performance

253

5.1.1

Enhanced Data

5.1.2

Semantic

5.1.3

InfoCube

5.1.4

DSO

Modeling

279

5.1.5

Virtual InfoProviders

291

Data

Modeling with

SAP BW 7.40

257
262

Partitioning
Modeling

267

314

HybridProvider
Loading for Performance

317

5.2.1

Extraction

5.2.2

Transfer Processing

332

5.2.3

Load

346

5.2.4

ABAP Guidelines

Identifying

317

Processing

Processing

352

Performance Problems
SAP

357

BW-Specific Tools

6.1.1

Using

6.1.2

Using Workload Monitors


Performance Testing

6.1.3

Analyzing Query-Specific
Reporting Performance Tuning
6.1.4

6.2

236
to Users

Troubleshooting Authorization Problems

5.1.6
5.2

Templates

User Administration
4.5.1

4.6

231

4.4.1

368
384

Performance Issues

6.2.1

Database

6.2.2

Query Optimization
Frontend Tool Optimization

6.2.3

357

Optimizations

385
405
405
411
414

Contents

PART III

7.1

Administration Tasks in Your SAP BW

Daily

430

7.1.3

Checking

BWA

437

7.1.4

Performing System

7.1.5

Automating Daily Tasks

Daily

Checks

439
445

Tasks

Monitoring
Monitoring SAP BW

446

CCMS Alerts

446

Process Chains

Monitoring

448

and RDA Daemons

449

7.2.4

Monitoring InfoPackages
Monitoring DSO Activations

7.2.5

Checking Aggregates

451

7.2.3

Weekly

451

Administration Tasks

8.1.1

Reviewing

Rebuilding

8.1.3

Cleaning

8.1.5

8.1.6
8.1.7

Weekly

455

EarlyWatch

SAP

8.1.2

8.1.4

Alert

456

BWA Indexes

461

464

PSA and Change Logs


Cleaning Application Logs

Executing
Executing

BW

Executing

RSRV

Housekeeping

Other

Performance

Housekeeping
Consistency

467

Task List
Tasks

Checks

469
470
472

473

Tuning

8.2.1

Monitoring

Bl Statistics

474

8.2.2

Compressing InfoCubes

477

8.2.3
8.2.4

Monthly

DB Indexes and Statistics

Rebuilding
Monitoring

Cache

Administration Tasks

482

Scheduling System

9.1.2

Changing Portal Settings


Checking SAP Notes
Taking Action on the EarlyWatch

9.1.4
9.1.5
9.1.6
9.1.7

Executing

RSRV
BWA

Restart

Cleanup

477
478

Usage

9.1.1

9.1.3

10

Storage

Data Load

7.2.2

9.1

426

Workload

7.2.1

8.2

Database

Checking
Checking

7.1.2

8.1

425

Administration Tasks

7.1.1

7.2

System

Tasks

Collecting
Usage
Forecasting Storage Capacity

482
489
490
Alert

493
493
495
497

Contents

9.2

10.1

Monthly Performance Tuning


9.2.1

Conducting

9.2.2
9.2.3

File

499

System Housekeeping

Archiving/Near-Lining

503

Monitoring Data Load

Statistics

505

Quarterly Administration Tasks

509

10.1.1

Managing

510

10.1.2

Testing System Refresh

10.1.3
10.1.4

Users and Licenses

Maintaining
Updating

515

Hardware

523

SAP Kernels

524

10.1.5

10.2

Applying Database Updates and Parameters


10.1.6
Patching Operating System
10.1.7 Validating System Parameters
10.1.8
Reviewing Open Transport Requests
Quarterly Performance Tuning Tasks

525

10.2.1

531

10.2.2

10.2.3
10.2.4

11.1

11.1.3

12.1

Reorganizing
Deleting Obsolete Queries

and

Reports

Deleting Obsolete Data Flows


Reviewing Configuration Settings

Applying

SAP BW

Support

528
528
530
530

532
536
536

548
548

Packs

553

Performing SAPgui Maintenance


High Availability and Disaster Recovery

558

11.1.4

Testing

11.1.5

Assessing System Risks

564

Yearly

Performance

Tuning

Tasks

Data Flow

11.2.1

Reviewing

11.2.2

Reviewing External Performance and Optimization

11.2.3

PART IV

the Database

Yearly Administration Tasks


11.1.1
Upgrading SAP BW
11.1.2

11.2

500

Data

Re-Partitioning

InfoProviders

563

564
564
565
566

Support for Your Bl Initiatives

Centralized Support Organization

577

12.1.1

BICC Governance

579

12.1.2

Project Delivery

581

11

Contents

12.1.3
12.2

12.3

12.4

Service

585

Business Roles

586

12.2.2

IT Roles

589

Team Structure

596

12.3.1

BICC Governance

596

12.3.2

Project Delivery

597

12.3.3

Service

598

Delivery

Best Practices

599

12.4.1

Vision and

12.4.2

Governance

601

12.4.3

Guidelines

602

12.4.4

Compliance

603

Strategy

Checklists
A.1

Development

A.2

Housekeeping

Transaction Codes

Reports

The Authors

Index

584

12.2.1

12

Delivery

Roles and Skill Sets

and Utilities

599

607
Checklists
Checklists

607
614

619
629
639

641

You might also like