<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 4.3.0.v201306041519 Build &lt;4.3.0.v20130613-1152></property>
    <property name="units">in</property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">96</property>
    <parameters>
        <scalar-parameter name="product_name" id="98">
            <property name="valueType">dynamic</property>
            <property name="isRequired">true</property>
            <property name="dataSetName">set_product_name</property>
            <expression name="valueExpr" type="javascript">dataSetRow["products_name"]</expression>
            <expression name="labelExpr" type="javascript">dataSetRow["products_name"]</expression>
            <expression name="sortByColumn">dataSetRow["products_name"]</expression>
            <property name="sortDirection">asc</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">18th Century Vintage Horse Carriage</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">list-box</property>
            <property name="mustMatch">true</property>
            <property name="fixedOrder">false</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
    </parameters>
    <data-sources>
        <oda-data-source extensionID="bpm.metadata.birt.oda.runtime" name="sourceSample" id="7">
            <list-property name="privateDriverProperties">
                <ex-property>
                    <name>CONNECTION_NAME</name>
                    <value>Default</value>
                </ex-property>
            </list-property>
            <property name="USER">system</property>
            <property name="PASSWORD">system</property>
            <property name="DIRECTORY_ITEM_ID">1</property>
            <property name="BUSINESS_MODEL">Retail</property>
            <property name="BUSINESS_PACKAGE">Sales</property>
            <property name="GROUP_NAME">System</property>
            <property name="REPOSITORY_ID">1</property>
            <property name="VANILLA_URL">http://localhost:8080/VanillaRuntime</property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="bpm.metadata.birt.oda.runtime.dataSet" name="setbestsellers_details" id="97">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">products_name</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">products_name</text-property>
                    <text-property name="heading">products_name</text-property>
                </structure>
                <structure>
                    <property name="columnName">orderfact_priceeach</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">orderfact_priceeach</text-property>
                    <text-property name="heading">orderfact_priceeach</text-property>
                </structure>
                <structure>
                    <property name="columnName">orderfact_totalprice</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">orderfact_totalprice</text-property>
                    <text-property name="heading">orderfact_totalprice</text-property>
                </structure>
                <structure>
                    <property name="columnName">timeline_year_nb</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">timeline_year_nb</text-property>
                    <text-property name="heading">timeline_year_nb</text-property>
                </structure>
                <structure>
                    <property name="columnName">timeline_month_nb</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">timeline_month_nb</text-property>
                    <text-property name="heading">timeline_month_nb</text-property>
                </structure>
                <structure>
                    <property name="columnName">timeline_day_nb</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">timeline_day_nb</text-property>
                    <text-property name="heading">timeline_day_nb</text-property>
                </structure>
                <structure>
                    <property name="columnName">timeline_month_name</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">timeline_month_name</text-property>
                    <text-property name="heading">timeline_month_name</text-property>
                </structure>
                <structure>
                    <property name="columnName">timeline_day_name</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">timeline_day_name</text-property>
                    <text-property name="heading">timeline_day_name</text-property>
                </structure>
                <structure>
                    <property name="columnName">timeline.day_in_week</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">day_in_week</text-property>
                    <text-property name="heading">day_in_week</text-property>
                </structure>
                <structure>
                    <property name="columnName">orderfact_quantityordered</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">orderfact_quantityordered</text-property>
                    <text-property name="heading">orderfact_quantityordered</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">promptOnproducts_name</property>
                    <property name="paramName">product_name</property>
                    <property name="nativeName">promptOnproducts_name</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">products_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">orderfact_priceeach</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">orderfact_totalprice</property>
                        <property name="dataType">float</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">timeline_year_nb</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">timeline_month_nb</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">timeline_day_nb</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">timeline_month_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">timeline_day_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">9</property>
                        <property name="name">timeline.day_in_week</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">10</property>
                        <property name="name">orderfact_quantityordered</property>
                        <property name="dataType">float</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">sourceSample</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">products_name</property>
                    <property name="nativeName">products_name</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">orderfact_priceeach</property>
                    <property name="nativeName">orderfact_priceeach</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">orderfact_totalprice</property>
                    <property name="nativeName">orderfact_totalprice</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">timeline_year_nb</property>
                    <property name="nativeName">timeline_year_nb</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">timeline_month_nb</property>
                    <property name="nativeName">timeline_month_nb</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">timeline_day_nb</property>
                    <property name="nativeName">timeline_day_nb</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">timeline_month_name</property>
                    <property name="nativeName">timeline_month_name</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">timeline_day_name</property>
                    <property name="nativeName">timeline_day_name</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">9</property>
                    <property name="name">timeline.day_in_week</property>
                    <property name="nativeName">timeline.day_in_week</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
                <structure>
                    <property name="position">10</property>
                    <property name="name">orderfact_quantityordered</property>
                    <property name="nativeName">orderfact_quantityordered</property>
                    <property name="dataType">float</property>
                    <property name="nativeDataType">8</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[<freeMetaDataQuery>
     <sqlQuery>
     <distinct>false</distinct>
     <limit>0</limit>
         <select>
             <dataStreamElementName>products_name</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>orderfact_priceeach</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>orderfact_totalprice</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline_year_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline_month_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline_day_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline_month_name</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline_day_name</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline.day_in_week</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <agg>
             <function>SUM</function>
             <formula>false</formula>
             <col>orderfact_quantityordered</col>
             <dataStreamName>orderfact</dataStreamName>
             <outputName>orderfact_quantityordered</outputName>
         </agg>
         <orderBy>
             <dataStreamElementName>products_name</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>orderfact_quantityordered</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>orderfact_priceeach</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>orderfact_totalprice</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline_year_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline_month_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline_day_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline_month_name</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline_day_name</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline.day_in_week</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <additionalResource>
++++++++%3Cprompt%3E%0A++++++++++++%3Cname%3EpromptOnproducts_name%3C%2Fname%3E%0A++++++++++++%3Cquestion%3Enull%3C%2Fquestion%3E%0A++++++++++++%3Coperator%3E%3D%3C%2Foperator%3E%0A++++++++++++%3CoriginDataStream%3Eproducts%3C%2ForiginDataStream%3E%0A++++++++++++%3CoriginDataStreamElement%3Eproducts_name%3C%2ForiginDataStreamElement%3E%0A++++++++++++%3CdestinationDataStream%3Eproducts%3C%2FdestinationDataStream%3E%0A++++++++++++%3CdestinationDataStreamElement%3Eproducts_name%3C%2FdestinationDataStreamElement%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2Fprompt%3E%0A>
         </additionalResource>
     </sqlQuery>
</freeMetaDataQuery>
]]></xml-property>
            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
  <Version>2.0</Version>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name>promptOnproducts_name</design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>-1</design:precision>
          <design:scale>-1</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>products_name</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>products_name</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>products_name</design:label>
            <design:formattingHints>
              <design:displaySize>8</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>orderfact_priceeach</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>orderfact_priceeach</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>orderfact_priceeach</design:label>
            <design:formattingHints>
              <design:displaySize>8</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>orderfact_totalprice</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>orderfact_totalprice</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>orderfact_totalprice</design:label>
            <design:formattingHints>
              <design:displaySize>8</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>timeline_year_nb</design:name>
              <design:position>4</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>timeline_year_nb</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>timeline_year_nb</design:label>
            <design:formattingHints>
              <design:displaySize>8</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>timeline_month_nb</design:name>
              <design:position>5</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>timeline_month_nb</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>timeline_month_nb</design:label>
            <design:formattingHints>
              <design:displaySize>8</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>timeline_day_nb</design:name>
              <design:position>6</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>timeline_day_nb</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>timeline_day_nb</design:label>
            <design:formattingHints>
              <design:displaySize>8</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>orderfact_quantityordered</design:name>
              <design:position>7</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>8</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>orderfact_quantityordered</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>orderfact_quantityordered</design:label>
            <design:formattingHints>
              <design:displaySize>8</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="bpm.metadata.birt.oda.runtime.dataSet" name="set_product_name" id="165">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">products_name</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">products_name</text-property>
                    <text-property name="heading">products_name</text-property>
                </structure>
            </list-property>
            <list-property name="parameters"/>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">products_name</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">sourceSample</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">products_name</property>
                    <property name="nativeName">products_name</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[<freeMetaDataQuery>
     <sqlQuery>
     <distinct>true</distinct>
     <limit>0</limit>
         <select>
             <dataStreamElementName>products_name</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
         </select>
         <orderBy>
             <dataStreamElementName>products_name</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
          </orderBy>
     </sqlQuery>
</freeMetaDataQuery>
]]></xml-property>
            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
  <Version>2.0</Version>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>products_name</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>products_name</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>products_name</design:label>
            <design:formattingHints>
              <design:displaySize>8</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="bpm.metadata.birt.oda.runtime.dataSet" name="set_information" id="237">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">products_name</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">products_name</text-property>
                    <text-property name="heading">products_name</text-property>
                </structure>
                <structure>
                    <property name="columnName">products_description</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">products_description</text-property>
                    <text-property name="heading">products_description</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">Pmp_products_name</property>
                    <property name="paramName">product_name</property>
                    <property name="nativeName">Pmp_products_name</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">1</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">products_name</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">products_description</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">sourceSample</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">products_name</property>
                    <property name="nativeName">products_name</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">products_description</property>
                    <property name="nativeName">products_description</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">-1</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[<freeMetaDataQuery>
     <sqlQuery>
     <distinct>false</distinct>
     <limit>0</limit>
         <select>
             <dataStreamElementName>products_name</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>products_description</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
         </select>
         <orderBy>
             <dataStreamElementName>products_name</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>products_description</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
          </orderBy>
         <additionalResource>
