12c Dashboard Printable PDF shows ? instead of LT symbols and euro sign — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

12c Dashboard Printable PDF shows ? instead of LT symbols and euro sign

Received Response
292
Views
7
Comments
Arūnas
Arūnas Rank 2 - Community Beginner

Hi,

I am using Oracle Business Intelligence 12.2.1.1.0.

I want to print my dashboard to PDF by menu "Print -> Printable PDF". But there are some Lithuanian symbols ("š", "ų", ...) and symbols like euro sign ("€") which are replaced by question marks ("?"). Printable HTML is OK.

Screen Shot 2017-04-07 at 7.33.55 AM.png

I think there is a font issue. PDF fonts:

Screen Shot 2017-04-07 at 7.49.21 AM.png

When I change font in Analysis from Default to "Times New Roman", PDF uses one more font - but with the same bad effect.

Screen Shot 2017-04-07 at 7.48.33 AM.png

I tried to change default PDF using font by Oracle Support article "OBIEE 11g: Characters in PDF Export do not Display Correctly (Doc ID 1453565.1)" with no success. PDF is still using the same fonts. Although I created new "Segoe UI" font (new metrics file, edited all config files), there is no such font in PDF used.

Screen Shot 2017-04-07 at 7.49.34 AM.png

As I understand there is no editable file "pdfstyle.fst" in 12c, maybe it is necessary to create custom skin to change font. But in this situation I changed "pdfstyle.fst" in "tmp" catalog and changes work because color of title was changed. But font-family attribute don't work:

<FoStyle name="SubTitleName" font-size="8pt" color="#993342" display-align="after" text-align="left" font-family="Segoe UI"/>

