First Hands on migrated SAP BW to HANA production system

The first test migration to HANA looks good at first glance. The performance of the database is impressive.

But as many features are implemented in SAP BW queries – the performance is not that impressive as I hoped. The monitoring of the queries shows me that the database result is available really fast. But the calculation steps following in ABAP are (still) slow.

Also – this is a first impression of a test-migration:

  • The test-system running the abap-stack isn’t that powerful as our productive server.
  • Many objects are still on the row-store of the HANA (because they are not migrated to in-Memory for several reasons).

For the latest details follow me on twitter: @jay_ar

 

First Hands on migrated SAP BW to HANA production system

SAP-BI: Starting Process-Chain via Programm RSPC_API_CHAIN_START and wait for result

Sometimes you want to start a Processchain via programm and wait for it to end. This is a bit tricky as a Processchain starts normaly in Background and doesn’t give you a result if it is ended correctly.
SAP provides for !!!small!!! Processchain the Function
RSPC_API_CHAIN_START

This can be called synchonous with the following example:
call function 'RSPC_API_CHAIN_START'
exporting
i_chain = 'ZMYPROCCESSCHAIN
* I_T_VARIABLES =
i_synchronous = 'X'
* I_SIMULATE =
* I_NOPLAN =
* I_DONT_WAIT =
* IMPORTING
* E_LOGID =
exceptions
failed = 1
others = 2
.

What you have to know is – the result of this function is given on the !!!first!!! finished step – and !!!not!!! for the whole chain. To wait you have to use a little trick:

While using a one-step-chain with a Sub-Processchain this little problem is solved.

SAP-BI: Starting Process-Chain via Programm RSPC_API_CHAIN_START and wait for result

SAP BI: Read Masterdata with compounded keys / RSAU_READ_MASTER_DATA

Hi SAP-BI-Folks,

this little template gives you the possibility to read on InfoObjects with compounded keys : I am normaly more a friend of my own Masterdata-Read-Routines – but i think it’s usefull to know:
released as usual under BSD-Licence:

TYPE-POOLS rsd.
DATA:
l_chavl TYPE rsd_chavl ,
t_dep_m TYPE rrsv_t_dep ,
s_dep_m TYPE rrsv_s_dep ,
l_chavl_m TYPE rschavl ,
wa_zmy_infoobject TYPE /bic/mzmy_infoobject.

CLEAR l_chavl.
l_chavl = result_fields-/bic/zmy_infoobject .

CLEAR t_dep_m[].
s_dep_m-chanm = 'ZCOMPOUND1' .
s_dep_m-chavl_int = result_fields-/bic/zcompound1 .
APPEND s_dep_m TO t_dep_m.
s_dep_m-chanm = 'ZCOMPOUND2' .
s_dep_m-chavl_int = result_fields-comp_code .
APPEND s_dep_m TO t_dep_m.
s_dep_m-chanm = 'ZMY_INFOOBJECT' .
s_dep_m-chavl_int = l_chavl .
APPEND s_dep_m TO t_dep_m.

CALL FUNCTION 'RRSV_CHA_VALUE_CONCATENATE'
EXPORTING
i_chanm = 'ZMY_INFOOBJECT'
i_chavl_int = l_chavl
IMPORTING
e_chavl_int = l_chavl_m
CHANGING
c_t_dep = t_dep_m
EXCEPTIONS
unknown_chanm = 1
invalid_format = 2
no_input_given = 3
OTHERS = 4.

REPLACE ALL OCCURRENCES OF '#' IN l_chavl_m WITH ` `.

CALL FUNCTION 'RSAU_READ_MASTER_DATA'
EXPORTING
i_iobjnm = 'ZMY_INFOOBJECT'
i_chavl = l_chavl_m
IMPORTING
e_structure = wa_zmy_infoobject
EXCEPTIONS
read_error = 1
no_such_attribute = 2
wrong_import_parameters = 3
chavl_not_found = 4.

SAP BI: Read Masterdata with compounded keys / RSAU_READ_MASTER_DATA