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 , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem