Find out in which MASTERchain a LOCAL (process)chain is embedded

If you have the technical name of a process chain (and you want to execute it via transaction RSPC1), you might need to know if you’re going to execute the MASTER process chain or (just) a LOCAL process chain.You can find out the “link” between a local process chain and...

More

Usefull (std. SAP) ABAP programs within a SAP BI environment

Listed below several “may come in handy” ABAP Programs (within a SAP BI environment) RSCDS_NULLELIM: Delete fact table rows where all Key Figure values are zero. See Note 619826. RSDG_CUBE_ACTIVATE: Activation of InfoCubes RSDG_CUBE_COPY: Make InfoCube Copies RSDG_CUBE_DELETE: Delete InfoCubes RSDG_DODS_REPAIR: Activation of all ODS Objects with Navigation Attributes RSDG_ODSO_ACTIVATE: Activation...

More

Find out which queries are created for a Infocube/Multiprovider

It’s ‘easy’ to find out which queries have been created “on top of” an infocube or multiprovider.–> Execute transaction RSA1 and press the “Metadata Repository” button (left bottom of the screen)–> Within the overview of all repository objects, click on multiprovider or infocube. See screengrab below–> A list of all...

More

Boosting performance of START routine

There are several ‘places’ where custom made ABAP code can be added within a SAP BI system. One of those places is the START ROUTINE (of an update rule). Within such a start routine, the (incomming) data package can be altered/extended.This alteration is usually done via ‘looping’ over the datapackage:...

More

Check version of BW frontend applications

If you need to find out which version of the SAP Gui or SAP BEx analyzer is being used (so you get an idea of how many PC’s needed to be upgraded/patched), the content of table RSFEC (BW frontend check) can be very helpfull. In the example above you can...

More

Exception handling when calling a FUNCTION MODULE

Sometimes coding (in transfer rules, transfer routines (on infoobjects) or update rules) can cause problems due to invalid exception handling of function module calls. When calling a function module (eg. READ_TEXT) always enable the EXCEPTIONS part of the function call, otherwise a shortdump will occur. (When, in the coding of...

More