2181104 - Cambodian characters are not displayed are not displayed in the PDF output of a webi document

SAP Knowledge Base Article - Public

2181104 - Cambodian characters are not displayed are not displayed in the PDF output of a webi document

Symptom

  1. In a WebI report, a column contains Japanese, Chinese and Cambodian characters in different rows.
  2. If we assign 'Arial' font on this column, the Japanese, Chinese and Cambodian characters are displayed correctly in Web mode but show up as square boxes in Java mode and PDF output.
  3. If we assign 'Arial Unicode MS' font, the Japanese and Chinese charaters are displayed correctly in Web, Java mode and PDF ouput. However, the Cambodian characters are not displayed.
  4. If we save the report to Excel, the Japanese, Chinese and Cambodian characters are displayed correctly.

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.1
  • Web Intelligence

Reproducing the Issue

  1. Create a WebI report having a column that contains Japanese, Chinese and Cambodian characters in different rows.
  2. If we assign "Arial" font on this column, here are the results-
    • Web mode   - Japanese, Chinese and Cambodian characters displayed correctly
    • Java mode   - Japanese, Chinese and Cambodian characters NOT displayed correctly
    • Excel output - Japanese, Chinese and Cambodian characters displayed correctly
    • PDF output   - Japanese, Chinese and Cambodian characters NOT displayed correctly
  3. If we assign "Arial Unicode MS" font on this column, here are the results-
    • Web mode   - Japanese, Chinese and Cambodian characters displayed correctly
    • Java mode   - Japanese and Chinese characters displayed correctly but not Cambodian characters.
    • Excel output - Japanese, Chinese and Cambodian characters displayed correctly
    • PDF output   - Japanese and Chinese characters displayed correctly but not Cambodian characters.

Cause

  • Arial and Arial Unicode MS fonts are not capable to displaying Cambodian characters.
  • All characters are displayed correctly in Web mode and Excel ouput because the Browser and Excel use fallback fonts to display different language characters.
  • To display Cambodian characters, the browser and Excel internally pick-up "Khmer UI" font as the fallback font.
  • It is possible to modify the fontalias.xml file and add Khmer UI font which will display the Cambodian characters correctly in WebI as well as PDF. However, this font is not capable to displaying Chinese/Japanese characters.
  • As per the current design of WebI, we can assign only one font to a column. This is the expected behavior.

Resolution

  • To display Cambodian language, install Khmer UI font and add the following entries in the fontalias.xml files-

 <FONT NAME="Khmer UI">
    <FONTFAMILY PLATFORM="ttf" NAME="Khmer UI">
      <FONTATTRIBUTE BOLD="false" ITALIC="false" LOGICAL="Khmer UI" PHYSICAL="KhmerUI.ttf"/>
    </FONTFAMILY>
    <FONTFAMILY PLATFORM="win" NAME="Khmer UI"/>
    <FONTFAMILY PLATFORM="java" NAME="Khmer UI"/>
    <FONTFAMILY PLATFORM="html" NAME="Khmer UI"/>
  </FONT>

  • There is no direct solution for this issue if a column contains Cambodian as well as other language characters.
  • A workaround in this situation is to Save the WebI report to Excel and then Save the Excel document to PDF.

To request a new feature or product enhancement SAP has defined a new process and a new tool that is now available to customers called Idea Place. Idea Place, https://ideas.sap.com, allows customers to log Enhancement Requests themselves and have the ability to work more directly with our technology and Development group. 

See Also

SAP KBA #1515837 - How To: Enhancement Request Process - "Idea Place"

Keywords

Cambodian, Japanese, Chinese, Unicode, characters, square boxes , KBA , BI-RA-WBI , Web Intelligence , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008