Symptom
- Not able to pass ampersand (&) as a prompt using OpenDocument.
- Certain characters are not interpreted correctly in the URL .
- Values that contain an ampersand (&) are truncated when passed in an OpenDocument link within Xcelsius.
Environment
- BusinessObjects Enterprise
- Dashboard Designer
Reproducing the Issue
- Create a Web Intelligence report having prompt value with ampersand(&).
For Example-Ben & Jerry - 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 - 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:
Keywords
KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem
Product
SAP BusinessObjects Xcelsius Enterprise 2008
Attachments
URLENCODE.JPG |