OBIEE 11g – How To Display New Font Correctly for Graph Views in Browser and Exported as PDF/PPTx/CLSx


You have added a new font for BIEE following Previous Post
For Graph views which contain Characters of New Font, you find that some of the characters in browsers or exported as PDF/PPTx/CLSx show as squares.

Please implement following steps to display new font correctly for Graph Views.

  1. Adding a new font for OBIEE following:
    OBIEE 11g: How To Add new Fonts in Answers and Dashboards
  2. Implement following steps for exported files.
    1.  Create a metric file from the true type font with the command:
      java -classpath $MW_HOME\Oracle_BI1\clients\bipublisher\xdo-core.jar oracle.xdo.common.font.TTFDumpMetrics D:\Temp\eudc.ttf 0 eudc.xml
    2. You need to tell OBIEE where to find the .xml file and the name of the font to use.
      Locate the file userconfig.xml under the directory:

      $MW_HOME\Oracle_BI1\bifoundation\web\display\userconfig.xml

      Modify it by adding the following entry:

          <font metrics-file=”c:/Temp/eudc.xml” embed-file=”c:/Temp/eudc.ttf”
      kerning=”yes”>
      <font-triplet name=”eudc” style=”normal” weight=”normal”/>
      <font-triplet name=”eudc” style=”normal” weight=”bold”/>
      <font-triplet name=”eudc” style=”italic” weight=”normal”/>
      <font-triplet name=”eudc” style=”italic” weight=”bold”/>
      </font>
    3. You Need to tell OBIEE that the new font is installed.
      Locate the file:pdffontmapping.xml
      In the directory:$MW_HOME\Oracle_BI1\bifoundation\web\display\

      Add the following entry:
       

      <fontMapping name=”eudc”>
      <choose>
      <when locale=”*”>
      <font name=”eudc”/>
      </when>
      </choose>
      </fontMapping>
    4. You Need to tell Javahost where to find the ttf font.
      Locate the file xdo.cfg under the directory:
      $MW_HOME\instances\instance1\config\OracleBIJavahostHostComponent\coreapplic ation_obijh1
      and modify it as follows:
       

      <config version=”1.0.0″ xmlns=”http://xmlns.oracle.com/oxp/config/”&gt;
      <fonts>
      <font family=”eudc” style=”normal” weight=”normal”>  <truetype path=”D:/Temp/eudc.ttf”/>
      </font>
      </fonts>
      </config>

       
      You can have multiple font family mapping to the same font file C:/Temp/eudc.ttf is as follows:
       

      <config version=”1.0.0″ xmlns=”http://xmlns.oracle.com/oxp/config/”&gt;
      <fonts>
      <font family=”Arial” style=”normal” weight=”normal”>
      <truetype path=”C:/Temp/eudc.ttf”/>
      </font>
      <font family=”Calibri” style=”normal” weight=”normal”>
      <truetype path=”C:/Temp/eudc.ttf”/>
      </font>
      <font family=”eudc” style=”normal” weight=”normal”>
      <truetype path=”C:/Temp/eudc.ttf”/>
      </font>
      </fonts>
      </config>

       

  3. Delivering Font Files for Printing following
    – Copy your .ttf file to JAVA.HOME/lib/fonts
    – Copy .ttf file in JAVA.HOME/lib/fonts to JAVA.HOME/lib/fonts/fallback
  4. Restart BIEE Services.
  5. Keep font family of all Titles and Labels to default(system) for your Graph View via Graph Properties.
  6. In advanced Analysis XML of your views, Change to renderFormat=”png” from renderFormat=”default”  and save it.
  7. Set and map the new font as a Default Font of Browser.
    DEV maps the system default font to “sans-serif” family. This is a logical font and in the presentation server this needs to be mapped to a physical font.
    This mapping is done through the PS code/scripts. For the browser same  needs to be done to map serif/sans-serif to your NEW font so that ‘System(Default)’ will pick the correct font family.

    For Firefox:
    set [Default font] to your desired font via Tool –> select Options –> content.
    and Make sure the “Allow pages to choose their own fonts, instead of my selections above” box is unchecked via Advanced.

    For Internet Explorer
    set [Webpage font] to your desired font via Tools –> Internet Options –> General –> Fonts.
    And in the Accessibility tab of Tools –> Internet Options –> General –> Accessibility, make sure that
    – “Ignore font styles specified on webpages” is Checked
    –  “Ignore font sizes specified on webpages” is Checked

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s