5 Replies Latest reply on Oct 27, 2017 7:53 AM by Christian Berg

    Export Chart to Excel results in Strange Characters

    J Kremer

      Hi All,

      I have an OBIEE 12.2.1.2.0 install running the SampleAppLite.bar and when I export a chart from BI to Excel (or Powerpoint) the characters become garbled characters despite looking fine in a dashboard (or export to PDF).

       

      Screenshot of the SampleApp dashboard: https://imgur.com/a/KlzsZ

       

      Screenshot of the Export to Excel results of the same dashboard: https://imgur.com/a/kBAlD

       

      I can reproduce the same issue by manually changing the renderFormat in the Advanced XML section of an Analysis to 'png' instead of 'default' (ie HTML5). So to me it looks like the issue is occuring when OBIEE needs to render a chart to png as it does when making an Excel export.

      I'd say it's related to not finding a font or the fonts being mismapped but I can't determine which font folder would be used to generate these png files specifically.

       

      Any ideas?

       

      Cheers,

      J