Skip to Content

The Intention of this blog is to share a checklist  of steps (major one in terms of source system preparation ) prior to migrating you BW from XXX database to SAP HANA .Most of the points would be aldreay known to you ,so i am trying to prepare a checklist , do give you input if i had missed on some steps .

PRE- MIGRATION ACTIVITIES:-

We assume that you have decided on the migration option (New BW instance, upgrade, migration , DMO ) and also decision on Stack split as per the requirement has been taken .This document  details list of  activities that are recommended (optional) as pre-migration activity .

The purpose of pre-migration activity is to cleanse unwanted data that will help in accelerating time line of migration and Optimized usage of HANA. The focus should be on :-

  1. Master Data & transactional data spread across PSA tables, change logs, info Objects, DSO and Info cubes.
  2. Meta data like job logs, process chains logs, bookmarks etc.

Points to take care of before migrating NW BW on HANA:-

  1. Shrink the data which will be moved to the row storage of the SAP HANA database. To achieve this we need to follow BW housekeeping TASK list, mentioned in detail below.
  2. Shrink the data which will be moved to the column store of SAP HANA (NLS solution) / (RDS available).
  3. Use the released database migration option (DMO) as part of SUM tool for the in-place migration including upgrade/Migration/Unicode steps .

  

23-03-2014 19-59-44.png

Regular housekeeping activity on BW system do take care of the data cleansing. Let’s see the focus area and do re-run the checklist to see that you have optimized your system before migrating.We have to take care of following data, always consult the concern team/member who owns the data/service before taking any action :-

  1. Business data : –
  1. Permanent data

          – Definition of retention period of data in BW info provider.

          – Definition of needed granularity

          – Compression of info cube. **

          – Archiving of Data via SARA (classical method) or Near Line storage (NLS).

          – Master data deletion.

          – Reorganization of master data attributes and texts through process types in RSPC

   b. Temporary Data –

          – Deletion of data from the persistent staging area (PSA) data.

          – Deletion of data from data store object change logs.

          – Deletion of non-used dimension entries.

          – Usage and filling of OLAP cache and aggregation.

          – Deletion of temporary database objects.

          – Deletion of DTP temporary storage.

  2. Statistics and Administrative data :-

          – Database volume statistics

          – Archiving /deletion of BW request monitoring & Administrative tables.

          – Filling and clean-up of BW statistics table.

          – Deletion of t-RFC .

          – Archiving   of IDOC.

          – Deletion of logs on the application server.

          – Deletion of RSBATCH info.

3.Meta Data

       – Deletion of unused aggregates (SAP note 1644396), for migration to HANA DB aggregates are not exported because they are not needed anymore.

       – Deletion of unused queries/workbooks/bookmarks.

       – BW content Analyser checks.

4. Database Platform

       – Deletion of Empty partitions.

       – Table and index fragmentation.

       – Compression on DB level.

   

**Please go through the relevant note or steps as mentioned below:-

Action

Reports /Action

SAP note

Info cube compression

SAP_INFOCUBE_DESIGNS to check the size of E and F tables , and decide on if it needs to be compressed or not

-NA-

PSA table clean up

RSAR_PSA_PARTITON_CHECK; SAP_PSA_PARTNO_CORRECT;RSAR_PSA-CLEANUP_DIRECTORY and RSAR_PSA_CLEANUP_DEFINITION

1150724

PSA Error log reorganization

RSSM_ERRORLOG_CLEANUP

706478

Deletion of BW statistics table

report RSDDSTAT_DATA_DELETE/ t-code RSDDSTAT, delete data older than 14 days

-NA –

Delete old process chain logs

RSPC_INSTANCE_CLEANUP and report RSPC_LOG_DELET

706478

Delete inconsistent Errors DTPs

RSB_ANALYZE_ERRORLOG to analyse your error logs then execute RSMB_ERRORLOG_DELETE to delete the old entries

1095924

Old t-RFC

use SM58 to reorganize and delete old t-RFC queues

-NA-

Delete Expired application logs

Use t-code SLG

-NA-

Glossary:-

  • – DMO – Data base Migration option.
  • – NLS – near Line storage
  • – SUM – software update manager
To report this post you need to login first.

11 Comments

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

  1. Bharath Reddy Kummithi

    Very helpful info, could you please provide more info on ”Filling and clean-up of BW statistics table.” like how the filling and clean up done in steps and the requirement for the same.

    (0) 

Leave a Reply