Saturday, August 4, 2007

BW Go live Optimization report

SAP AG always recommend to performing the SAP Going-Live Checks for your production system. Depending on the phase of your project, these checks, offered by SAP, analyze the hardware sizing, check the configuration of the server and components, find performance bottlenecks, and verify the capacity of CPU and memory. The results of the checks are issued in a report (approximately 50 pages) provided by SAP.

EP Going-Live Check Analysis Session (GA) - The GA session checks whether the available hardware is sufficient for the planned workload. Recommendations for the component settings are made.

EP Going-Live Check Optimization Session (GO) - The GO session simulates workload on the system and identifies performance bottlenecks and potential risks.

EP Going-Live Check Verification Session (GV) - The GV session checks the behavior of the production system after going live and provides appropriate recommendations.

What does such a GO session report contains in case of BW system is depicted below. The purpose of the session is to analyze most important InfoCubes and Queries, and to assess any potential problems in system. SAP takes few InfoCubes and Queries and makes this session based on them. Report may have following structure:

  1. BI Overview checks
    1. BI Administration and design

1. Data distribution

2. Analysis of InfoProviders

3. Analysis of aggregates

4. Recommendations for BI

5. BI Statistics

    1. BI Reporting and planning

1. BI Runtime Statistics

2. Analysis of Query Definition

3. Analysis of OLAP Cache

4. Frontend Servers

    1. BI warehouse management

1. Upload Statistics

2. Process Chains - Runtime Overview

3. Source System Settings

  1. BI application checks
    1. Optimization of InfoProvider

1. InfoCube 1

2. InfoCube N

    1. Analysis of reporting and planning performance

1. Report 1

2. Report N

  1. Upload checks for
    1. Configuration for BI uploads

1. Important SAP Notes for data upload

    1. Process chains

1. Chain: 1

2. Chain: N

For more information check out

No comments: