GRC
HR
SCM
CRM
BI


Blog

 

Automate your BW to HANA Migration Readiness Check (v2.0)

by Dr. Berg

February 18, 2013

There are many tasks and technical requirements to migrate a BW system to HANA. This includes BW technical settings and software levels required to start the process. Thankfully, SAP has provided a checklist tool for SAP NetWeaver BW powered by HANA.   In this Blog we take a quick look at the key features. By Dr. Berg

Automated HANA Readiness Tool

In version 2.x of this tool available since December 2012, hundreds of checks are done automatically in the BW system. This includes platform checks on database and application and system information.

There are even basis checks for support packs, ABAP/JAVA stacks, Unicode, BW releases, and add-ons to your system. The program is found in SAP Note 1729988, and the tool provided automatic check programs for both the 3.5 version and the 7.x version of BW

 

FIGURE 1: INPUT FOR SELECTING READINESS CHECKS FOR BW TO HANA MIGRATION

First you enter the checks you want to perform to see if your system is ready for a HANA Migration. This should include most of the options seen in the figure above, such as basis and database, but you also can choose to ignore customer objects or checks you are planning to run at a later time.

The idea of the checklist tool from SAP is that you run it several times throughout the project. Once before you start, then periodically as you resolve issues an d upgrade requirements, and then finally when the system has been migrated to HANA. This last step is important, since the checklist tool also has specific checks for the HANA system that can help you identify any issues before turning over the system to end users. If the tool shows a ‘red’ flag, you should resolve this before starting your HANA migration, or if a new red flag shows up, fix it before completing the migration.

FIGURE 2: BW READNIESS RESULTS FOR HANA MIGRATION

 

The output results in a list of actions that should be undertaken before the migration starts. In our example, we can see that for our system database patch 110 should be applied as part of our preparation steps.

 

Getting Started

If you want to try this program in your system, simply install the latest version from SAP Marketplace in note 1729988 and then execute the program using ZBW_HANA_CHECKLIST for those on a BW 7.x system, or ZBW_HANA_CHECKLIST_3X for those on older BW 3.x systems.  The tool even allows you to download any recommended SAP notes to fix issues found in the check through the automated transaction call of SNOTE. This program should be executed by anyone who is in the planning stages of a BW to HANA migration.

More Information at SAP BI 2013 in Las Vegas

Next month at BI 2013 in Las Vegas, I will be showing more tools and give a detailed presentation on how to create “Strategies for budgeting, planning, and sizing your SAP NetWeaver BW on SAP HANA projec t”. The session will be at the MGM on Tuesday, March 19, from 12:00 to 1:15 pm.  

During the conference I will also be signing copies of the SAP HANA Book I wrote for SAP press with Penny Silvia and you can stop by to see me at the ‘meet-the-expert’ session and get your HANA questions answered…

Hope to see you there...

Dr. Berg

An email has been sent to:






More from SAPinsider



COMMENTS

Please log in to post a comment.

Bjarne Berg

9/25/2013 9:05:18 PM

Hi Marc,
You did an awesome job on this tool. Before I had to do all checks manually and now you save us 1-2 days of work (actually the screenshot above is from one of my clients in Asia who used the tool this week).
Other areas that may be good to focus on in the future is extended ability to estimate what we can clean-up in the BW system before the migration.
There are some checks, but here are the '12-step' program I use today for size reduction. It would be great if you can take a look and see if you see any areas where this can be automated, or reported.
1. Clean the Persistent Staging Area (PSA) for data already loaded to DSOs
2. Delete the Aggregates aggregates (summary tables). They will not be needed again.
3. Compress the E and F tables in all InfoCubes. This will make InfoCubes much smaller.
4. Remove data from the statistical cubes (they start with the technical name of 0CTC_xxx). These contain performance information for the BW system running on the relational database. You can do this using the transaction RSDDSTAT or the program RSDDSTAT_DATA_DELETE to help you.
5. Look at log files, bookmarks and unused BEx queries and templates (transaction RSZDELETE).
6. Remove as much as possible of the DTP temporary storage, DTP error logs, and temporary database objects. Help and programs to do this is found in SAP Notes 1139396 and 1106393.
7. For write-optimized DSOs that push data to reportable DSOs (LSA approach), remove data in the write-optimized DSOs. It is already available in higher level objects.
8. Migrate old data to Near-Line Storage (NLS) on a small server. This will still provide access to the data for the few users who infrequently need to see this old data.
9. You will also be able to query it when BW is on HANA, but it does not need to be in-memory.
10. Remove data in unused DSOs, InfoCubes and files used for staging in the BW system. This includes possible reorganisation of masterdata text and attributes using process type in RSPC
11. You may also want to clean up background information stored in the table RSBATCHDATA. This table can get very big if not managed. 12. You should also consider archiving any IDocs and clean the tRFC queues. All of this will reduce size of the HANA system and help you fit the system tables on the master node.
Furthermore, in SAP Note 706478, SAP provides some ideas on how to keep the basis tables from growing too fast too fast in the future, and if you are on Service Pack 23 on BW 7.0, or higher, you can also delete unwanted master data directly (see SAP Note: 1370848).
Finally, you can use the program RSDDCVER_DIM_UNUSED to delete any unused dimension entries in your InfoCubes to reduce the overall system size.
Just some more ideas on what could possibly be 'automated' or perhaps reported on.
Anyway, thanks a bunch for a great tool Marc!!!
Dr. Berg

Marc Bernard

9/25/2013 9:05:18 PM

Thanks for promoting my tool :-)

Let me know if you come up with other checks that could be included.

Kind Regards,
Marc
SAP Customer Solution Adoption (CSA)


SAPinsider
FAQ