Overview
By default, your web browser may cache the full URL for Xport Wizard, along with the data associated with that URL when a request is made from your dashboard. This is a standard web browser/Flash player issue that must be compensated for when using dynamic parameters to generate or load XML from your dashboard. There is a simple solution to alleviate this issue:
Add a random parameter at the end of the Web Service URL
In this solution though we will append a random variable to the end of the Xport Wizard service URL within the XML connector (not in Xport Wizard). This will change the URL for each transaction between your dashboard and Xport Wizard, allowing dynamic parameters.
*This modification will not cause any performance issues to your dashboard or Xport Wizard.
Directions
- Insert your Web Service URL inside of the Excel worksheet
- Add a “?” to the end of your URL
- Create a cell with "= RAND()". This random function will cause the cell to change each time your XML data connector is executed.
- Concatenate your URL with the cell containing the RAND() function
- Bind your Web Service connector URL to the concatenated cell
Now each time your execute your dashboard to connect with Xport Wizard, your XML connector will use the bound URL with a random variable.
Xcelsius® is a registered trademark of Business Objects Americas Corporation. |
