We recently upgraded and migrated our BW 7..02 to BW 7.40 on HANA platform using DMO successfully. Major emphasize consider from technical front is to get BW system ready for business usage immediately after all SAP Basis and BW/HANA post DMO activities completed.

This is a challenging and required expertize on SAP Basis and BW front and understanding of all reporting and tools available in BW 7.40.

In each step mentioned in our step by step technical sheet consolidated and created by mutual effort of Basis and BW/HANA teams as a combined template for each post DMO effort.

Preparation Infrastructure Tasks
S.No Task Name Duration Team Remarks
1 Window 2008 upgrade TBD Infra team
2 Validate HANA appliance, OS patches, firmware updates etc. updated. TBD Infra team
3 Determine means to transport DB export from Source BW to Target HANA in different Datacenter. TBD Infra team
Preparation Basis Tasks
1 Kernel upgrade 720_EXT_REL patch 110 or higher including SAPPSCOL, SPAM update TBD BASIS
2 Upgrade Host agent SAP HOST AGENT 7.20 SP188 or higher TBD BASIS
3 SAP update to SP17-7 (SAP_BASIS) and SP19-7 (SAP_BW). TBD BASIS
4 Dual stack split TBD BASIS
5 Testing and validation TBD BASIS
6 1736976 – Make sure this note is implemented before sizing report TBD BASIS
7 Run ABAP Report /SDF/HANA_BW_SIZING TBD BASIS
8 Generate Stack file for Upgrade to BW 7.4 SP0XX TBD BASIS
9 Pre-migration performance tuning on OS, DB, SAP level. TBD BASIS
Preparation BW Tasks
1 SAP_BW_HOUSEKEEPING before the upgrade 1829728 (STC01) TBD BW Team
2 SAP BW ABAP Routine Analyzer – checks BW system for critical ABAP statements in data flows and fix outstanding issues. TBD BW/ABAP Team
3 ZBW_HANA_MIGRATION_COCKPIT  -Checklist tool TBD BW/BASIS
4 Other BW Steps for cleanup TBD BW Team
Pre-Migration Tasks
1 Download Latest SUM Toolset and SWPM Tool (for Primary Instance) TBD BASIS
2 Download Latest Kernl CD for NW 7.4 for (SQL) TBD BASIS
3 Download Latest R3loadctl,R3ta,R3szchk,R3load and SAPEXE,SAPEXEDB  files TBD BASIS
4 SAP BASIS SP patch level (SMIGR_CREATE_DDL) TBD BASIS
5 SAP Note 1921023- SMIGR_CREATE_DDL TBD BASIS
6 SAP HANA requires unicode – Check the Unicode Status TBD BASIS
7 List of HANA components allowed to install ( SAP Note:1603671) TBD BASIS
8 SAP HANA hardware check ( SAP Notes: 1652078 & 1658845) TBD BASIS
9 SAP BW system to HANA – H/W Sizing ( SAP Note: 1736976 & 1637145) TBD BASIS
10 scale out architecture, sizing of master node ( SAP Note: 1855041) TBD BASIS
11 ABAP statements will be optimized for SAP HANA ( SAP Note: 1847431) TBD BASIS/BW Team
12 install the ABAP Development Tools (SAP Note 1718399) TBD BASIS/BW Team
13 Regular tasks for maintenance of BW system – BW Housekeeping Task List ( SAP Note: 1829728 ) as part of HANA_COCKPIT) TBD BASIS
14 SAP Business Warehouse Migration to HANA ( SAP Note: 1600929) TBD BASIS
15 Optimal settings of SUSE Linux SLES 11 SP3 (SAP Note: 1954788 ) TBD BASIS
16 Conversion of standard DSO’s in to HANA optimized DSO is no more required ( SAP Note: 1849497 & 1849498) TBD BW Team
17 Conversion of standard Info cube in to HANA optimized DSO is no more required TBD BW Team
18 Prerequisites for HANA migration automatically SAP HANA – Checklist Tool ( SAP Note: 1729988) TBD BASIS
19 Migration/system copy to SAP HANA using latest SUM SP13 before starting migration ( SAP Note: 1775293) TBD BASIS
20 Perform house keeping tasks to delete unwanted data from database (ZBW_HANA_COCKPIT) TBD BASIS/BW Team
21 Consider Table splitting for larger tables ( SAP Note: 1783927) TBD BASIS
22 Request or generate a migration key TBD BASIS
23 Update database statistics of Source DB ( SQL) TBD BASIS
24 Execute: Pre migration tasklist, SAP_BW_BEFORE_UPGRADE/MIGRATION TBD BASIS/BW Team
Execute Report: SAP_UPDATE_DBDIFF (SAP Note: 2017638) TBD
Target System: TBD
1 Apply Latest HANA Server Software-  DB Version including latest Revisions TBD BASIS
2 Download Latest SAP Hana Client TBD BASIS
3 Download Latest SAP Kernel for Target DB for ( HANA) TBD BASIS
4 Download Latest Kernl CD for NW 7.4 for (HANA) TBD BASIS
5 set the environment variable HDB_MASSIMPORT=YES on Target System during Import TBD BASIS
7 Order and install a new SAP license for HANA DB TBD BASIS
8 Correct time zone for HANA DB &  SAP NetWeaver (CST instead of UTC) TBD BASIS
9 Check UUIID libraries on Linux based AppServers ( SAP Note: 1310037) TBD BASIS
10 Local host name refers to loopback address ( SAP Note: 1054467) TBD BASIS
Unicode conversion Preparation
TBD BASIS
Run report UMG_ADD_PREP_STEP – the below tasks are now part of this report TBD BASIS
Delete QCM tables Note: 9385 TBD BASIS
BW System conversions:/BI0/0; Note: 449891 TBD BASIS
Apply Note 679275 for RPU470ADJUST_T52C5 TBD BASIS
Report RADNTLANG 480671, 672835 TBD BASIS
Reset nametab buffers /$NAM TBD BASIS
Consistency check  for ABAP Dictionary  – Run report RUTCHKNT  in SE38 (172 Inconsistent Objects)/RUTMSJOB TBD BASIS
Run report RSCPINST in SE38 TBD BASIS
Check entries Table TCPDB in SE16 TBD BASIS
Print old spool requests (Can also execute report UMG_POOL_TABLE) 842767 TBD BASIS
report UMG_R3CHECK_FILES   89384 TBD BASIS
Run R3check on database level TBD BASIS
Update DB Statistics Before Scans TBD BASIS
Application of note # 970780 TBD BASIS
Increase PSAPTEMP to 500 GB TBD BASIS
Run report RS_TRANSLATION_EXPORT_OLD_PP as described in SAP Note 660873 (now obsolete) and 1055820 TBD BASIS
Reset All Scans TBD BASIS
Initialise language list TBD BASIS
Edit Language List TBD BASIS
Maintain SPUMG Settings; (make checkpoint “active” & create secondary index on CDCLS, as given in Summary document) TBD BASIS
Run report RSCP0125 to check if the code page(s) are roundtrip-compatible. TBD BASIS
Update WorkList TBD BASIS
Configuration of operation mode to increse the background jobs TBD BASIS
SCAN1-Perform Consistency Check in SPUMG TBD BASIS
Updated statistics on UMGCCTL, UMGPMIG, UMGPMDIC, UMGPMDII and UMGSTAT/Vocabulary files upload as per note 756535 TBD BASIS
DMO Specific tasks
Check the SAPHOSTAGENT.SAR version TBD BASIS
execute command –> SUMSTART confighostagent TBD BASIS
From Browser run – http://<hostname>:1128/msl/upgrade/<SID>/doc/gui TBD BASIS
follow the SUM Screens with Expert mode selection TBD BASIS
Migration and Upgrade Tasks
Necessary Pre Steps (Application Specific) – Source System TBD BASIS
1 Execute: RS_SYSTEM_SHUTDOWN / Migration Cockpit TBD BASIS
2 Executre: BTCTRNS 1 TBD BASIS
3 Run SMIGR_CREATE_DDL TBD BASIS
4 Tablesplit Preparation selection TBD BASIS
5 Run the Export Preparation with SUM TBD BASIS
Specify the TMP/TEMP space Bourne shell (sh) TBD BASIS
TEMP=/usr/sap/tmp; export TEMP TBD BASIS
TMP=/usr/sap/tmp; export TMP TBD BASIS
6 Table split Preparation TBD BASIS
7 Specify Export Dump Location TBD BASIS
8 Check the availability of the created files in the export directory TBD BASIS
9 Run the Export with SWPM – DB Instance Export TBD BASIS
10 Check the availability of the created files in the export directory TBD BASIS
7 Starting the import with SWPM TBD BASIS
8 Specify HANA client version for the HANA server revision TBD BASIS
9 Register in SLD during SWPM Installaton TBD BASIS
10 Refer Note 885441 – Common Migration Errors TBD BASIS
11 Check invalid_objects.txt after Import Completion TBD BASIS
Post-Migration Tasks
1 Find the potential Infoproviders that can be retired when using HANA. ( SAP Note 1908367) TBD BW Team
2 For comparing ABAP code execution times after a migration to SAP HANA ( SAP Note: 1942889) TBD BW Team
3 Order and install a new SAP license ( BW) TBD BASIS
4 Correct the DEFAULT.PFL and adapt the instance profile TBD BASIS
5 Import new license and check secure storage after migration TBD BASIS
6 Apply corrections after SP08 for HANA based systems ( SAP Note: 1769670) TBD BASIS/BW Team
7 Manual processing of some SAP notes ( SAP Note 1673420) TBD BASIS
8 check the consistency with transaction DB02 TBD BASIS
9 Execute : RDSU_TABLE_CONSISTENCY report TBD BASIS/BW Team
10 BW-MT: Composite SAP Note for SAP NetWeaver 7.40 SP07 4/2 – executing UDO repor TBD BW Team
11 OData and BICS – Corrections after SP07? TBD BW Team
12 Workspace Designer – Corrections after SP07? TBD BW Team
1953480 – Column view generation after upgrade to SAP BW 7.40 SP5 or above TBD BASIS
13 Run – SGEN TBD BASIS
14 Modifying the SAP profiles (restart SAP) TBD BASIS
15 Check the HDB/ABAP settings in general TBD BASIS
16 Check the HDB settings for SP08 and higher TBD BASIS
17 Check transaction SECSTORE after system copy TBD BASIS
18 Reset the logon groups TBD BASIS
19 Check settings in report RSCPINST TBD BASIS
20 Check myself connection after system migration ( RSA1) TBD BASIS
21 Check DSO activation parameters TBD BASIS
22 Execute: Report RS_BW_POST_MIGRATION – run in Background with Variant SAP&POSTMGRDB TBD BASIS/BW Team
23 Execute: The post migration tasklist, SAP_BW_AFTER MIGRATION TBD BASIS/BW Team
24 Convert the BW InfoCubes to in-memory optimized – Transaction RSMIGRHANADB TBD BW Team
25 Check the settings for TMS after the system copy TBD BASIS
26 Check SE06 Settings TBD BASIS
27 Check SE80 – Package TBD BW Team
28 Check further SAP NetWeaver BW basis settings ( if Any) TBD BASIS
29 Remodel process chain to remove the obsolete variants in process chain TBD BW Team
30 Install calender related hierarchy – from business content TBD BW Team
31 Connect to Hana Studio TBD BW Team
32 Role determination and assignment for Hana tool administration TBD Security
33 Functional Check list TBD BW Team
Unicode Conversion Post Steps
34 Complete Post System copy steps as per system copy guide TBD BASIS
35 Run report UMG_HISTORY TBD BASIS
36 Run report UMG_POOL_TABLE  (SAP note 813445) TBD BASIS
37 Run report RUTTTYPACT TBD BASIS
38 Run report RSCPINST and Activate New NLS configuration TBD BASIS
39 Check Table Pools TBD BASIS
40 Special Handling of DBTABLOG Tables; Note # 1042842 TBD BASIS
41 Special Handling of Tlock * Tables; Note # 795871 TBD BASIS
42 Import the Proposal Pool for the translation workbench by running RS_TRANSLATION_IMPORT_OLD_PP for all source – target language TBD BASIS
43 Create file_info.txt file TBD BASIS
44 Run report UMG_SCAN_STATISTICS TBD BASIS
45 Table  DMEE_TREE_NODE run report HRUU_CONVERT_IN_UNICODE if necessary(Note 895804) TBD BASIS
46 Adapt Parameters according to SAP Note 790099 TBD BASIS
47 RFC Destinations; Apply SAP Note 647495, 547444 & 722193 TBD BASIS
48 SUMG – Completion procedure using file_info.txt TBD BASIS
49 SAP License Application TBD BASIS
50 Restart SAP TBD BASIS
51 SGEN TBD BASIS

Note, these steps are generic steps for Post BW Migration using DMO., consider it as template only.

To report this post you need to login first.

5 Comments

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

  1. Harish Allachervu

    Good job! Although you’ve listed 4 steps before migration, it would have been nice if you listed activities more specific to BW consultant needs to taken care, I mean to say pre&post migration from BW perspective.

    Regards,

    Harish

    (0) 
    1. amit lal Post author

      Hi Harish,

      In migration approach using SAP DMO tool, we have ZBW_HANA_MIGRATION_COCKPIT  -Checklist tool available give all BW related pre and post migration steps, we have to make sure this report is up to date.

      Thank you,

      Amit

      (0) 
      1. Prasanthi K

        Hi Amit,

        Thanks for listing the activities for migration! it helps a lot. I have a question, note 1847431 is mandatory activity to perform? Please let me know.

        Thanks & Regards

        Prasanthi

        (0) 
        1. amit lal Post author

          HI Prasanthi, It required for critical ABAP statements in data flows running in BW system. Its only recommendation from SAP. Ours BW system does not have much codes.


          Regards,

          Amit



          (0) 

Leave a Reply