Recently I have completed a BW on HANA migration. Just writing important notes/takeaways from the project for reference.
You have to first upgrade BW 3.x to BW 7.x for you to migrate BW on non HANA to HANA.
Importantly the authorization concept should be migrated to analysis based authorization as role based authorization of BW 3.x no longer exists.
Object types relevant to BW 3.x such as update rules, transfer rule, infospoke, no long exists.
Ensure you have applied the latest SP as lot of changes pre and post migration activities will be taken care of if we have the latest SP with SAP BW 7.5 or BW 7.4.
If you are already in BW 7.x running on any RDBMS. Then you can start migrating the DB to HANADB using DMO (Data base Migration Option) of SUM (Software Update Manager).
Before you do there are certain BW specific housekeeping activities needed to be performed.
1. You can use standard task list SAP_BW_BEFORE_MIGRATION in stc01 tcode. Many of the housekeeping activities are taken care of here.
2. If you have plans of archiving, then go for NLS approach. This is a separate excercise.
3. If you are you production, either you can follow copy approach(copy of the production box) where you will use delta cloning to minimize the downtime of the production system. Else you can empty all the delta queues and ensure the info packages do not run before migration. The delta queues in R/3 will be populating as normal. Once you are ready post migration, you can extract those delta queues.
4. SAP_BW_POST_MIGRATION task list will executed.
5. Check for SNOTES/SPAU for inconsistent notes and fix it. Also run index creation job using program RSDDB_INDEX_CREATE_MASS
6. Check for table consistency using RSDU_TABLE_CONSITENCY.There is a separate program RSDU_PSA_PARTNO_CHECK to repair inconsistent PSA tables. Ideally this can be taken care by the previous program mentioned.
7. Regenerate all transformation rules using RSDG_TRFN_ACTIVATE.
8. Convert Infocubes to HANA In memory optimized using RSMIGRHANADB tcode.
9. DSO will already be HANA optimized during migration - So no action required.
10. Multiprovider can be converted to Composite provider - As such converting MPRO to CPRH does not optimize any performance because MPRO is based on Union and converting it to CPRH will only change the object type.
It is required only if below cases
a. You want to create a HANA model using Composite provider and generate it as external HANA view.
b. You want to further perform changes in Composite Provider to perform Join and Union both.
11. Migrate and Adjust BW Workspaces using below set of programs.
a. RSL_WSP_ADJUSTMENT_AIX
B. RSL_WSP_ADJUSTMENT_COMPLETE
12. Perform a test load and extract all the delta queues into BW.
13. Configure and Implement BW - MT tools using Eclipse based HANA studio. Just install software for BW-MT ABAP and other required perspectives. Add BW system and check if the objects create in studio is getting created in RSA1.
14. If you want to enable hidden objects you can do so using RSCUSTV32 tcode.
15. Enable Web Dynpro by activating services usng SICF_INST and SGEN.
/default_host/sap/bc/webdynpro/sap/RSDMDM_MD_NEW_APP
/default_host/sap/bc/webdynpro/sap/RSDMDM_MD_MAINTENANCE_APP
16. Enable UI5 process monitor - then you can access RSPCM process chain monitor in web using RSPCM_WEB
For details, you can refer SAP First guidance - Using the DMO option to migration BW on HANA available publicly.
You are in BW 3.x ?
You have to first upgrade BW 3.x to BW 7.x for you to migrate BW on non HANA to HANA.
Importantly the authorization concept should be migrated to analysis based authorization as role based authorization of BW 3.x no longer exists.
Object types relevant to BW 3.x such as update rules, transfer rule, infospoke, no long exists.
Major activities for BW HANA Migration?
Ensure you have applied the latest SP as lot of changes pre and post migration activities will be taken care of if we have the latest SP with SAP BW 7.5 or BW 7.4.
If you are already in BW 7.x running on any RDBMS. Then you can start migrating the DB to HANADB using DMO (Data base Migration Option) of SUM (Software Update Manager).
Before you do there are certain BW specific housekeeping activities needed to be performed.
1. You can use standard task list SAP_BW_BEFORE_MIGRATION in stc01 tcode. Many of the housekeeping activities are taken care of here.
2. If you have plans of archiving, then go for NLS approach. This is a separate excercise.
3. If you are you production, either you can follow copy approach(copy of the production box) where you will use delta cloning to minimize the downtime of the production system. Else you can empty all the delta queues and ensure the info packages do not run before migration. The delta queues in R/3 will be populating as normal. Once you are ready post migration, you can extract those delta queues.
4. SAP_BW_POST_MIGRATION task list will executed.
5. Check for SNOTES/SPAU for inconsistent notes and fix it. Also run index creation job using program RSDDB_INDEX_CREATE_MASS
6. Check for table consistency using RSDU_TABLE_CONSITENCY.There is a separate program RSDU_PSA_PARTNO_CHECK to repair inconsistent PSA tables. Ideally this can be taken care by the previous program mentioned.
7. Regenerate all transformation rules using RSDG_TRFN_ACTIVATE.
8. Convert Infocubes to HANA In memory optimized using RSMIGRHANADB tcode.
9. DSO will already be HANA optimized during migration - So no action required.
10. Multiprovider can be converted to Composite provider - As such converting MPRO to CPRH does not optimize any performance because MPRO is based on Union and converting it to CPRH will only change the object type.
It is required only if below cases
a. You want to create a HANA model using Composite provider and generate it as external HANA view.
b. You want to further perform changes in Composite Provider to perform Join and Union both.
11. Migrate and Adjust BW Workspaces using below set of programs.
a. RSL_WSP_ADJUSTMENT_AIX
B. RSL_WSP_ADJUSTMENT_COMPLETE
12. Perform a test load and extract all the delta queues into BW.
13. Configure and Implement BW - MT tools using Eclipse based HANA studio. Just install software for BW-MT ABAP and other required perspectives. Add BW system and check if the objects create in studio is getting created in RSA1.
14. If you want to enable hidden objects you can do so using RSCUSTV32 tcode.
15. Enable Web Dynpro by activating services usng SICF_INST and SGEN.
/default_host/sap/bc/webdynpro/sap/RSDMDM_MD_NEW_APP
/default_host/sap/bc/webdynpro/sap/RSDMDM_MD_MAINTENANCE_APP
16. Enable UI5 process monitor - then you can access RSPCM process chain monitor in web using RSPCM_WEB
For details, you can refer SAP First guidance - Using the DMO option to migration BW on HANA available publicly.
