SAP easy learning

 Online SAP resource to check the information on these tools for different versions: http://scn.sap.com/docs/DOC-40984 ABAP Routine Analyzer This tool enables you to analyze the performance of ABAP routines that are used in data flows. Here, you can see all the ABAP statements that should be optimized for performing on SAP HANA. To install the tool, download the attachment of the SAP note

 Below are listed some of the important Information material on BW on HANA migration- Information on System copy and migration in SCN - http://scn.sap.com/docs/DOC-8324 Best Practice Guide-Classic Migration of SAP Netweaver AS ABAP to SAP HANA: http://scn.sap.com/docs/DOC-47657 Heterogeneous ABAP System Copy - Technical Overview: http://scn.sap.com/docs/DOC-34258 Additional Information on SAP BW on SAP HANA migration under BW 7.3: http://scn.sap.com/docs/DOC-12262 Additional Information on scale out scenarios: http://scn.sap.com/docs/DOC-39682 Implementation - BW on HANA Export/Import - https://scn.sap.com/docs/DOC-41588 System Copy and migration guides: http://service.sap.com/stoolset - SOFTWARE LOGISTICS TOOLSET 1.0-DOCUMENTATION-SYSTEM PROVISIONING-SYSTEM COPY: SYSTEMS BASED ON SAP NETWEAVER <RELEASE> - <PLATFORM> SAP note 886102 - Copy of System Landscape for SAP Netweaver BW: https://service.sap.com/sap/support/notes/886102 SAP note 1775293 - Migration/System Copy...

 After you've prepared your SAP BW system properly, you can start the export activities. First SAP BW system is exported, then the export files are made available in the target system for the new BW application server. To reduce the time of the migration process, you can start the export and import process in parallel. In this case, you must save the export files in directory which you can access in the target environment. To create the necessary directory structures, you must call the SWPM in the SAP BW original system using the EXPORT PREPARATION option. In your SWPM system, start sapinst or sapinst.exe with a user that has administrator rights. However don't use the <SID>adm user for this purpose. Select your system version and currently used database from the overview. Choose SYSTEM COPY-SOURCE SYSTEM - BASED ON AS ABAP TOWARDS SAP HANA DB-EXPORT PREPARATION, and click NEXT.

 In Import phase, lesser activities are required. First step is to check the size of your file system so that sufficient storage is available for the target environment. As you generally deploy a certified SAP HANA appliance, this will be taken care automatically. Before starting with the import, you should also set the log mode of the SAP HANA system to overwrite the existing log files during import. Otherwise migration may crash due to storage medium of log files becoming full in capacity.

 Once the import preparations are done, you can start with the process. Before starting the SWPM in the target system, check whether you can access the export directory. You can access it via network using \<server name>directory. If you are not able to access the directory, check your firewall settings. Now start SWPM in the target server, and choose SAP BW version and SAP HANA database as the target database. Then select SYSTEM COPY-TARGET SYSTEM-STANDARD SYSTEM-BASED ON AS ABAP STANDARD SYSTEM, and click next.

 After the successful migration using SWPM, there are general Basis activities required to set up the SAP BW system on new database. These are generic like setup of transport landscape, maintenance of operation modes, adaptation of RFC server group. However, there are certain SAP BW on HANA specific post migration activities that need to be performed. Generic Basis Activities- Step 1: Reset the database log mode and create a backup Open SAP HANA studio, and go to CONFIGURATION tab in the ADMINISTRATION perspective. Expand the GLOBAL.INI-PERSISTENCE tree. An input window opens once you double click on LOG_MODE. Set the log mode parameter of SYSTEM back to NORMAL. Also, reset the value for ENABLE_AUTO_LOG_BACKUP to YES. Note that the database does not generate any log files until a back up is created. For creating backup, right click on you SAP HANA system in the system tree. Select BACKUP AND RECOVERY-BACK UP SYSTEM from the menu. Step 2: Activities at Operation System and Database ...

 Once the Basis related activities are done after migration, you must carry out SAP  BW specific post migration activities. Step 1: Restore Myself system and SAP BW source systems The users are automatically locked out of SAP BW on HANA system. You should unlock the technical system users after migration. Do not release the end users still. In the source system tab in RSA1, check whether you can see the SAP BW myself system. Right click and select 'Restore'.  Then also check and restore the other connected source systems. Here you may need to enter the passwords for the relevant background users. Check with the

 Below steps are specific for the BW system on HANA database- Step 1: Deactivate password change for System Users In the default settings, the system prompts at regular intervals for changing the passwords of SAP HANA users. This may cause issues for system users because the password may be stored in another system, or jobs are scheduled for them. If such kind of password changes and you don't modify the environment accordingly, this may effect the operating procedure. So, you should deactivate the periodic password change for selected users. For security reasons, you must consider this carefully. You can deactivate the  password change with the following statement: ALTER USER SAP<SID> DISABLE PASSWORD LIFETIME. Step 2: Adapt Privileges As specified in SAP note 1897236, check whether the database user SAP <SID> has SELECT privileges for accessing the _SYS_REPO and _SYS_BIC schemas. You can use the following SQL command for this purpose: SELECT GRANTEE, GRANTOR, OBJ...

 There are lot of pitfalls one may encounter in doing real life migration of BW on HANA. See this post for some tips to avoid them- Use Latest Software versions SAP HANA support packages are released quite frequently. Implement the latest SAP notes in your BW system using the tcode SNOTE. SAP note 2021789 mentions which SAP HANA notes are specially verified for Production. The following link provides latest revisions of SAP HANA software: http://help.sap.com/hana/Whats_New_SAP_HANA_Platform_Release_Notes_en.pdf Refer latest documentation The HANA cookbook for BW for example, is not up to date for all topics. ( http://cookbook.experiencesaphana.com/ ). You can use this cookbook as an introduction of basic concepts. You should read available documents of SAP first Guidance Collection for SAP BW on SAP HANA present at below link- http://scn.sap.com//docs/DOC-28467 SAP  has announced to update the cookbook soon. Checking the Software Versions