Skip to main content

Pentaho+ documentation is moving!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

Analysis issues

Parent article

Follow the suggestions in these topics to help resolve a common issue with Pentaho Analyzer:

  • Multi-Byte characters do not appear in PDFs exported from Analyzer
  • Geo Maps partially rendering

See Pentaho Troubleshooting articles for additional topics.

Multi-byte characters do not appear in PDFs exported from Analyzer

If you are using a multi-byte character set, such as would be used for languages like Japanese or Chinese, and find that you have missing or corrupted output when exporting Analyzer reports to PDF, you will have to specify a default TrueType font for PDF rendering that supports multi-byte characters. The default PDF font in Analyzer is Helvetica, which does not support multi-byte character sets.

When displaying data in Analyzer, your reports will use the default browser fonts. However, the PDF export function may not have the same fonts available when creating a PDF from your Analyzer report. The resulting output will not look the same in PDF as it did in the browser. The default font for PDF is Helvetica, but you can specify any TrueType font or collection to replace it using the following instructions:

Procedure

  1. Stop the Pentaho Server and User Console.

  2. Edit the analyzer.properties file in the /pentaho/server/pentaho-server/pentaho-solutions/system/analyzer/ folder.

  3. Uncomment the renderer.pdf.font.path line, as shown in the following sample line of code:

    renderer.pdf.font.path=C:/WINDOWS/Fonts/MSGOTHIC.TTC,1
  4. Replace the value of this line with the TrueType font or collection that you want to use as the default. If you are specifying a collection, you must put a ,1 after the font name, as shown in the above example. This does not apply to individual fonts (TTF files).

    renderer.pdf.font.path=/usr/share/fonts/truetype/freefont/FreeSans.ttf
  5. Save and close the file, and start the Pentaho Server.

Geo Maps partially rendering

If your Geo Map visualizations in Analyzer are not correctly displaying, the Pentaho Server is not giving them enough time to fully render.

The Pentaho Server has a static length of time it waits for a Geo Map to finish rendering before the image is captured. This delay allows for all map tiles to be downloaded and points to be plotted. The default wait time is 1200 milliseconds, and it is set through the <map-export-javascript-delay> node in the pentaho-solutions/system/pentaho-geo/settings.xml file, as shown in the following sample line of code:

<map-export-javascript-delay>1200</map-export-javascript-delay>

The following instructions show how to extend the cache value for Geo Maps:

Procedure

  1. Locate the pentaho-server/tomcat/webapps/pentaho/WEB-INF/classes directory and open ehcache.xml in a text editor.

  2. Look for the cache element and increase the value for maxElementsInMemory as shown in the following example:

    <cache
        name="pentaho-geo-{CUSTOM_ROLE_TYPE}"
        maxElementsInMemory="1000"
        eternal="false"
        overflowToDisk="true"
        timeToIdleSeconds="0"
        timeToLiveSeconds="0"
        diskPersistent="false"
        diskExpiryThreadIntervalSeconds="120"
      />
  3. Save and close the ehcache.xml file.

  4. Restart the Pentaho Server.