SAP Knowledge Base Article - Public

1922053 - How to suppress Query Browser errors in dashboards during runtime

Symptom

Dashboards containing Universe (UNX) queries or BEx queries created using Query Browser may display error message windows during runtime if the dashboard fails to execute successfully. Usually the error messages state "Cannot Access External Data". So you do not want to display any such error messages during runtime.

Environment

  • SAP BusinessObjects Dashboards 4.0
  • SAP BusinessObjects Dashboards 4.1

Reproducing the Issue

  1. Create a Universe (UNX) or BEx query using query browser
  2. Preview the dashboard
  3. Get "Cannot Access External Data"  error message if any of the queries fail

Resolution

  1. Select "Add Query" from Query Browser
  2. Select Data Source
  3. Specify the Universe/BEx query
  4. Build Query
  5. Preview Query Result
  6. Under Usage Options check the "Hide Error Message Window". "Insert In" will insert the error message description in a spreadsheet cell

1.png

This options suppresses XLS000003, XLS000006 and XLS000009 error messages that may occur during dashboard runtime.

Keywords

suppress dashboard errors runtime, runtime errors, suppress xcelsius errors , KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1