SAP Knowledge Base Article - Public

1755329 - Xcelsius dashboard won't refresh from XML Data

Symptom

A dashboard based off of XML Data connection(s) does not display changed data.

Reproducing the Issue

  1. Create an xml file that will be used as the data source for a dashboard.
  2. Publish the xml file to a web server.
  3. Create a dashboard and add an XML Data source.
    1. Name the connection.
    2. Point the XML Data URL to a cell within the spreadsheet area. (Optionally, enter the URL for the xml file in the allotted area.)
    3. Set the MIME Tpe to text/xml
    4. Click on the Enable Load checkbox.
    5. Click the (+) sign in the enable load area.
    6. Enter the Name of the xml Variable to be used.
    7. Point the Range to a block of cells in the spreadsheet area.
    8. Click on the usage tab and set refresh conditions.
    9. Close the Data Manager.
  4. Enter the URL of the xml file into the cell area pointed to in the Data Manager.
  5. Add a component to display the xml data. (Spreadsheet Table etc)
  6. Point the data display to the cells holding the xml data.
  7. Preview dashboard.
  8. Make a change to the xml data on the web server.
  9. Note change is not reflected in dashboard.

 

 

Cause

The xml data is cached and is not showing the newer xml. 

  1. Open a browser window and navigate to the xml data url.  The data may not reflect the new data.
  2. Click on the browser refresh button.
  3. Note the new data is displayed.

Note:  This is a browser issue and unrelated to the product.

Resolution

  1. In Internet Explorer,  open the Internet Options.
  2. On the General Tab, click on the settings button listed in the Browsing History area.
  3. Place a check mark next to the statement "Check for newer versions of stored pages Every time I visit the web page".
  4. Reopen the dashboard swf file and note changes are reflected.

Optionally, in a web page containing an embedded swf file a Meta tag can be added at the head of the page to force the browser to not use the cache.

<meta http-equiv="expires" content="0">

Keywords

Xcelsius, Dashboard, XML Data, refresh, XML , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Xcelsius Enterprise 2008