How To Suppress Messages Generated by BW Queries

Hello Everyone,

under certain circumstances the BI system generates warning or info messages when running a queries. There can be various reasons like an inconsistent mapping of InfoObjects for the underlying MultiProvider (BRAIN, 152) or an inactive BIA index (RSD_TREX, 136). You don’t want to ignore these messages completely, but there are occasions where you want to suppress some messages from being displayed to your end users (or specific groups of users).

Standard Solution

You might be aware of a standard solution. In transaction RSRT, select your query and click on the “message” button. Now you can determine which messages for the chosen query are not to be shown to the user in the front-end.

For more information on the BW Query Monitor, please see the online documentation at http://help.sap.com/saphelp_nw70/helpdata/en/a0/2a183d30805c59e10000000a114084/frameset.htm.

Custom Solution

Only selected messages can be suppressed using the standard solution. However, there’s a clever way you can implement your own solution… and you don’t need to modify the system for it!

All messages are collected using function RRMS_MESSAGE_HANDLING. So all you have to do is implement an enhancement at the start of this function module. Now it’s easy. Code your own logic to check the input parameters like the message class and number and skip the remainder of the processing logic if you don’t want this message to show up in the front-end.

FUNCTION rrms_message_handling.
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""$\SE:(1 ) 
Function Module RRMS_MESSAGE_HANDLING, Start
*$*$-Start: (1 )----------------------------------------------------------------------$*$*
ENHANCEMENT 1  Z_CHECK_BIA.    "active version
* Filter BIA Message
  if i_class = 'RSD_TREX' and i_type = 'W' and i_number = '136'.
*    Just testing it...
*    exit.
  endif.
ENDENHANCEMENT.
*$*$-End:   (1 )----------------------------------------------------------------------$*$*
*"------------------------------------------------------------
*"*"Lokale Schnittstelle:
*"  IMPORTING
*"     VALUE(I_CLASS) LIKE  SMESG-ARBGB DEFAULT 'BRAIN'
*"     VALUE(I_TYPE) LIKE  SMESG-MSGTY DEFAULT 'S'
*"     VALUE(I_NUMBER) LIKE  SMESG-TXTNR DEFAULT '000'
*"     VALUE(I_MSGV1) OPTIONAL
*"     VALUE(I_MSGV2) OPTIONAL
*"     VALUE(I_MSGV3) OPTIONAL
*"     VALUE(I_MSGV4) OPTIONAL
*"     VALUE(I_INTERRUPT_SEVERITY) LIKE  SY-SUBRC DEFAULT 16
*"     VALUE(I_LANGU) LIKE  SY-LANGU DEFAULT SY-LANGU
*"     VALUE(I_SAPGUI_FLAG) DEFAULT SPACE
*"     VALUE(I_SUPPRMESS) TYPE  RSRSUPPRMESS OPTIONAL
*"     VALUE(I_CUMULATE) TYPE  RS_BOOL DEFAULT RS_C_FALSE
*"     VALUE(I_PROBCLASS) TYPE  BALPROBCL OPTIONAL
*"  EXCEPTIONS
*"      DUMMY
*"------------------------------------------------------------

Remember, enhancements are modification free. 🙂 If you want to know more about enhancement options and how to implement them, please check the online documentation at http://help.sap.com/saphelp_nw70/helpdata/EN/a0/47e94086087e7fe10000000a1550b0/frameset.htm.

Best,
Marc Bernard
@marcfbe