Friday, March 21, 2014

BusinessObjects-Webi Runs Fine in Modify Mode But Retrieves No Data in View Mode

Another strange situation from Business Objects.

Just create a report with a date prompt. Check the options "with list of values" and choose "Equal" as operator. In Modify mode (Java Report Panel) your report works fine. But if you try to refresh your report in View mode you will see the "No Data To Retrieve" message.

If you analyze the SQL Scripts of both mode's, you will see that in View mode BI adds some hours (eg.4 or 8) to your current selected date prompt. Therefore no data matches to your query.

This is addressed to ADAPT01710199
See note: http://service.sap.com/sap/support/notes/1930605

For a workaround change the time setting under Tomcat as follow:



Environment: SAP Business Objects BI 4.1 SP2 Patch2

1 comment:

  1. This comment has been removed by a blog administrator.

    ReplyDelete