Skip to Content
Technical Articles

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

10 Comments
You must be Logged on to comment or reply to a post.
  • That’s a good hint! Indeed in some companies IT does not want to confuse business with BIA messages, because it has to be transparent for users. Otherwise it generates call center traffic (and associated $$), when user calls them to ask what is BIA.

    Thanks,
    -Vitaliy

  • Dear Marc,

    Thanks for the nice blog on this topic. I will be trying to implement it but wanted to ask one thing beforehand. We have had a long standing problem in planning applications that we want to display some info message to the user when he presses a button to execute a function.
    Generally in the planning web templates, we select the option to ‘suppress info messages’ but then it suppresses these messages also which are written by us in FOX code. If we dont suppress them, users also see messages like ‘pl fn <…> executed without errors’ etc which are confusing and we have to clarify each time a new user comes on board the application.

    The method that you have explained – can it be used to selectively suppress planning system messages too?

    • Hi Mayank,

      it should work with BI-IP, too. Try the enhancement point at the end of RSPLFR_SERVICE_LOG_READ. Filter the E_T_LOG table.

      Regards
      Marc

  • Marc, your post came at just the right time, for just over a month we’d been struggling with warning message RSBBS 203 after an upgrade from BW 3.5 to 7.0.  Even running queries using the old 3.5 runtime, we encountered this new warning message, which is confusing to our users who were not accustomed to seeing it.  This enhancement is a good workaround until something official from SAP might be done.  Thanks again!
  • Hello, Mark! Can I ask you a question? Hope you can help me.
    I need to execute BEX workbooks from Enterprise Portal with automatically predefined values of variables. I’d like to do this in two ways: normal (ordinary way) and as background process without opening analyzer and workbook (result: xls. file).

    For example: Task for universal work list contains URL link to workbook. This link contains also parameters for define values of wb variables (year for example). I want to read this parameters automatically by clicking on this link and put  them in wb.

    Another problem to execute Bex Analyzer in background.

    Thank for help.

    • Hi AI,

      I don’t see any relationship of your question to the blog. You can use Information Broadcasting to run workbooks in background. If you need more help with this, please post your question into the BI forum.

      Regards
      Marc

  • Hi All !

    The same approach for suppressing IP-Messages works also fine (so far…).

    Enhancement in function-module RSPLFR_SERVICE_LOG_READ.

    In SAP BW7.3 the IP message-handling changed by SAP.

    Please consider the SAP-Note 1653610.

    Regards, Alex

  • Hi Marc,

    We have to upgrade from BEX3.x to BEX73. Because of installation issues with VPN users, we want to roll out the new Bex BEFORE migrating the workbooks.

    But if users are opening 3.x workbooks with 7.x bex analyzer, they are getting two messages during opening.

    1. Do you want to open the 3.x workbook for upgrade? –> click ok

    2. 3.x Workbook: ‘workbook’ opened for Upgrade –> click ok

    Afterwards everything is fine. But I think a lot of users will call us because of these messages and will not open the workbook.

    Is there any possibility to suppress these messages?

    (It is a workbook topic, no query topic, so rsrt cannot be the solution correct?

    Furthermore I have no idea, which message numbers I should suppress for example with you enhancement above.)

    Any idea?

    Thanks, best regards, heike

    • Hello Heike,

      as far as I can tell these message are raiser by BEx analyzer and can’t be influenced by the backend. Sorry. If the migration works seemless anyway, why not do it first before the all users get the BEx 7.x?

      If the migration will not be so seemless, then I think the messages are justified (which is many times the case for example due to VBA macros).

      Regards,

      Marc