Tools for migrating BW to HANA (BoH)

[MartinMaruskin]

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.

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.