2646525 - Wrong data showed in the dashboard based on the BIWS web services

SAP Knowledge Base Article - Public

2646525 - Wrong data showed in the dashboard based on the BIWS web services

Symptom

Wrong data showed in the dashboard based on the BIWS web services when refresh=true in the BIWS connection.

Environment

  • SAP BusinessObjects Business Intelligence platform 4.1
  • SAP BusinessObjects Business Intelligence platform 4.2
  • SAP BusinessObjects Dashboards 4.1
  • SAP BusinessObjects Dashboards 4.2

Reproducing the Issue

 Preview the dashboard and wrong data is shown in the dashboard.

This dashboard is based on the BIWS web service on webi.

Cause

If the dashboard is based on web service (on demand) where "refresh" parameter is mapped to "true" or the getFromLatestDocumentInstance is mapped to "true" the Dashboards interprets true only in the capitals i.e. it should be "TRUE" not "true".(Boolean 1 will also work here)

In the fiddler log we will se that refresh=true is passed for which the web service brings no data or incorrect data.This issue is not intermittent.

Resolution

Keep the parameter in the BIWS connection to binary i.e. 1 or keep it in capitals.(refresh can be mapped to TRUE or 1).

Same goes for getFromLatestDocumentInstance(can be mapped to TRUE or 1)

Keywords

wrong data, web service, dashboards, refresh, true , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1 ; SAP BusinessObjects Dashboards 4.2