1470263 - Euro sign displayed as a square in Xcelsius dashboard with text data

SAP Knowledge Base Article - Public

1470263 - Euro sign displayed as a square in Xcelsius dashboard with text data

Symptom

  • The Euro (€) sign is displayed incorrectly in an Xcelsius dashboard despite showing correctly in the text file.
  • A white square (□) is displayed instead.

Reproducing the Issue

  1. Select Data->Connection
  2. Create a new XML data connection
  3. Select text/xml as MIME type and insert the URL pointing to the source data .txt file
  4. Map the data output to the spreadsheet as required
  5. Create a new component in the dashboard to display the data
  6. Preview the dashboard

Cause

  • The .txt file has been saved with ANSI encoding.
  • Flash Player requires UTF-8 encoding to display the full character set

Resolution

  1. Open the .txt file that feeds the data into the dashboard
  2. Select File->Save as...
  3. Scroll down to "UTF-8" in the "Encoding" selection drop-down menu.
  4. Save the file
  5. Reload the dashboard preview in Xcelsius.

Keywords

eu symbol, charset, junk characters , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008