Additional Tools for BW Migration

 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 1847431.

Create report ZBW_ABAP_ANALYZER in transaction SE38 and copy the source code you got from downloading the zip file from the SAP note. Save and activate the report. Execute it or press F8 to come to the initial screen of the tool.

You can see the options for analyzing-

  • Process Chains
  • Transformations
  • Transfer and Update rules

You can also check Integrated Planning and APDs.

The tool identifies the points where ABAP performance can be made better for performing on SAP HANA database. For example, instead of using SELECT * statements for DSO look up in start routine, you can use internal tables or use the default routine type 'READ FROM DATASTORE'.

BW Transformation Finder

This tool helps to search for transformations in SAP BW systems based on your search criteria. For example, you can search for all transformation in the system having a currency conversion or 'read from master data' type of routines.

You can also specify the traffic lights (green, yellow or red) based on your criteria to be shown against the search results.

You can download the attachment of SAP note 1908367 to install the tool in your system.

Create an ABAP report in SE38 and name it as 'ZBW_TRANSFORM_FINDER'. Copy the source code from the SAP note. Save and activate it. Then click on 'Execute' to go to the initial screen of the tool.

For example, you can search for all the transformations that are omitted under SAP HANA. Here, you will get a list of infocubes that are based on DSO. As mentioned earlier in LSA++, you can get equivalent reporting speed of BEx queries based on DSOs.

Using this tool, you can find such infocubes indirectly via corresponding transformations. You can then decide whether to keep them unchanged or remove them from your SAP BW system.

Before deleting an Infoprovider, include corresponding DSOs in the multiprovider. Then transfer all the BEx queries from the cube to the DSO using transaction RSZC.

After successful migration of your SAP BW system to HANA, you can run this tool again with the checkbox 'Check SAP HANA Processing' ticked. This will analyse the existing transformations whether they can be run on SAP HANA database.If the transformation is eligible, it will be run at significantly higher speeds (This is called Code Push-Down in Transformations). If your transformation is eligible, you can select the option 'SAP HANA Execution' in the corresponding DTP.

BW Migration Cockpit

This combines various tools to make SAP BW migration to HANA more user friendly. Download the attachment of SAP note 1909597. Copy the source code available in the attached file to a new report. Name it as 'ZBW_HANA_MIGRATION_COCKPIT' in transaction SE38. Save and activate it. Click 'Execute' to go to the initial screen of the tool.

Most of the options are already there in the tools discussed earlier. This tool doesn't have many unique features and hence will not be discussed in detail here.

Comments

Post a Comment

Popular posts from this blog

Sample ABAP program for Updating notepad file data to Internal table and Sending it to Application server

 *--Structure type TYPES: BEGIN OF TY_STD, RONO TYPE C LENGTH 4, NAME1 TYPE C LENGTH 20, GEN TYPE C LENGTH 6, FEES TYPE C LENGTH 10. END OF TY_STD. *--Header line and internal table DATA WKA TYPE TY_STD. DATA INT_TAB TYPE TABLE OF TY_STD. *--Application server files are known as "Datasets" *--here "fname" is the Dataset DATA FNAME TYPE C LENGTH 40 VALUE "StudentsInfo.txt". *--Convert notepad file data into internal table CALL FUNCTION 'GUI_UPLOAD' EXPORTING FILENAME = 'C:Documents and SettingsAdministratorDesktopstudents.txt' HAS FIELD_SEPARATOR = 'X' TABLES DATA_TAB = INT_TAB. *--Sending data to Application Server OPEN DATASET FNAME FOR OUTPUT IN TEXT MODE ENCODING DEFAULT. LOOP AT INT_TAB INTO WKA. TRANSFER WKA TO FNAME. ENDLOOP. CLOSE DATASET FNAME.
Read more

OPEN SQL EXAMPLES IN ABAP – PART 2

 ******************************************* **displaying Raw Materials and Finished products **only from MARA table. DATA WA TYPE MARA. * **--WHERE clause is for filtering the records SELECT * FROM MARA INTO WA WHERE MTART = 'ROH' OR MTART = 'FERT'. WRITE: / WA-MATNR, WA-MBRSH, WA-MTART, WA-MEINS. ENDSELECT. * **************************************************
Read more

Domains and Data Elements

  Domains A domain provided Technical attributes (type, length and possible values) for a field. The definition of domain in ABAP is same as that in Mathematics. In the world of Mathematics, a domain is defined as the set of input values that are valid for a given function. The same holds true for domains in ABAP. To understand this, let us first see what is the role of domains in ABAP data dictionary. Domains -> Data Elements -> (Structures, DB tables, program references etc.)
Read more