SAP NetWeaver Business Warehouse powered by SAP HANA or BW on HANA (BoH) is around for some time already. It was introduced in 2nd quarter of 2012 and meanwhile it got a lot of attention. Basically BW is usual choice when companies are trying to evaluate HANA. It is natural that first they just migrate to HANA as database and after some time they start to implement new project using new BW objects leveraging HANA functionalities. Or starting of re-implementing current BW data models to use HANA can happen. Anyway BW is getting a lot of attention as first system to be migrated to HANA.


It may be very tricky for people who are new to HANA even start with basic evaluation of what does it mean to migrate to HANA. To support tasks like this SAP is providing a few tools. In further text I try to list the tools and provide basics information about them.

ZBW_HANA_MIGRATION_COCKPIT.png

Tools are embraced by central tool called – BW Migration Cockpit for SAP HANA. From the cockpit other tools for migrating BW systems to HANA are accessible.

Task Type

ABAP report / Tcode

Docu

Description

N/A

ZBW_HANA_MIGRATION_COCKPIT

1909597

BW Migration Cockpit

Check

ZBW_HANA_CHECKLIST

1729988

Automation  of BW checks for prerequisites for HANA migration and guidelines for operation

ZBW_HANA_CHECKLIST_3x      – version for BW 3.x

Tcode: RSRV

link

BW Objects Checks – consistency checks on the data and metadata stored in a BI system

RSPLS_PLANNING_ON_HDB_ANALYSIS

1824516

Determines whether a planning function is executed in ABAP or in HANA

Size

/SDF/HANA_BW_SIZING

1736976

Sizing Report for BW on HANA

Downsizing

Configure: NLS

Tcode: RSDANLCON

link

Customizing: Set Up Near-Line Storage Connections

Downsizing

Configure:

Data Archive Process

Tcode: RSDAP

SAPLRSDA_DAP_MAINTAIN

link

Setup of Data Archive Process in order to archive BW data in cubes and DSOs

Downsizing

Execution

Tcode: SARA

SAPMAADM

link

Execute archive processes to reduce system size – Data Archiving (ADK)

House keep – Automation

Tcode: STC01

task list:

SAP_BW_HOUSEKEEPING

1614266

1707321

Executes routine housekeeping activities; to be run on a regular basis

House keep – Tasks

Tcode: SLG2

ABAP: SBAL_DELETE

N/A

Application log deletion of expired logs

RSDDSTAT_DATA_DELETE

934848

BW statistics deletion

Tcode: SARA

N/A

IDoc archiving

RSBTCDEL

N/A

Job log deletion

Tcode: BPS_STAT0

UPC_STATISTIC3

540398

990000

Planning Statistics Deletion

Tcode: RSREQARCH

SAPLRSREQARCH

2092315

Management of archive requests

N/A

706478

List of large system tables

Migrate – Pre Migration Tasks

Tcode: /ASU/START

/ASU/ASUSTART

1000009

Tasks to be performed before starting upgrade or migration to SAP HANA

SMIGR_CREATE_DDL

1908075

Generate DDL statement for migration

Migrate – Automation

Tcode: STC01

task list: SAP_BW*

Task Manager – execute task list

Tcode: STC02

task list: SAP_BW*

Task Monitor – to solve errors occurred running Task List

Tcode: SNOTE

Z_SAP_NOTE_ANALYZER

link

note assistant

Notes Analyzer – application to check the pre-requisites for the usage of BW PCA (Post Copy Automation) and Housekeeping. Allows to list Notes to be implemented.

1614266

Basis XML – XML file contains Basis Notes list

1707321

BW XML – XML file contains Basis Notes list

Warehouse Mngt

Tcode: RSMIGRATE

SAPLRSMIGRATE_FRONTEND

link

Migrating Update Rules, 3.x InfoSources and Transfer Rules

ZBW_TRANSFORM_FINDER

ZBW_TRANSFORM_FINDER_3X – version for BW 3.x

1908367

BW Transformation Finder – check for certain types of transformation rules

LogSys: RS_LOGSYS_ACTIVATE

IO: RSDG_IOBJ_ACTIVATE

DSO: RSDG_ODSO_ACTIVATE

IC: RSDG_CUBE_ACTIVATE

HybridProv: RSDG_HYBR_ACTIVATE

InfoSet: RSQ_ISET_MASS_OPERATIONS

MProv: RSDG_MPRO_ACTIVATE

DS: RSDS_DATASOURCE_ACTIVATE_ALL

IS: RS_COMSTRU_ACTIVATE_ALL

Transfer Rules: RS_TRANSTRU_ACTIVATE_ALL

Update Rules: RSAU_UPDR_REACTIVATE_ALL

TRFN: RSDG_TRFN_ACTIVATE

DTP: RSBKDTPREPAIR

Object Activation tool – collection of several tools for activation of different BW objects

BEx

BEx Query Designer

Link

Starts BEx Query Designer

Tcode: RSRT

Link

Starts BEx Query Monitor

Tcode: RSRTQ

RSRQ_QUERYDEFINITION

N/A

Starts BEx Query Definition

BEx Web Application

Link

Starts BEx Web Application

Web Item Conversion

832712

Starts Web Item Conversion

BEx Analyzer

1901268

Starts BEx Analyzer

RSZW_ITEM_MIGRATION_3X_TO_70

Link

Starts Workbook Conversion

Security

– Authorization

RSECADMIN

link

Maintenance of analysis authorizations objects

SAPLRSEC_MIGRATION

link

Conversion of 3.x reporting authorizations to 7.x analysis authorizations

Security

– Roles

Tcode: PFCG

link

Maintenance of BW Roles

Optimize

ZBW_ABAP_ANALYZER

ZBW_ABAP_ANALYZER_3X – version for BW 3.x

1847431

BW ABAP Routine Analyzer – Scan custom ABAP routines used in: process chain, transformation, transfer rule (IS/DS/SS), update rule (IC, IO, IS), planning area/level/function and ADP.

Tcode: SCI

link

ABAP Code Inspector

Looking forward to hear from you what is your experience using these tools.

PS: The blog is cross posted on my personal blog.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Leonid Ablaev

    Hi Martin,

    this tool is very useful to provide necessary steps to be prepared for the HANA Migration.

    It helped a lot to  identfy the tasks to be conducted before running the upgrade and migration. Also having the ASU tasks listed which can be performed before running SUM, this saves a lot of time during the SUM upgrade process.

    I have identified one issue in the coding for “Database General” / Connections
    We have some connection string with 11 digits. The Checklist tool is assigning the
    Connection to a 10 digit field which yield in a red traffic light , connection not working.
    For us the wromng connection started with +++DBO++…. .
    At the end the connection was fine, but based on the coding the traffic light stayed red.

    Further after the upgrade to 7.5 we faced a lot of entries
    Shadow object DTP_….  cannot be expanded. I have found one note 1229136 which is handling this as an program error, but this not is not valid for 7.5 (at least not today).

    If someone has a solution for it , let me know.

    PS. Good Blog , was looking for this. There should be a discussion forum for this.

    Regards,

    Ralf-Peter Wilke

    (0) 

Leave a Reply