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.
Thursday, 27 October 2011
Friday, 21 October 2011
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.
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
Tuesday, 30 August 2011
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....
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....
Subscribe to:
Posts (Atom)