++++++++%3Cprompt%3E%0A++++++++++++%3Cname%3EPmp_products_name%3C%2Fname%3E%0A++++++++++++%3Cquestion%3Enull%3C%2Fquestion%3E%0A++++++++++++%3Coperator%3E%3D%3C%2Foperator%3E%0A++++++++++++%3CoriginDataStream%3Eproducts%3C%2ForiginDataStream%3E%0A++++++++++++%3CoriginDataStreamElement%3Eproducts_name%3C%2ForiginDataStreamElement%3E%0A++++++++++++%3CdestinationDataStream%3Eproducts%3C%2FdestinationDataStream%3E%0A++++++++++++%3CdestinationDataStreamElement%3Eproducts_name%3C%2FdestinationDataStreamElement%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2Fprompt%3E%0A>
         </additionalResource>
     </sqlQuery>
</freeMetaDataQuery>
]]></xml-property>
            <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
  <Version>2.0</Version>
  <DataSetParameters>
    <parameter>
      <design:ParameterDefinition>
        <design:inOutMode>In</design:inOutMode>
        <design:attributes>
          <design:identifier>
            <design:name>Pmp_products_name</design:name>
            <design:position>1</design:position>
          </design:identifier>
          <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
          <design:precision>-1</design:precision>
          <design:scale>-1</design:scale>
          <design:nullability>Unknown</design:nullability>
        </design:attributes>
      </design:ParameterDefinition>
    </parameter>
  </DataSetParameters>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>products_name</design:name>
              <design:position>1</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>products_name</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>products_name</design:label>
            <design:formattingHints>
              <design:displaySize>8</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>products_description</design:name>
              <design:position>2</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-1</design:nativeDataTypeCode>
            <design:precision>-1</design:precision>
            <design:scale>-1</design:scale>
            <design:nullability>Unknown</design:nullability>
            <design:uiHints>
              <design:displayName>products_description</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>products_description</design:label>
            <design:formattingHints>
              <design:displaySize>8</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria/>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-property>
        </oda-data-set>
    </data-sets>
    <styles>
        <style name="report" id="4">
            <property name="fontFamily">sans-serif</property>
            <property name="fontSize">10pt</property>
        </style>
        <style name="crosstab-cell" id="5">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
        <style name="crosstab" id="6">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
    </styles>
    <page-setup>
        <simple-master-page name="Simple MasterPage" id="2">
            <property name="headerHeight">1.1in</property>
            <page-header>
                <grid id="223">
                    <property name="width">7.875in</property>
                    <column id="119">
                        <property name="width">2.1354166666666665in</property>
                    </column>
                    <column id="224">
                        <property name="width">3.1979166666666665in</property>
                    </column>
                    <column id="121">
                        <property name="width">2.5416666666666665in</property>
                    </column>
                    <row id="122">
                        <cell id="123">
                            <image id="127">
                                <property name="height">0.71875in</property>
                                <property name="width">2.0208333333333335in</property>
                                <property name="source">embed</property>
                                <property name="imageName">BPMConseil_Logo.jpg</property>
				    <list-property name="action">
                                    <structure>
                                        <property name="linkType">hyperlink</property>
                                        <expression name="uri" type="constant">http://www.bpm-conseil.com</expression>
                                        <property name="targetWindow">_blank</property>
                                    </structure>
                                </list-property>
                            </image>
                        </cell>
                        <cell id="124">
                            <property name="verticalAlign">middle</property>
                            <text-data id="230">
                                <property name="fontFamily">"Calibri"</property>
                                <property name="fontSize">14pt</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#3368B7</property>
                                <property name="textAlign">center</property>
                                <expression name="valueExpr">"Bestsellers Details&lt;br>Product Name : " +params["product_name"].value</expression>
                                <property name="contentType">html</property>
                            </text-data>
                        </cell>
                        <cell id="125">
                            <property name="verticalAlign">middle</property>
                            <image id="24">
                                <property name="height">0.6875in</property>
                                <property name="width">2.4375in</property>
                                <property name="source">embed</property>
                                <property name="imageName">vanilla_lettering_256.png</property>
                            </image>
                        </cell>
                    </row>
                </grid>
            </page-header>
            <page-footer>
                <grid id="239">
                    <property name="width">7.84375in</property>
                    <column id="240">
                        <property name="width">1.40625in</property>
                    </column>
                    <column id="241">
                        <property name="width">5.510416666666667in</property>
                    </column>
                    <column id="102">
                        <property name="width">0.9270833333333334in</property>
                    </column>
                    <row id="242">
                        <cell id="104">
                            <text id="3">
                                <property name="fontFamily">"Calibri"</property>
                                <property name="color">#3368B7</property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[<value-of>new Date()</value-of><br>]]></text-property>
                            </text>
                        </cell>
                        <cell id="243">
                            <text id="128">
                                <property name="fontFamily">"Calibri"</property>
                                <property name="color">#3368B7</property>
                                <property name="textAlign">center</property>
                                <property name="contentType">html</property>
                                <text-property name="content"><![CDATA[Powered by Vanilla<BR>For more informations, please contact <a href="http://www.bpm-conseil.com">www.bpm-conseil.com</a>]]></text-property>
                            </text>
                        </cell>
                        <cell id="106">
                            <grid id="107">
                                <property name="fontFamily">"Calibri"</property>
                                <column id="108"/>
                                <column id="109"/>
                                <column id="110"/>
                                <row id="111">
                                    <cell id="112">
                                        <auto-text id="113">
                                            <property name="type">page-number</property>
                                        </auto-text>
                                    </cell>
                                    <cell id="114">
                                        <text id="115">
                                            <property name="contentType">plain</property>
                                            <text-property name="content"><![CDATA[/]]></text-property>
                                        </text>
                                    </cell>
                                    <cell id="116">
                                        <auto-text id="117">
                                            <property name="type">total-page</property>
                                        </auto-text>
                                    </cell>
                                </row>
                            </grid>
                        </cell>
                    </row>
                </grid>
            </page-footer>
        </simple-master-page>
    </page-setup>
    <body>
        <label id="236">
            <property name="backgroundColor">#3368B7</property>
            <property name="fontFamily">"Calibri"</property>
            <property name="fontWeight">bold</property>
            <property name="color">#FFFFFF</property>
            <property name="marginTop">20pt</property>
            <text-property name="text">Product Description</text-property>
        </label>
        <data id="238">
            <property name="fontFamily">"Calibri"</property>
            <property name="marginTop">5pt</property>
            <property name="dataSet">set_information</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">products_description</property>
                    <text-property name="displayName">products_description</text-property>
                    <expression name="expression" type="javascript">dataSetRow["products_description"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <property name="resultSetColumn">products_description</property>
        </data>
        <table id="99">
            <property name="marginTop">20pt</property>
            <property name="width">7.947916666666667in</property>
            <property name="dataSet">setbestsellers_details</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">products_name</property>
                    <text-property name="displayName">products_name</text-property>
                    <expression name="expression" type="javascript">dataSetRow["products_name"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">orderfact_priceeach</property>
                    <text-property name="displayName">orderfact_priceeach</text-property>
                    <expression name="expression" type="javascript">dataSetRow["orderfact_priceeach"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">orderfact_totalprice</property>
                    <text-property name="displayName">orderfact_totalprice</text-property>
                    <expression name="expression" type="javascript">dataSetRow["orderfact_totalprice"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">timeline_year_nb</property>
                    <text-property name="displayName">timeline_year_nb</text-property>
                    <expression name="expression" type="javascript">dataSetRow["timeline_year_nb"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">timeline_month_nb</property>
                    <text-property name="displayName">timeline_month_nb</text-property>
                    <expression name="expression" type="javascript">dataSetRow["timeline_month_nb"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">timeline_day_nb</property>
                    <text-property name="displayName">timeline_day_nb</text-property>
                    <expression name="expression" type="javascript">dataSetRow["timeline_day_nb"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">orderfact_quantityordered</property>
                    <text-property name="displayName">orderfact_quantityordered</text-property>
                    <expression name="expression" type="javascript">dataSetRow["orderfact_quantityordered"]</expression>
                    <property name="dataType">float</property>
                </structure>
                <structure>
                    <property name="name">Date</property>
                    <expression name="expression" type="javascript">row["timeline_year_nb"] +"-"+row["timeline_month_nb"]+"-"+row["timeline_day_nb"]</expression>
                    <property name="dataType">string</property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">agg_sum_by_date</property>
                    <property name="dataType">integer</property>
                    <simple-property-list name="aggregateOn">
                        <value>Year</value>
                    </simple-property-list>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["orderfact_quantityordered"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">timeline_month_name</property>
                    <text-property name="displayName">timeline_month_name</text-property>
                    <expression name="expression" type="javascript">dataSetRow["timeline_month_name"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">timeline_day_name</property>
                    <text-property name="displayName">timeline_day_name</text-property>
                    <expression name="expression" type="javascript">dataSetRow["timeline_day_name"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">agg_sum_by_month</property>
                    <property name="dataType">integer</property>
                    <simple-property-list name="aggregateOn">
                        <value>Month</value>
                    </simple-property-list>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["orderfact_quantityordered"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">agg_sum_by_day</property>
                    <property name="dataType">integer</property>
                    <simple-property-list name="aggregateOn">
                        <value>Day</value>
                    </simple-property-list>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["orderfact_quantityordered"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">timeline.day_in_week</property>
                    <text-property name="displayName">day_in_week</text-property>
                    <expression name="expression" type="javascript">dataSetRow["timeline.day_in_week"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">agg_sum_total</property>
                    <property name="dataType">integer</property>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["orderfact_quantityordered"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
            </list-property>
            <column id="138">
                <property name="width">2.65625in</property>
            </column>
            <column id="139">
                <property name="width">4.15625in</property>
            </column>
            <column id="140">
                <property name="width">1.1354166666666667in</property>
            </column>
            <header>
                <row id="100">
                    <property name="backgroundColor">#3368B7</property>
                    <property name="fontFamily">"Calibri"</property>
                    <cell id="101">
                        <label id="227">
                            <property name="fontWeight">bold</property>
                            <property name="color">#FFFFFF</property>
                            <property name="textAlign">left</property>
                            <text-property name="text">Year/Month/Day</text-property>
                        </label>
                    </cell>
                    <cell id="103"/>
                    <cell id="105">
                        <label id="229">
                            <property name="fontWeight">bold</property>
                            <property name="color">#FFFFFF</property>
                            <property name="textAlign">right</property>
                            <text-property name="text">Quantity </text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <group id="145">
                <property name="groupName">Year</property>
                <expression name="keyExpr" type="javascript">row["timeline_year_nb"]</expression>
                <property name="hideDetail">false</property>
                <list-property name="sort">
                    <structure>
                        <expression name="key" type="javascript">row["timeline_year_nb"]</expression>
                        <property name="direction">desc</property>
                        <property name="strength">-1</property>
                    </structure>
                </list-property>
                <header>
                    <row id="146">
                        <property name="backgroundColor">#3368B7</property>
                        <property name="fontFamily">"Calibri"</property>
                        <property name="fontWeight">bold</property>
                        <property name="color">#FFFFFF</property>
                        <cell id="147">
                            <data id="218">
                                <property name="resultSetColumn">timeline_year_nb</property>
                            </data>
                        </cell>
                        <cell id="148"/>
                        <cell id="149">
                            <data id="164">
                                <property name="textAlign">right</property>
                                <property name="resultSetColumn">agg_sum_by_date</property>
                            </data>
                        </cell>
                    </row>
                </header>
                <footer>
                    <row id="154">
                        <cell id="155"/>
                        <cell id="156"/>
                        <cell id="157"/>
                    </row>
                </footer>
            </group>
            <group id="195">
                <property name="groupName">Month</property>
                <expression name="keyExpr" type="javascript">row["timeline_month_name"]</expression>
                <structure name="toc">
                    <expression name="expressionValue" type="javascript">row["timeline_month_name"]</expression>
                </structure>
                <property name="hideDetail">false</property>
                <list-property name="sort">
                    <structure>
                        <expression name="key" type="javascript">row["timeline_month_nb"]</expression>
                        <property name="direction">asc</property>
                        <property name="strength">-1</property>
                    </structure>
                </list-property>
                <header>
                    <row id="196">
                        <property name="backgroundColor">#808080</property>
                        <property name="fontWeight">bold</property>
                        <property name="color">#FFFFFF</property>
                        <cell id="197">
                            <data id="204">
                                <property name="fontFamily">"Calibri"</property>
                                <property name="paddingLeft">10pt</property>
                                <property name="resultSetColumn">timeline_month_name</property>
                            </data>
                        </cell>
                        <cell id="198"/>
                        <cell id="199">
                            <data id="215">
                                <property name="fontFamily">"Calibri"</property>
                                <property name="textAlign">right</property>
                                <property name="resultSetColumn">agg_sum_by_month</property>
                            </data>
                        </cell>
                    </row>
                </header>
                <footer>
                    <row id="200">
                        <cell id="201"/>
                        <cell id="202"/>
                        <cell id="203"/>
                    </row>
                </footer>
            </group>
            <group id="205">
                <property name="groupName">Day</property>
                <expression name="keyExpr" type="javascript">row["timeline_day_name"]</expression>
                <structure name="toc">
                    <expression name="expressionValue" type="javascript">row["timeline_day_name"]</expression>
                </structure>
                <property name="hideDetail">false</property>
                <list-property name="sort">
                    <structure>
                        <expression name="key" type="javascript">row["timeline.day_in_week"]</expression>
                        <property name="direction">asc</property>
                        <property name="strength">-1</property>
                    </structure>
                </list-property>
                <header>
                    <row id="206">
                        <property name="backgroundColor">#FFFFFF</property>
                        <property name="fontFamily">"Calibri"</property>
                        <property name="fontWeight">bold</property>
                        <property name="color">#000000</property>
                        <cell id="207">
                            <data id="214">
                                <property name="paddingLeft">15pt</property>
                                <property name="resultSetColumn">timeline_day_name</property>
                            </data>
                        </cell>
                        <cell id="208"/>
                        <cell id="209">
                            <data id="216">
                                <property name="fontFamily">"Calibri"</property>
                                <property name="textAlign">right</property>
                                <property name="resultSetColumn">agg_sum_by_day</property>
                            </data>
                        </cell>
                    </row>
                </header>
                <footer>
                    <row id="210">
                        <cell id="211"/>
                        <cell id="212"/>
                        <cell id="213"/>
                    </row>
                </footer>
            </group>
            <footer>
                <row id="130">
                    <cell id="131"/>
                    <cell id="132">
                        <label id="225">
                            <property name="backgroundColor">#FFFFFF</property>
                            <property name="fontFamily">"Calibri"</property>
                            <property name="fontWeight">bold</property>
                            <property name="color">#000000</property>
                            <property name="textAlign">right</property>
                            <text-property name="text">Total :</text-property>
                        </label>
                    </cell>
                    <cell id="133">
                        <data id="226">
                            <property name="fontFamily">"Calibri"</property>
                            <property name="fontWeight">bold</property>
                            <property name="textAlign">right</property>
                            <property name="resultSetColumn">agg_sum_total</property>
                        </data>
                    </cell>
                </row>
            </footer>
        </table>
    </body>
    <list-property name="images">
        <structure>
            <property name="name">BPM_Vanilla_120.png</property>
            <property name="type">image/png</property>
            <property name="data">
                [encoded data, 19868 characters]
                HvcfbxIeoAAAAABJRU5ErkJggg==
</property>
        </structure>
        <structure>
            <property name="name">vanilla_lettering_256.png</property>
            <property name="type">image/png</property>
            <property name="data">
                [encoded data, 54691 characters]
                RERERDRV//8Aedk9ResocH8AAAAASUVORK5CYII=
</property>
        </structure>
        <structure>
            <property name="name">1956_Porsche_356A_Coupe.jpg</property>
            <property name="data">
                [encoded data, 55641 characters]
</property>
        </structure>
        <structure>
            <property name="name">1992_Ferrari_360_Spider_red.jpg</property>
            <property name="data">
                [encoded data, 11526 characters]
                EK0pIKclAiwAaqSVY2KIDJBHgyMR4gBOjSS8rKZMDAD/2Q==
</property>
        </structure>
        <structure>
            <property name="name">BPMConseil_Logo.jpg</property>
            <property name="data">
                [encoded data, 137230 characters]
</property>
        </structure>
    </list-property>
</report>