SAP AG 1999

Initial considerations prior to installation

Sizing hardware for the BW system

Planning the BW installation

Pre-installation steps

Performing the BW installation

Post-installation steps

Ongoing support services

BW Installation

Contents:

SAP AG 1999

At the conclusion of this unit, you will be able to:

BW Installation: Unit Objectives

Explain the strategy for sizing BW hardware

Help plan a BW installation

Explain the basic BW installation procedure

Understand the tasks involved following installation

Explain the services SAP offers for ongoing support

SAP AG 1999

BW Sizing Strategy: T-Shirt Model

SAP AG 1999

Sizing for BW Front-end

Query results from different frontend processors:

refresh runtime for selected TopN workbook

0

50

100

150

200

250

1000 2000 3000 5000 7500 10000

no. of rows in query result

tim

e [s

eco

nd

s]

450 MHz, 128MB

180 MHz, 128MB

450 MHz, 64MB

180 MHz, 64MB

If enough physical memory is available and the query returns a small to medium sized result set, the refresh time will be similar even if the processor speed varies greatly from low to high.

SAP AG 1999

Planning the BW Installation

Rough estimate of BW installation time:

Pre Installation Planning 0.5 day

BW Installation 1.0 day

R/3 Plug-In Installation 0.5 day

ITS installation 0.5 day

Post Installation tasks 1.0 day

Other Project Work 0.5 day

Additional System Admin Work ?

SAP AG 1999

BW Pre-Installation: CD Selection

BW Frontend

SAP Kernel DB/OP

DB-Export

RDBMS (Oracle, MS SQL, SAPDB, DB2, etc)

BW Online Documentation

Language CD

ITS Installation CD (presentation)

PlugIn Installation CDs

SAP AG 1999

BW Pre-Installation: Required Documentation

BW Installation guide

Installation Notes

BW <version> Installation DB/OS

R/3 basis <version> Installation

DB/OS

DB <version> Installation

OS dependencies guide

R/3 Plug-In documentation

SAP notes

ITS Installation guide

(If web reporting will be implemented)

SAP AG 1999

BW Pre-Installation: Disk Configuration and Layout

Example BW Disk Configuration using RAID 1 and RAID5:

Operation System -

RAID1

DB, SAP SWAP - RAID1

Redo Logs - RAID1

Mirrored Redo Logs -

RAID1

PSAPTEMP - RAID 1

SAPDATA - RAID5

BW is a READ based system rather than an UPDATE based system.

RAID 5 generally provides better READ performance than RAID 1.

SAP AG 1999

BW Installation Sequence: Same as R/3

Install the database software

The actual database schema will be created during R3SETUP

Check database filesystem after installing DB software

Many subdirectories should exist

Install online documentation

(provided on kernel CD, along with instructions for setup)

Install R3SETUP

Run R3SETUP

Check environment variables

Creates the database <SID>

Use logs for troubleshooting

Check services, SAP filesystems

Perform post-installation tasks

SAP AG 1999

Installation Model: Components - Same as R/3

R3SetupController

R3Setup

InstGUI

CommandFileController

LogWriter

Step

SAP AG 1999

BW Installation: Control File Example - Same as R/3

Sample control section in the R3SETUP.CMD command file

SAP AG 1999

BW Installation GUI: R3SETUP - Same as R/3

A sample InstGUI screen is shown. This message indicates that R3setup is started.

SAP AG 1999

BW Installation GUI: Error Handling - Same as R/3

SAP AG 1999

BW Installation Setup Finished - Same as R/3

SAP AG 1999

Reminder: Soon after installation - Same as R/3

Perform a full filesystem backup!

Perform a full database backup!

SAP AG 1999

BW Post-installation steps: Part 1

Install BW front-end, including SAPGUI

Create a user with the right Permissions

Perform basic installation checks

Maintain operating system code page (table TCPDB)

Check language import; import additional languages

Apply latest SPAM Update

Apply all relevant Support Packages

Copy client 000 to create the BW client

Create logical system, assign to new client

SAP AG 1999

BW Post-installation steps: Part 2

Install online help

Generate objects using transaction SGEN

Initialize and check Transport Management System

Obtain and install the SAP License

Schedule database statistics collection

Maintain data transfer control parameters

Configure OSS connection

Configure System Administration Assistant

