SAP Knowledge Base Article - Public

2204496 - Value is inserted into the incorrect column after query is refreshed in Dashboards

Symptom

Value is inserted into the incorrect column after query is refreshed in Dashboards

Environment

  • SAP BusinessObjects Dashboards 4.0 / 4.1 / 4.x

Reproducing the Issue

  1. Launch Dashboards designer, add some queries against unx universe.
  2. Bind the queries' result to some columns of the EXCEL.
  3. Add some components like Scorecard or label to display the queries data.
  4. Add Connection Refresh button and use it to refresh some specific queries.
  5. Preview the Dashboards document.
  6. Click the Connection Refresh button and find sometimes after a specific queries is getting refreshed, the scorecards displayed the incorrect data as the excel data is changed unexpected.

Cause

The specific query definition information is broken in this dashboards document.

Using the following steps can find the detail information.

  1. Rename extension of xlf file to zip file.
  2. Unzip this file and get a document.xml file. This xml file contains the detail information about the Dashboards.
  3. Open the document.xml in notepad. And some corrupted information may be found in the specific query as:
    <endpoint type="excelbinding" id="BOC1CBEC8D77A94E7AA2119077F42FABD4" displayname="SheetName!$B$52:$B$56" isStyle="0">
    The range SheetName!$B$52:$B$56 is what should not be updated by this query.

It is suspected that frequent query modification might cause some corruption information left in the Dashboards file. However, the detail workflow which can 100% replicate this error is unknown.

Resolution

There are two ways to fix this issue:

  • Delete the problematic query and add the query again to fix the issue.

  • Use the below method to update the problematic xlf file.
    1. Rename extension of xlf file to zip file.
    2. Unzip this file, open the document.xml in notepad to edit.
    3. Find the problematic part as <endpoint type="excelbinding" id="BOC1CBEC8D77A94E7AA2119077F42FABD4" displayname="SheetName!$B$52:$B$56" isStyle="0">
    4. Delete the whole section which contains this part. The section is started from <property> and ended with </property>.
    5. Save the file document.xml.
    6. Compress all the items to a zip file again. After that, rename the zip back to xlf extension.
    7. Open this new xlf file in Dashboards designer and confirm the issue is resolved.

      Note: This method changed the xml directly without using Dashboards designer. It is is recommended that keeping the original xlf file as a backup.

Keywords

swf, xcelsius, flash, broken, damage, xls, xlsx , KBA , BI-RA-XL , BusinessObjects Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1