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

[Deleted User]

Are you doing "Export Entire Dashboard"? Because it sounds like bug/patch 21774811

Edit: And for the fonts - they go in yourbihome/bi/common/fonts. The whole folder is normally missing so I just grabbed it from a 11.1.1.9 install

J Kremer

No in that example I used: Page Options > Export to Excel > Export Current Page

But the same thing happens if I Export an individual chart to Excel 2007 also.

[Deleted User]

So check the fonts / get them from an 11 instance. I have many 12s running (.1, .2 and .3) on both Linux and Windows and none have that issue

J Kremer

The common folders contain the same fonts between 11g and 12c. What log file would you suggest to dig through when trying to debug Export to a file?

Thanks for the responses so far.

[Deleted User]

Export mainly involves the OBIPS and OBIJH components

Not sure how much you will get without addition logging though https://docs.oracle.com/cd/E21764_01/bi.1111/e10541/logging.htm#BIESG217