SAP Knowledge Base Article - Public

1412300 - Chinese characters are garbled, when Xcelsius use the xml as datasource.

Symptom

There are some Chinese characters in the xml file which is the datasource for Xcelsius. When preview it, all Chinese characters are garbled.

Environment

BOE XI3.1 with SP2

Xcelsius 2008 with SP and FP2.1

Reproducing the Issue

  1. Create a xml file using notepad or wordpad which has Chinese characters, as below,

    <data>
      <variable name="Range_0">
        <row>
          <column>公司 1</column>
          <column>47</column>
        </row>
      </variable>
    </data>

  2. Use this xml file to be the datasource of Xcelsius.
  3. Use list view to show the data.
  4. When preview it, the Chinese characters are garbled.

Cause

The default encoding of notepad is ANSI. And it doesn't support the Chinese characters.

Resolution

  1. Open the xml file using the notepad, click "File"-->"Save as".
  2. Change the encoding from "ANSI" to "UFT-8", then save it.

Keywords

Xcelsius; xml;Chinese character , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Dashboards 4.5