How to change PDF font or avoid question marks instead of required symbols in other ways?

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Hi,

    I could find this Oracle document for OBIEE 12c. Take a look, may be it helps (look for Configuring Fonts for Graphs)

    https://docs.oracle.com/middleware/12211/biee/BIESG/BIESG.pdf

  • Arūnas
    Arūnas Rank 2 - Community Beginner

    Thank You for help,

    I knew that required fonts have to be copied to Java Home directories, but I'm not sure which directory is right. So I copied to all directories I've found:

    • C:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\jre\lib\fonts
    • C:\Oracle\Middleware\Oracle_Home\oracle_common\jdk\jre\lib\fonts\fallback [CREATED NEW]
    • C:\Program Files\Java\jre1.8.0_101\lib\fonts
    • C:\Program Files\Java\jre1.8.0_101\lib\fonts\fallback [CREATED NEW]
    • C:\Windows\Fonts
    • C:\Program Files\Java\jdk1.8.0_101\jre\lib\fonts
    • C:\Program Files\Java\jdk1.8.0_101\jre\lib\fonts\fallback [CREATED NEW]
    • C:\Program Files (x86)\Java\jre7\lib\fonts
    • C:\Program Files (x86)\Java\jre7\lib\fonts\fallback [CREATED NEW]
    • C:\Program Files\Java\jre7\lib\fonts
    • C:\Program Files\Java\jre7\lib\fonts\fallback [CREATED NEW]

    I know it's crazy to copy all fonts to all directories, but I've tried so much changes with no luck..

    Environment variable JAVA_HOME was not set in Windows (neither JAVA.HOME like written in document "System Administrator's Guide for Oracle Business Intelligence"). So I set them and restarted Windows:

    JAVA_HOME=C:\Program Files\Java\jdk1.8.0_101

    JAVA.HOME=C:\Program Files\Java\jdk1.8.0_101\jre

    No positive result.

    But one interesting thing I found.

    I tried to upload custom font: "BI -> Administration -> Manage BI Publisher -> Font Mappings -> Manage Custom Fonts".

    Then one new catalog "C:\Oracle\Middleware\Oracle_Home\bi\common\fonts" was created with file like "arial_bipcustom.ttf" with size = 0 bytes (empty file). Very strange. Then I thought "Ok, I have one more catalog to copy my fonts!" and I copied all fonts to catalog "C:\Oracle\Middleware\Oracle_Home\bi\common\fonts"... and... IT WORKS! No question symbols!

    albany.png

    albanywtj_pdf.png

    BUT as You can see, Bold font doesn't do it's job very well.

    So now I know that question symbols disappeared when I copied font file "ALBANWTJ.TTF" to directory "C:\Oracle\Middleware\Oracle_Home\bi\common\fonts".

    At Oracle Support (Doc ID 1437681.1) there is interesting information:

    "The Albany WT J font is being used as a fallback font when the required font is not found. When the required font isn't configured appropriately in the xdo.cfg file, the Albany WT J font under %pshome%\lib\fonts folder is used. If this fallback font can not be found either, the barcode font embedded in the form template itself will likely be used. This unpredictable behavior can be avoided by ensuring that required fonts are configured appropriately in the xdo.cfg file, using the <font-substitute> property."

    In my situation this sentence says that I have not properly defined fonts (Helvetica, ArialMT, Arial-BoldMT, ...? ) and fonts cannot be found. But I don't understand WHERE to put font files, WHERE to describe them properly, WHAT names of that fonts are... I tried so many different changes but I cannot solve the problem with that fonts.. Very strange that this situation is with default fonts and configuration. I replaced the file "pdfstyle.fst" with original to avoid some misleading effects.

    Any ideas?

  • 3068122
    3068122 Rank 4 - Community Specialist

    Hi Arünas ,

    If you have OBIEE 11g environment , could you please try after copying "fonts" folder from  11g environment (<Oracle_Home>/Oracle_BI1/common) to 12c environment (<Oracle_Home>/bi/common) ?

    Also related documentation is OBIEE 12c - Turkish (Non English) Character Is Missing On Pdf Export (Doc ID 2097276.1)

    Regards

  • Arūnas
    Arūnas Rank 2 - Community Beginner

    Thanks, You confirmed that font files must be in the directory "<Oracle_Home>/bi/common/fonts" on 12c environment. That's good news.

    In our 11g environment this functionality (printable PDF) was not used, so fonts in this directory don't help. They are all default fonts and copying them doesn't solve my problem.

    I don't understand why default fonts are not delivered in the required directory by default. For example, I change font of the Title and Subtitle to the "Times New Roman" in the dashboard, then go to the menu Print -> Printable PDF, and required font is not found. I guess I have to know the name of "Times New Roman" *.TTF file and put it to the directory "<Oracle_Home>/bi/common/fonts"? Like "ALBANWTJ.TTF". If you change the name of the file "ALBANWTJ.TTF", this font is not found too.

  • Arūnas
    Arūnas Rank 2 - Community Beginner

    "TimesNewRomanPSMT" and "ArialMT" is Post Script names of fonts "Times New Roman" and "Arial". So it's "Times New Roman" and "Arial" fonts. Of course both of them are installed on the system.

    BI Publisher Predefined Fonts contains "Times", "Time-Roman", "Helvetica" and other Type1 fonts (https://docs.oracle.com/middleware/12211/bip/BIPAD/GUID-1EBF6921-41D4-4DB7-90A3-BB0EF1FD534C.htm#BIPAD337 ).

    As I understand, Type1 fonts are not embedded in PDF's, and TrueType fonts are embedded if there is *.TTF file in correct directory. That's why "Albany WT J" work for me and "Helvetica' ("Arial") or "Times New Roman" doesn't. How to make it work? Good question. I give up and I'll have to be satisfied with "Albany WT J" without nice bold.

  • Arūnas
    Arūnas Rank 2 - Community Beginner

    Here is my solution (workaround) for this issue:

    • copy the file "ALBANWTJ.TTF" to the directory "C:\Oracle\Middleware\Oracle_Home\bi\common\fonts";
    • replace all font-weight="bold" to font-weight="normal" in the file "C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\servers\obips1\tmp\earmanager\analytics\LdtMj7hA1pT8kxPy_y00Mg\res\s_Skyros\b_mozilla_4\pdfstyle.fst" for default "Alta" theme;
    • restart Presentation server.

    There is no bolded text in PDF anymore. That's better than mixed bolded and normal text in one word for special symbols.

  • If I can add just a note to your solution: do it into your own custom style instead of editing default Skyros (Alta inherit from Skyros) files. So the change will survive updates/upgrades and you will not lose it if for any reason the analytics deployment is redeployed on Weblogic.