Pentaho 1.6 and Later Collector XML Examples

Owned by Former user (Deleted)
Last updated: Oct 08, 2007Version comment

XYSeriesCollectorFunction Example

    <expression class="org.pentaho.plugin.jfreereport.reportcharts.XYSeriesCollectorFunction" name="chartDataSource">
      <properties>
        <property name="seriesColumn">true</property>
        <property name="seriesName[0]">PRODUCTNAME</property>
        <property name="xValueColumn[0]">AVERAGE_MSRP</property>
        <property name="yValueColumn[0]">AVERAGE_BUYPRICE</property>
        <property name="group">PRODUCTNAME</property>
        <property name="resetGroup">PRODUCTLINE</property>
        <property name="summaryOnly">false</property>
      </properties>
    </expression>

TimeSeriesCollectorFunction Example

     <expression class="org.pentaho.plugin.jfreereport.reportcharts.TimeSeriesCollectorFunction" name="chartDataSource">
      <properties>
        <property name="timeValueColumn[0]">ORDERDATE</property>
        <property name="seriesName[0]">PRODUCTLINE</property>
        <property name="seriesColumn">true</property>
        <property name="valueColumn[0]">SOLD_PRICE</property>
        <property name="summaryOnly">false</property>
        <property name="domainPeriodType">Day</property>
      </properties>
    </expression>

XYZSeriesCollectorFunction Example

    <expression class="org.pentaho.plugin.jfreereport.reportcharts.XYZSeriesCollectorFunction" name="chartDataSource">
      <properties>
        <property name="seriesColumn">true</property>
        <property name="seriesName[0]">DEPARTMENT</property>
        <property name="xValueColumn[0]">ACTUAL</property>
        <property name="yValueColumn[0]">BUDGET</property>
        <property name="zValueColumn[0]">VARIANCE</property>
        <property name="summaryOnly">false</property>
      </properties>
    </expression>