Skip to Content

Alert message in Dashboard


My client require Alert message or Exception raise just like pop up we are creating in Dashboard 4.0 when bw query doesn't contain any data or if bw query taking lots of time for execution.

Is this types of requirement is possible in Dashboard 4.0 ???

If possible then how to achieve this??

Waiting for your reply.



Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Jul 23, 2012 at 05:15 PM

    Hi Anish,

    You can refer my post on below thread:

    Using excel formulas you can check if there is any data returned by Bex or not and simulate alert/warning message.

    Thank you.


    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Anish,

      Here is information on how to add alert message while connection is loading data in Xcelsius:

      1. Insert 1 for Loading Message and 0 for Ideal Message in to excel cell (Say A1):


      2. Now using dynamic visibility on above cell A1, display alert message with the help of background and label component :

      a. Initially when dashboard has no data.

      b. Click on Refresh button.

      c. Enter user credentials and click on OK.

      d. Notice that value of cell A1 changes to 1 and alert message appears.

      e. Once data is retured.

      Note: Whenever connection triggers, 1 is inserted into cell A1 and as soon as value of cell A1 becomes 1 alert message

      (background and label component) will be displayed.

      I have attached dashboard with this thread for your reference (download AlertMessage.txt rename it to AlertMessage.xlf).

      Hope this helps! 😊

      If this forum post by me have helped you or answered your questions, please mark it as either helpful or answered.

      Thank you.


      1.JPG (11.1 kB)
      1_1.jpg (16.3 kB)
      2_1.jpg (34.8 kB)
      3_1.jpg (24.1 kB)
      4_1.jpg (96.3 kB)
      4_1.jpg (98.0 kB)
  • author's profile photo Former Member
    Former Member
    Posted on Jul 18, 2012 at 04:25 PM

    Hi Anish,

    As per my knowledge, it is not possible. How does dashboard knows there is no data in BW?

    When BEx query is executing how does BEx query know there is no data in BW cube.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 18, 2012 at 12:47 PM

    Hi Anish,

    It can be done. Use a rectangle component . Make it half transparent. And put a Label over it.

    Make sure u bring the label( "loading" ) to the front.

    Give these components dynamic visibility, such that When the query/data is loading or the no data is there the pop up appears.

    Thanks And Regards,

    Sara G

    Add a comment
    10|10000 characters needed characters exceeded

    • Thanks for your reply,

      The things you are telling is for showing the loading status and what i want is to display message if bw doesn't contain data and if bw query taking lots of time.

      Please waiting for your reply if you have solution for this issue.



  • Posted on Jul 21, 2012 at 04:59 AM

    Hey Anish,

    Another alternative to the same would be to map the messages section of the query connection to the excel and use label or any other option to view it.

    With that the users will be able to view the messages that the BICS is trying to communicate. It is both meaningful and understandable. These messages are found in the output section shown below.



    Output_Message.jpg (114.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.