SAP Knowledge Base Article - Public

1629244 - How to pass an ampersand (&) in Xcelsius via an OpenDocument link or URL

Symptom

  1. Not able to pass ampersand (&) as a prompt using OpenDocument.
  2. Certain characters are not interpreted correctly in the URL .
  3. Values that contain an ampersand (&) are truncated when passed in an OpenDocument link within Xcelsius.

Environment

  • BusinessObjects Enterprise
  • Dashboard Designer

Reproducing the Issue

  1. Create a Web Intelligence report having prompt value with ampersand(&).
    For Example-Ben & Jerry
  2. Then create a Xcelsius dashboard passing opendoc url having ampersand (&) as a prompt value like this:-
    http://<servername>:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&iDocID=11373&lsSEnter+value(s)+for+Data:=Ben&Jerry
  3. The opendocument Url breaks the prompt value at Ben only.

Cause

Xcelsius does not pass the Ampersand(&) as %26 within the Excel file.

Resolution

Use %26 instead of "&" within the dashboard without selecting UrlEncode option like this:

 URLENCODE.JPG

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008

Attachments

URLENCODE.JPG