Perform basic parameter tuning

SAP AG 1999

BW Installation: Post-installation Checks

Perform initial installation check

Transactions: SICK or SM28

Address any configuration issues that may arise

Analyze system log during startup

Transaction SM21

Look for errors or warnings, address as encountered

SAP AG 1999

BW Setup : Code Page Integration - Same as R/3

SAP AG 1999

BW Setup: Language Import - Same as R/3

SAP AG 1999

Support Package Types

Types of support packages and patches relevant for BW:

SPAM updates

Basis Support Packages

Application Interface Support Packages

BW Support Packages

Add-on Support Packages - for PlugIns

Front-end Patches

Kernel Patches

SAP AG 1999

BW Post-Installation: Support Packages

Important: apply the Support Packages in the following order following installation:

1. SPAM Update

2. All available Basis Support Packages

3. All available Application Interface Support Packages

4. All available BW Support Packages

Other types of patches can be applied as part of ongoing support

SAP AG 1999

BW Post-installation: Client copy

Use the profile SAP_ALL when performing the client copy

Important: Add the parameter login/system_client = xxx to the instance or default profile

SAP AG 1999

BW Post-Installation: Logical System Assignment

1

2

SAP AG 1999

BW Post-Installation: Generate Objects

Choose First generation after an R/3 installation

Same as R/3

SAP AG 1999

BW Installation: Parameter Settings

A newly installed BW system is configured as a small system.

It is possible to edit the instance profile and database profile to tune for better performance.

Resources:

BW Sizing and Performance white paper available on SAPNet

SAP notes

Parameter check (BW RIG)

TCC review (EarlyWatch)

SAP AG 1999

BW Installation: Online help - Same as R/3

SAP AG 1999

Online Help Installation: Front-end PC Requirement

Maintain file SAPDOCCD.ini

Located in Windows directory of end-user’s front-end PC.

Maps help for each system and provides a default.

Different SAP systems in a system landscape may have specific help versions associated and installed in different locations.

Example entries for file SAPDOCCD.ini:HelpType=HtmlHelpFile[SystemId-BWB]HelpType=HtmlHelpFileHtmlHelpFilePath-EN=\\<hostname>\sapmnt\help\helpdata\EN

Same as R/3

SAP AG 1999

BW Setup: Maintain Data Transfer Parameters

Maintain entries in customizing table RSADMINC

Packet Size is in KB and determines the size of Idoc data packages of data loads from flat file data sources and data loads from BAPIs. A setting of 20000 is the standard recommendation.

FrequencyStatus-IDOC is a ratio. The setting determines the frequency that status Idocs are sent.

SAP AG 1999

BW Setup: Configure OSS Connection

Same as R/3

SAP AG 1999

BW Setup: Maintain Instance Profile - Same as R/3

SAP AG 1999

BW Post-Installation: Configure SAA - Same as R/3

1

2

3

Configure System Administration Assistant

Transaction: SSAA

Same as R/3

SAP AG 1999

BW Post-Installation: Using the SAA for Alerts

1 2

3

Choose Alert View Tab

Execute

Tasks for which alerts exist are displayed

Same as R/3

SAP AG 1999

BW Post-Installation: Using the SAA Worklist

1 2Choose Worklist Tab

3Daily, weekly, and monthly tasks can be conveniently accessed

ExecuteSame as R/3

SAP AG 1999

+1 Month

Analysis• Sizing Plausibility

Check• Configuration • BW Basis • Data Upload

Optimization• InfoCube design • Query performance• Sizing adjustments

Verification• Configuration• Query performance• Sizing verification• System usage and

bottleneck analysisRegularEarlyWatchAnalysis

Start of Production

Go Live &Support

FinalPreparation

4 5

SAP GoingLiveTM Check for BW Systems

SAP AG 1999

EarlyWatchCustomer

LiveBW System

EarlyWatchReport

Detailed analysis of the customer BW System

Bottleneck Analysis

InfoCube design

Query performance

SAP EarlyWatch® Service for BW Systems

Regular Remote Analysis

SAP AG 1999

Now you are able to:

BW Installation: Unit Summary

Explain the strategy for sizing BW hardware

Help plan a BW installation

Explain the basic BW installation procedure

Understand the tasks involved following installation

Explain the services SAP offers for ongoing support