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
