Pentaho整合FusionCharts的插件pentaho-fc-plugin安装配置

原创文章，转载请注明出处：http://qq85609655.iteye.com/blog/2372421

 

参考资料:

https://github.com/xpandit/pentaho-fc-plugin/wiki/Manual

https://github.com/xpandit/pentaho-fc-plugin/wiki/IntegrationCDE

 

 

1. Change the file system/ImportHandlerMimeTypeDefinitions.xml to allow xFusion files. Add this handler at the bottom of file:

 

<ImportHandler class="org.pentaho.platform.plugin.services.importer.RepositoryFileImportFileHandler">

  <MimeTypeDefinitions>

    <MimeTypeDefinition mimeType="text/plain" hidden="false" converter="streamConverter">

      <extension>xfusion</extension>

    </MimeTypeDefinition>

  </MimeTypeDefinitions>

</ImportHandler>

 

2. Change the file system/importExport.xml adding xfusion in 1 places:

 

<bean id="DefaultExportHandler" class="org.pentaho.platform.plugin.services.importexport.DefaultExportHandler">

  <property name="repository" ref="unifiedRepository" />

  <property name="localeExportList">

    <list>

        ...

      <value>.xfusion</value>

    </list>

  </property>

</bean>

 

 

3. Update file system/pentaho-cdf-dd/resources/styles/Clean.html

 

<script type='text/javascript' src="/pentaho/content/xfusion/JSClass/FusionCharts.js"></script>

<script type='text/javascript' src="/pentaho/content/xfusion/JSClass/fusioncharts.charts.js"></script>

<script type="text/javascript" src="/pentaho/content/xfusion/js/XPCharts.js"></script>

<script type="text/javascript" src="/pentaho/content/xfusion/js/XDashFusionChartComponent.js"></script>

<script type="text/javascript" src="/pentaho/content/xfusion/js/CDE.js"></script>

 

4. Installing FusionCharts XT

 

Use the FusionCharts XT installation available in Tools -> FusionCharts Manager to install the zip.

 

Key C68735E691AE95

 

 

整合过程中遇到一些问题，特别记录下：

1. 拥有参数的情况下

FusionCharts 无法传递参数

XDashFusionChartComponent.js

doCDAQuery方法

1269行：

queryData[prefix.concat(parameters[i][0])]=Dashboards.getParameterValue(parameters[i][0]);

2. 雷达图

Categories CDA Path 的数据源，需要输出字段名称为label，需要通过Calculated Columns重新命名

lable =[name]

3. 无法显示