Category: BW

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

Display cube dimension percentage used

To display, per dimension, the percentage used with regard to the number of entries in the fact table(s), function module RSDEW_INFOCUBE_DESIGNS can be used.Enter the name of the cube for input parameter I_INFOCUBE and execute the function module. Export parameter E_T_TABLSIZE will provide you the desired result as shown in...

More

(Re)set a FULL LOAD to FULL REPAIR LOAD mode

When having executed a full load to a delta enabled target, the next delta request cannot be activated anymore. (The full load is hampering this)Solving this issue by deleting this full load can be a solution, but it’s easier to reset the full load to a full repair load. The...

More

How To: Delete an Update Rule to an already deleted target

When you’ve deleted an ODS/Infocube/Infoobject (aka target), without prior having deleted the update rule which was linked to that particular target, the update rule still ‘wanders around’ your SAP BI system. (Eventhough you can not see it via transaction RSA1)You can deleted this (orphan) update rule (call it some kind...

More