Skip to Content
Technical Articles
Author's profile photo Marc Bernard

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

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.
*$*$-End:   (1 )----------------------------------------------------------------------$*$*
*"*"Lokale Schnittstelle:
*"      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

Marc Bernard

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Witalij Rudnicki
      Witalij Rudnicki
      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.


      Author's profile photo Former Member
      Former Member
      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?

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author
      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.


      Author's profile photo Mike Howles
      Mike Howles
      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!
      Author's profile photo Former Member
      Former Member
      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.

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author
      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.


      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Marc Bernard
      Marc Bernard
      Blog Post Author

      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).



      Author's profile photo Nagaraj G
      Nagaraj G

      Hi Marc,

      Very good information, it helped me to resolve my issue   🙂



      Author's profile photo Vincent Ong Kok Wee
      Vincent Ong Kok Wee

      Hi Marc,

      Not sure whether is this blog still active, I wanted to implement a enhancement to suppress msg BRAIN 390, but I don't know where to start.

      The link in your page doesn't work anymore.

      Would be great if you can provide the link again.


      Author's profile photo Rui Romba
      Rui Romba

      Hello experts

      I need to enhance a standard message displayed by the system when the users inserts incorrect / wrong Master data.


      I need to put more information in the message, like the all the key of the planning data (all the values of the line) so the users can easily find the error when inputting many records.

      is there any way to do it?

      Many thanks,