Wednesday, August 31, 2016

How to find out what triggered run of APD process?

Sometimes we are wondering how come that some Analysis Process Designer (APD) process ran. Usually user can execute it manually from tcode RSA1 or RSANWB. There is a possibility to see a log or so called Monitor for APD but it doesn’t tell who and how it was started. What is possible to get out of the APD monitor is job name (BI_PROCESS_ANPR) and job number, etc.

Therefore one option that one can turn to is a possibility that it was triggered by process chain (PC). To look up the list of PC that contain a step of APD execution a table RSPCCHAIN can be used. Following restriction shall be used. Into field TYPE = ANPR and VARIANTE = “name of APD process”. By this selection one can get a list of PC where particular APD is used.

Monday, August 1, 2016

RSREQREDUCE - Reduction of Requests in InfoProv

Within version 74 of BW a new tcode was introduced. It is called RSREQREDUCE and it helps in housekeeping of data load requests. While using it a BW administrator can identify and reduce potentially large number of requests in InfoProvider. In case the InfoProvider has many requests in there it slows down the processing of such InfoProvider.

The functionality of Reduction of Requests is available while running the above mentioned tcode or via RSA1 -> Administration -> Housekeeping Tasks -> Request Housekeeping or via data request monitor. There an RED icon is displayed. By clicking on it it get ot the tcode:


From its main screen the BW admin can run the request reduction itself by specifying parameters. I find the tool is quite handy. It is intuitive and it reveals the objects that have many request there in very straight forward way.