Conversion of DTP's (after BDLS)

When a BDLS has ran, usually after a system copy/restore, not always all existing DTP's have been properly 'BDLS-ed'.

To 'BDLS' DTP's, program RSBKDTP_BDLS can be used.

SAP BW user exit alternative

Instead of applying/changing code of 'user-exit' ABAPs ZXRSAUnn or ZXRSRUnn, you can also use BADI RSU5_SAPI_BADI
Tcode SE18:

Implementation --> Overview or Implementation --> Create
Double click on METHOD: DATA_TRANSFORM

Within METHOD IF_EX_RSU5_SAPI_BADI~DATA_TRANSFORM the required user exit code can be entered/altered.

Program to activate transformations in a closed BW system

Without having to transport your transformation (again), you can also execute abap RSDG_TRFN_ACTIVATE to re-activate an inactive transformation

Regression tests? Make easy cube content downloads

It's been a while (aka long time) since I've last posted an entry to this blog. My apologies...

Ever wondered how to make life easier when executing regression tests on cube content?
Wouldn't it be easy to just download the cube content to excel twice and compare the 2 downloads?
To achieve the above, just use transaction RSCRM_BAPI



Via RSCRM_BAPI you can easily make query extracts and save these extracts to excel.
The preferred regression test way of working:
1) Execute RSCRM_BAPI on a query on a particular cube and download query result to excel
2) Apply changes to the transformation/update rule of that particular cube
3) Reload a subset of data to that particular cube
4) Execute step 1 (with the same variables)
5) Compare the 2 (created in step 1 and step 4) excel downloads and you're done!

That's all folks....