
<dictionary version="v2.0" name="dictionnaire_SalesDashboard">
  <palette name="newColorsPalette"/>
  <dataSource>
    <name>sourceSample</name>
    <odaExtensionDataSourceId>bpm.metadata.birt.oda.runtime</odaExtensionDataSourceId>
    <odaExtensionId>bpm.metadata.birt.oda.runtime</odaExtensionId>
    <odaDriverClassName>bpm.metadata.birt.oda.runtime.impl.Driver</odaDriverClassName>
    <publicProperty name="BUSINESS_PACKAGE">Sales</publicProperty>
    <publicProperty name="BUSINESS_MODEL">Retail</publicProperty>
    <publicProperty name="GROUP_NAME">System</publicProperty>
    <publicProperty name="DIRECTORY_ITEM_ID">1</publicProperty>
    <publicProperty name="USER">system</publicProperty>
    <publicProperty name="REPOSITORY_ID">1</publicProperty>
    <publicProperty name="VANILLA_URL">http://localhost:8080/VanillaRuntime</publicProperty>
    <publicProperty name="PASSWORD">system</publicProperty>
    <privateProperty name="CONNECTION_NAME">Default</privateProperty>
  </dataSource>
  <dataSource>
    <name>chartlist_datasource</name>
    <odaExtensionDataSourceId>bpm.inlinedatas.oda.driver.runtime</odaExtensionDataSourceId>
    <odaExtensionId>bpm.inlinedatas.oda.driver.runtime</odaExtensionId>
    <odaDriverClassName>bpm.inlinedatas.oda.driver.runtime.impl.Driver</odaDriverClassName>
    <publicProperty name="P_COLUMN_TYPE">String;String;</publicProperty>
    <publicProperty name="P_COLUMN_VALUES">Area2D.swf;Area2D;Bar2D.swf;Bar2D;Column2D.swf;Column2D;Column3D.swf;Column3D;Line.swf;Line;Pie2D.swf;Pie2D;Pie3D.swf;Pie3D;Spline.swf;Spline;</publicProperty>
    <publicProperty name="P_COLUMN_NAMES">value;label;</publicProperty>
    <publicProperty name="P_COLUMN_NUMBER">2</publicProperty>
  </dataSource>
  <dataSource>
    <name>ds_jdbc</name>
    <odaExtensionDataSourceId>org.eclipse.birt.report.data.oda.jdbc</odaExtensionDataSourceId>
    <odaExtensionId>org.eclipse.birt.report.data.oda.jdbc</odaExtensionId>
    <odaDriverClassName>org.eclipse.birt.report.data.oda.jdbc.OdaJdbcDriver</odaDriverClassName>
    <publicProperty name="odaJndiName"></publicProperty>
    <publicProperty name="odaURL">jdbc:h2:./h2/sampledata;AUTO_SERVER=TRUE;DATABASE_TO_UPPER=FALSE</publicProperty>
    <publicProperty name="odaDriverClass">org.h2.Driver</publicProperty>
    <publicProperty name="odaPassword">biplatform</publicProperty>
    <publicProperty name="odaUser">biplatform</publicProperty>
    <privateProperty name="disabledMetadataBidiFormatStr"></privateProperty>
    <privateProperty name="disabledContentBidiFormatStr"></privateProperty>
    <privateProperty name="contentBidiFormatStr">ILYNN</privateProperty>
    <privateProperty name="metadataBidiFormatStr">ILYNN</privateProperty>
  </dataSource>
  <dataSet>
    <name>O_set_Countries</name>
    <dataSourceName>sourceSample</dataSourceName>
    <odaExtensionDataSetId>bpm.metadata.birt.oda.runtime.dataSet</odaExtensionDataSetId>
    <odaExtensionDataSourceId>bpm.metadata.birt.oda.runtime</odaExtensionDataSourceId>
    <queryText><![CDATA[
			<freeMetaDataQuery>
     <sqlQuery>
     <distinct>false</distinct>
     <limit>0</limit>
         <select>
             <dataStreamElementName>customers_country</dataStreamElementName>
             <dataStreamName>customers</dataStreamName>
         </select>
         <agg>
             <function>SUM</function>
             <formula>true</formula>
             <col>ROUND(orderfact.totalprice/1000,1)</col>
             <dataStreamName>orderfact</dataStreamName>
             <outputName>orderfact_totalprice/1000</outputName>
         </agg>
         <orderBy>
             <dataStreamElementName>customers_country</dataStreamElementName>
             <dataStreamName>customers</dataStreamName>
          </orderBy>
         <additionalResource>
++++++++%3Cprompt%3E%0A++++++++++++%3Cname%3EO_Date_From%3C%2Fname%3E%0A++++++++++++%3Cquestion%3Enull%3C%2Fquestion%3E%0A++++++++++++%3Coperator%3E%26gt%3B%3D%3C%2Foperator%3E%0A++++++++++++%3CoriginDataStream%3Etimeline%3C%2ForiginDataStream%3E%0A++++++++++++%3CoriginDataStreamElement%3Etimeline_id%3C%2ForiginDataStreamElement%3E%0A++++++++++++%3CdestinationDataStream%3Etimeline%3C%2FdestinationDataStream%3E%0A++++++++++++%3CdestinationDataStreamElement%3Etimeline_id%3C%2FdestinationDataStreamElement%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2Fprompt%3E%0A>
         </additionalResource>
         <additionalResource>
++++++++%3Cprompt%3E%0A++++++++++++%3Cname%3EO_Date_End%3C%2Fname%3E%0A++++++++++++%3Cquestion%3Enull%3C%2Fquestion%3E%0A++++++++++++%3Coperator%3E%26lt%3B%3D%3C%2Foperator%3E%0A++++++++++++%3CoriginDataStream%3Etimeline%3C%2ForiginDataStream%3E%0A++++++++++++%3CoriginDataStreamElement%3Etimeline_id%3C%2ForiginDataStreamElement%3E%0A++++++++++++%3CdestinationDataStream%3Etimeline%3C%2FdestinationDataStream%3E%0A++++++++++++%3CdestinationDataStreamElement%3Etimeline_id%3C%2FdestinationDataStreamElement%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2Fprompt%3E%0A>
         </additionalResource>
     </sqlQuery>
</freeMetaDataQuery>
]]></queryText>
    <parameters>
      <parameter name="O_Date_From" label="O_Date_From" position="1"/>
      <parameter name="O_Date_End" label="O_Date_End" position="2"/>
    </parameters>
  </dataSet>
  <dataSet>
    <name>O_set_Cities</name>
    <dataSourceName>sourceSample</dataSourceName>
    <odaExtensionDataSetId>bpm.metadata.birt.oda.runtime.dataSet</odaExtensionDataSetId>
    <odaExtensionDataSourceId>bpm.metadata.birt.oda.runtime</odaExtensionDataSourceId>
    <queryText><![CDATA[
			<freeMetaDataQuery>
     <sqlQuery>
     <distinct>false</distinct>
     <limit>0</limit>
         <select>
             <dataStreamElementName>customers_city</dataStreamElementName>
             <dataStreamName>customers</dataStreamName>
         </select>
         <agg>
             <function>SUM</function>
             <formula>true</formula>
             <col>ROUND(orderfact.totalprice/1000,1)</col>
             <dataStreamName></dataStreamName>
             <outputName>orderfact_totalprice/1000</outputName>
         </agg>
         <orderBy>
             <dataStreamElementName>customers_city</dataStreamElementName>
             <dataStreamName>customers</dataStreamName>
          </orderBy>
         <additionalResource>
++++++++%3Cprompt%3E%0A++++++++++++%3Cname%3EO_Date_From%3C%2Fname%3E%0A++++++++++++%3Cquestion%3Enull%3C%2Fquestion%3E%0A++++++++++++%3Coperator%3E%26gt%3B%3D%3C%2Foperator%3E%0A++++++++++++%3CoriginDataStream%3Etimeline%3C%2ForiginDataStream%3E%0A++++++++++++%3CoriginDataStreamElement%3Etimeline_id%3C%2ForiginDataStreamElement%3E%0A++++++++++++%3CdestinationDataStream%3Etimeline%3C%2FdestinationDataStream%3E%0A++++++++++++%3CdestinationDataStreamElement%3Etimeline_id%3C%2FdestinationDataStreamElement%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2Fprompt%3E%0A>
         </additionalResource>
         <additionalResource>
++++++++%3Cprompt%3E%0A++++++++++++%3Cname%3EO_Date_End%3C%2Fname%3E%0A++++++++++++%3Cquestion%3Enull%3C%2Fquestion%3E%0A++++++++++++%3Coperator%3E%26lt%3B%3D%3C%2Foperator%3E%0A++++++++++++%3CoriginDataStream%3Etimeline%3C%2ForiginDataStream%3E%0A++++++++++++%3CoriginDataStreamElement%3Etimeline_id%3C%2ForiginDataStreamElement%3E%0A++++++++++++%3CdestinationDataStream%3Etimeline%3C%2FdestinationDataStream%3E%0A++++++++++++%3CdestinationDataStreamElement%3Etimeline_id%3C%2FdestinationDataStreamElement%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2Fprompt%3E%0A>
         </additionalResource>
     </sqlQuery>
</freeMetaDataQuery>
]]></queryText>
    <parameters>
      <parameter name="O_Date_From" label="O_Date_From" position="1"/>
      <parameter name="O_Date_End" label="O_Date_End" position="2"/>
    </parameters>
  </dataSet>
  <dataSet>
    <name>P_set_Years</name>
    <dataSourceName>sourceSample</dataSourceName>
    <odaExtensionDataSetId>bpm.metadata.birt.oda.runtime.dataSet</odaExtensionDataSetId>
    <odaExtensionDataSourceId>bpm.metadata.birt.oda.runtime</odaExtensionDataSourceId>
    <queryText><![CDATA[
			<freeMetaDataQuery>
     <sqlQuery>
     <distinct>true</distinct>
     <limit>0</limit>
         <select>
             <dataStreamElementName>timeline_year_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <orderBy>
             <dataStreamElementName>timeline_year_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
     </sqlQuery>
</freeMetaDataQuery>
]]></queryText>
    <parameters/>
  </dataSet>
  <dataSet>
    <name>P_set_Lines</name>
    <dataSourceName>sourceSample</dataSourceName>
    <odaExtensionDataSetId>bpm.metadata.birt.oda.runtime.dataSet</odaExtensionDataSetId>
    <odaExtensionDataSourceId>bpm.metadata.birt.oda.runtime</odaExtensionDataSourceId>
    <queryText><![CDATA[
			<freeMetaDataQuery>
     <sqlQuery>
     <distinct>false</distinct>
     <limit>0</limit>
         <select>
             <dataStreamElementName>products_line</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
         </select>
         <prompt>Pmp_Order_Year</prompt>
         <agg>
             <function>SUM</function>
             <formula>false</formula>
             <col>orderfact_totalprice</col>
             <dataStreamName>orderfact</dataStreamName>
             <outputName>orderfact_totalprice</outputName>
         </agg>
         <orderBy>
             <dataStreamElementName>products_line</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>orderfact_totalprice</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
          </orderBy>
     </sqlQuery>
</freeMetaDataQuery>
]]></queryText>
    <parameters>
      <parameter name="Pmp_Order_Year" label="Pmp_Order_Year" position="1"/>
    </parameters>
  </dataSet>
  <dataSet>
    <name>P_set_Products_5</name>
    <dataSourceName>sourceSample</dataSourceName>
    <odaExtensionDataSetId>bpm.metadata.birt.oda.runtime.dataSet</odaExtensionDataSetId>
    <odaExtensionDataSourceId>bpm.metadata.birt.oda.runtime</odaExtensionDataSourceId>
    <queryText><![CDATA[
			<freeMetaDataQuery>
     <sqlQuery>
     <distinct>false</distinct>
     <limit>0</limit>
         <select>
             <dataStreamElementName>products_name</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
         </select>
         <prompt>Pmp_Order_Year</prompt>
         <prompt>Pmp_Product_Line</prompt>
         <agg>
             <function>SUM</function>
             <formula>false</formula>
             <col>orderfact_totalprice</col>
             <dataStreamName>orderfact</dataStreamName>
             <outputName>orderfact_totalprice</outputName>
         </agg>
         <orderBy>
             <dataStreamElementName>products_name</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>orderfact_totalprice</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
          </orderBy>
     </sqlQuery>
</freeMetaDataQuery>
]]></queryText>
    <parameters>
      <parameter name="Pmp_Order_Year" label="Pmp_Order_Year" position="1"/>
      <parameter name="Pmp_Product_Line" label="Pmp_Product_Line" position="2"/>
    </parameters>
  </dataSet>
  <dataSet>
    <name>P_ListChart</name>
    <dataSourceName>chartlist_datasource</dataSourceName>
    <odaExtensionDataSetId>bpm.inlinedatas.oda.driver.runtime.dataSet</odaExtensionDataSetId>
    <odaExtensionDataSourceId>bpm.inlinedatas.oda.driver.runtime</odaExtensionDataSourceId>
    <queryText><![CDATA[
			value;label;}++No filter++}
		]]></queryText>
    <parameters/>
  </dataSet>
  <dataSet>
    <name>O_set_Products</name>
    <dataSourceName>sourceSample</dataSourceName>
    <odaExtensionDataSetId>bpm.metadata.birt.oda.runtime.dataSet</odaExtensionDataSetId>
    <odaExtensionDataSourceId>bpm.metadata.birt.oda.runtime</odaExtensionDataSourceId>
    <queryText><![CDATA[
			<freeMetaDataQuery>
     <sqlQuery>
     <distinct>false</distinct>
     <limit>0</limit>
         <select>
             <dataStreamElementName>products_name</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
         </select>
         <agg>
             <function>SUM</function>
             <formula>true</formula>
             <col>ROUND(orderfact.totalprice/1000,1)</col>
             <dataStreamName>orderfact</dataStreamName>
             <outputName>orderfact_totalprice</outputName>
         </agg>
         <orderBy>
             <dataStreamElementName>products_name</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
          </orderBy>
         <additionalResource>
++++++++%3Cprompt%3E%0A++++++++++++%3Cname%3EPmp_Date_From%3C%2Fname%3E%0A++++++++++++%3Cquestion%3Enull%3C%2Fquestion%3E%0A++++++++++++%3Coperator%3E%26gt%3B%3D%3C%2Foperator%3E%0A++++++++++++%3CoriginDataStream%3Etimeline%3C%2ForiginDataStream%3E%0A++++++++++++%3CoriginDataStreamElement%3Etimeline_id%3C%2ForiginDataStreamElement%3E%0A++++++++++++%3CdestinationDataStream%3Etimeline%3C%2FdestinationDataStream%3E%0A++++++++++++%3CdestinationDataStreamElement%3Etimeline_id%3C%2FdestinationDataStreamElement%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2Fprompt%3E%0A>
         </additionalResource>
         <additionalResource>
++++++++%3Cprompt%3E%0A++++++++++++%3Cname%3EPmp_Date_End%3C%2Fname%3E%0A++++++++++++%3Cquestion%3Enull%3C%2Fquestion%3E%0A++++++++++++%3Coperator%3E%26lt%3B%3D%3C%2Foperator%3E%0A++++++++++++%3CoriginDataStream%3Etimeline%3C%2ForiginDataStream%3E%0A++++++++++++%3CoriginDataStreamElement%3Etimeline_id%3C%2ForiginDataStreamElement%3E%0A++++++++++++%3CdestinationDataStream%3Etimeline%3C%2FdestinationDataStream%3E%0A++++++++++++%3CdestinationDataStreamElement%3Etimeline_id%3C%2FdestinationDataStreamElement%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2Fprompt%3E%0A>
         </additionalResource>
     </sqlQuery>
</freeMetaDataQuery>
]]></queryText>
    <parameters>
      <parameter name="Pmp_Date_From" label="Pmp_Date_From" position="1"/>
      <parameter name="Pmp_Date_End" label="Pmp_Date_End" position="2"/>
    </parameters>
  </dataSet>
  <dataSet>
    <name>M_Map</name>
    <dataSourceName>sourceSample</dataSourceName>
    <odaExtensionDataSetId>bpm.metadata.birt.oda.runtime.dataSet</odaExtensionDataSetId>
    <odaExtensionDataSourceId>bpm.metadata.birt.oda.runtime</odaExtensionDataSourceId>
    <queryText><![CDATA[
			<freeMetaDataQuery>
     <sqlQuery>
     <distinct>false</distinct>
     <limit>0</limit>
         <select>
             <dataStreamElementName>customers_country</dataStreamElementName>
             <dataStreamName>customers</dataStreamName>
         </select>
         <agg>
             <function>SUM</function>
             <formula>false</formula>
             <col>orderfact_quantityordered</col>
             <dataStreamName>orderfact</dataStreamName>
             <outputName>orderfact_quantityordered</outputName>
         </agg>
         <orderBy>
             <dataStreamElementName>customers_country</dataStreamElementName>
             <dataStreamName>customers</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>orderfact_quantityordered</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
          </orderBy>
     </sqlQuery>
</freeMetaDataQuery>
]]></queryText>
    <parameters/>
  </dataSet>
  <dataSet>
    <name>M_Country</name>
    <dataSourceName>ds_jdbc</dataSourceName>
    <odaExtensionDataSetId>org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet</odaExtensionDataSetId>
    <odaExtensionDataSourceId>org.eclipse.birt.report.data.oda.jdbc</odaExtensionDataSourceId>
    <queryText><![CDATA[
			select country.name_country,country.latitude,country.longitude
from country
		]]></queryText>
    <parameters/>
  </dataSet>
  <filter name="P_Years">
    <comment></comment>
    <filterData columnLabelIndex="1" columnValueIndex="1" columnOrderIndex="1">
      <dataSet-ref>P_set_Years</dataSet-ref>
    </filterData>
    <filterRenderer rendererStyle="1"/>
    <options submitOnChange="true" initParameterWithFirstValue="true" selectFirstValue="false" hidden="false" Required="false" defaultValue="2008"/>
    <sliderOptions barColor="silver" delay="5000" height="10" sliderColor="#666666" width="500" autoRun="false"/>
    <events/>
  </filter>
  <filter name="O_Filter_Date_From">
    <comment></comment>
    <filterRenderer rendererStyle="6"/>
    <options submitOnChange="false" initParameterWithFirstValue="true" selectFirstValue="false" hidden="false" Required="false" defaultValue="01/01/2005"/>
    <label></label>
    <events/>
  </filter>
  <filter name="O_Filter_Date_To">
    <comment></comment>
    <filterRenderer rendererStyle="6"/>
    <options submitOnChange="false" initParameterWithFirstValue="true" selectFirstValue="false" hidden="false" Required="false" defaultValue="01/01/2012"/>
    <label></label>
    <events/>
  </filter>
  <filter name="P_Filter_Graphic" cssClass="label_filter">
    <comment></comment>
    <filterData columnLabelIndex="2" columnValueIndex="1" columnOrderIndex="2">
      <dataSet-ref>P_ListChart</dataSet-ref>
    </filterData>
    <filterRenderer rendererStyle="0"/>
    <options submitOnChange="true" initParameterWithFirstValue="true" selectFirstValue="false" hidden="false" Required="false" defaultValue="--- Select a Value ---"/>
    <dropDownOptions size="1"/>
    <label></label>
    <events>
      <event type="onClick"><![CDATA[if (window.navigator.vendor == 'Google Inc.'){
fdObjects['P_Lines'].update('../../FusionCharts/' + P_Filter_Graphic.options[P_Filter_Graphic.selectedIndex].value);}]]></event>
      <event type="onChange"><![CDATA[if (window.navigator.vendor != 'Google Inc.'){
fdObjects['P_Lines'].update('../../FusionCharts/' + P_Filter_Graphic.options[P_Filter_Graphic.selectedIndex].value);}]]></event>
    </events>
  </filter>
  <chart name="O_Countries" width="621" height="377" cssClass="graph">
    <comment></comment>
    <chartNature style="2"/>
    <chartData valueField="2" groupField="1" groupLabelField="1" orderType="VALUE_DESC" aggregator="1">
      <dataSet-ref>O_set_Countries</dataSet-ref>
      <dataAggregation aggregator="1" valueField="2" applyOnDistinctSerie="false" primaryAxis="true" rendering="Column" orderType="CATEGORY_LABEL_ASC">
        <paletteColors>
          <color>59c2f3</color>
          <color>59c2f3</color>
          <color>59c2f3</color>
          <color>59c2f3</color>
          <color>59c2f3</color>
          <color>59c2f3</color>
          <color>59c2f3</color>
          <color>59c2f3</color>
          <color>59c2f3</color>
          <color>59c2f3</color>
        </paletteColors>
      </dataAggregation>
      <datasLimit size="10" type="1"/>
    </chartData>
    <chartRenderer rendererStyle="0"/>
    <colorRanges/>
    <options>
      <numberFormatOptions formatNumber="1" formatNumberScale="0" numberPrefix="" numberSuffix="" decimalSeparator="." thousandSeparator="," decimals="2" forceDecimal="0"/>
      <drillReportOptions cssName=""/>
      <genericNonPieOptions rotateLabels="0" slantLabels="1" rotateValues="0" placeValuesInside="0" rotateYAxisName="0"/>
      <genericOptions caption="Top 10 Countries" subCaption="From {$O_Date_From} To {$O_Date_End}" showValues="false" showLabels="true" baseFontSize="10" DynamicLegend="true" exportEnable="true" LabelSize="0" multiLineLabels="false"/>
    </options>
    <drillInfo active="true" categoryAsValue="true" drillLevelProvider="0" drillType="Parameter">
      <zoomWidth>500</zoomWidth>
      <zoomHeight>500</zoomHeight>
    </drillInfo>
    <events/>
    <valueFormat>
      <bold>false</bold>
      <italic>false</italic>
      <underline>false</underline>
    </valueFormat>
  </chart>
  <chart name="O_Cities_Top_5" width="333" height="334" cssClass="chart">
    <comment></comment>
    <chartNature style="0"/>
    <chartData valueField="2" groupField="1" groupLabelField="1" orderType="CATEGORY_ASC" aggregator="1">
      <dataSet-ref>O_set_Cities</dataSet-ref>
      <dataAggregation aggregator="1" valueField="2" applyOnDistinctSerie="false" primaryAxis="true" rendering="Column" orderType="CATEGORY_LABEL_ASC">
        <paletteColors>
          <color>0000ff</color>
          <color>004080</color>
          <color>800080</color>
          <color>0080c0</color>
          <color>8000ff</color>
          <color>0000a0</color>
          <color>004080</color>
        </paletteColors>
      </dataAggregation>
      <datasLimit size="5" type="1"/>
    </chartData>
    <chartRenderer rendererStyle="0"/>
    <colorRanges/>
    <options>
      <numberFormatOptions formatNumber="1" formatNumberScale="0" numberPrefix="" numberSuffix="" decimalSeparator="." thousandSeparator="," decimals="2" forceDecimal="0"/>
      <drillReportOptions cssName=""/>
      <pieGenericOptions caption="" subCaption="From {$O_Date_From} To {$O_Date_End} &lt;br&gt;" showValues="true" showLabels="true" baseFontSize="10" DynamicLegend="false" exportEnable="true" LabelSize="0" multiLineLabels="false" slicingDistance="10" pieSliceDepth="20" pieRadius="70"/>
    </options>
    <drillInfo active="false" categoryAsValue="true" drillLevelProvider="0" drillType="Parameter">
      <zoomWidth>500</zoomWidth>
      <zoomHeight>500</zoomHeight>
    </drillInfo>
    <events/>
    <valueFormat>
      <bold>false</bold>
      <italic>false</italic>
      <underline>false</underline>
    </valueFormat>
  </chart>
  <chart name="P_Lines" width="507" height="375" cssClass="graph">
    <comment></comment>
    <chartNature style="0"/>
    <chartData valueField="2" groupField="1" groupLabelField="1" orderType="CATEGORY_ASC" aggregator="1">
      <dataSet-ref>P_set_Lines</dataSet-ref>
      <dataAggregation aggregator="1" valueField="2" applyOnDistinctSerie="false" primaryAxis="true" rendering="Column" orderType="CATEGORY_LABEL_ASC">
        <paletteColors>
          <color>000080</color>
          <color>0000ff</color>
          <color>8080ff</color>
          <color>0080c0</color>
          <color>0080ff</color>
          <color>00ffff</color>
          <color>59c2f3</color>
        </paletteColors>
      </dataAggregation>
      <datasLimit size="5" type="0"/>
    </chartData>
    <chartRenderer rendererStyle="0"/>
    <colorRanges/>
    <options>
      <numberFormatOptions formatNumber="1" formatNumberScale="0" numberPrefix="" numberSuffix="" decimalSeparator="." thousandSeparator="," decimals="2" forceDecimal="0"/>
      <drillReportOptions cssName=""/>
      <pieGenericOptions caption="Products Lines" subCaption="Year : {$Pmp_Order_Year}" showValues="true" showLabels="true" baseFontSize="10" DynamicLegend="false" exportEnable="true" LabelSize="0" multiLineLabels="false" slicingDistance="10" pieSliceDepth="20" pieRadius="100"/>
    </options>
    <drillInfo active="true" categoryAsValue="true" drillLevelProvider="0" drillType="Parameter">
      <zoomWidth>500</zoomWidth>
      <zoomHeight>500</zoomHeight>
    </drillInfo>
    <events/>
    <valueFormat>
      <bold>false</bold>
      <italic>false</italic>
      <underline>false</underline>
    </valueFormat>
  </chart>
  <chart name="P_Products" width="518" height="375" cssClass="graph">
    <comment></comment>
    <chartNature style="4"/>
    <chartData valueField="2" groupField="1" groupLabelField="1" orderType="VALUE_DESC" aggregator="1">
      <dataSet-ref>P_set_Products_5</dataSet-ref>
      <dataAggregation aggregator="1" valueField="2" applyOnDistinctSerie="false" primaryAxis="true" rendering="Column" orderType="CATEGORY_LABEL_ASC">
        <paletteColors>
          <color>000080</color>
          <color>0000ff</color>
          <color>8080ff</color>
          <color>0080c0</color>
          <color>0080ff</color>
          <color>00ffff</color>
          <color>59c2f3</color>
        </paletteColors>
      </dataAggregation>
      <datasLimit size="10" type="1"/>
    </chartData>
    <chartRenderer rendererStyle="0"/>
    <colorRanges/>
    <options>
      <numberFormatOptions formatNumber="1" formatNumberScale="0" numberPrefix="" numberSuffix="" decimalSeparator="." thousandSeparator="," decimals="2" forceDecimal="0"/>
      <drillReportOptions cssName=""/>
      <genericNonPieOptions rotateLabels="0" slantLabels="0" rotateValues="0" placeValuesInside="0" rotateYAxisName="0"/>
      <genericOptions caption="Top 10 Products" subCaption="Year : {$Pmp_Order_Year} &lt;br&gt; ProductLine : {$Pmp_Product_Line}" showValues="true" showLabels="true" baseFontSize="10" DynamicLegend="true" exportEnable="true" LabelSize="0" multiLineLabels="false"/>
    </options>
    <drillInfo active="false" categoryAsValue="true" drillLevelProvider="0" drillType="Parameter">
      <zoomWidth>500</zoomWidth>
      <zoomHeight>500</zoomHeight>
    </drillInfo>
    <events/>
    <valueFormat>
      <bold>false</bold>
      <italic>false</italic>
      <underline>false</underline>
    </valueFormat>
  </chart>
  <chart name="O_Countries_Top_5" width="333" height="334" cssClass="chart">
    <comment></comment>
    <chartNature style="0"/>
    <chartData valueField="2" groupField="1" groupLabelField="1" orderType="VALUE_DESC" aggregator="0">
      <dataSet-ref>O_set_Countries</dataSet-ref>
      <dataAggregation aggregator="0" valueField="2" applyOnDistinctSerie="false" primaryAxis="true" rendering="Column" orderType="CATEGORY_LABEL_ASC">
        <paletteColors>
          <color>0000ff</color>
          <color>004080</color>
          <color>800080</color>
          <color>0080c0</color>
          <color>8000ff</color>
          <color>0080ff</color>
          <color>400080</color>
        </paletteColors>
      </dataAggregation>
      <datasLimit size="5" type="1"/>
    </chartData>
    <chartRenderer rendererStyle="0"/>
    <colorRanges/>
    <options>
      <numberFormatOptions formatNumber="1" formatNumberScale="0" numberPrefix="" numberSuffix="" decimalSeparator="." thousandSeparator="," decimals="2" forceDecimal="0"/>
      <drillReportOptions cssName=""/>
      <pieGenericOptions caption="" subCaption="From {$O_Date_From} To {$O_Date_End}" showValues="true" showLabels="true" baseFontSize="10" DynamicLegend="false" exportEnable="true" LabelSize="0" multiLineLabels="false" slicingDistance="10" pieSliceDepth="20" pieRadius="70"/>
    </options>
    <drillInfo active="true" categoryAsValue="true" drillLevelProvider="0" drillType="Parameter">
      <zoomWidth>500</zoomWidth>
      <zoomHeight>500</zoomHeight>
    </drillInfo>
    <events/>
    <valueFormat>
      <bold>false</bold>
      <italic>false</italic>
      <underline>false</underline>
    </valueFormat>
  </chart>
  <chart name="O_Countries_2" width="618" height="380">
    <comment></comment>
    <chartNature style="18"/>
    <multiSeriesChartData groupField="1" groupLabelField="1" orderType="VALUE_DESC">
      <dataAggregation aggregator="0" valueField="2" applyOnDistinctSerie="false" measureName="Turnover" primaryAxis="true" rendering="Column" orderType="CATEGORY_LABEL_ASC">
        <paletteColors>
          <color>0000ff</color>
          <color>00FF00</color>
          <color>0000FF</color>
          <color>AA00FF</color>
          <color>AAAAFF</color>
          <color>AA0020</color>
          <color>AAAA20</color>
        </paletteColors>
      </dataAggregation>
      <dataSet-ref>O_set_Countries</dataSet-ref>
      <datasLimit size="10" type="1"/>
    </multiSeriesChartData>
    <chartRenderer rendererStyle="0"/>
    <colorRanges/>
    <options>
      <numberFormatOptions formatNumber="0" formatNumberScale="0" numberPrefix="" numberSuffix="" decimalSeparator="." thousandSeparator="," decimals="2" forceDecimal="0"/>
      <drillReportOptions cssName=""/>
      <genericNonPieOptions rotateLabels="0" slantLabels="0" rotateValues="0" placeValuesInside="0" rotateYAxisName="0"/>
      <lineCombinationOptions lineSerieName=""/>
      <genericOptions caption="" subCaption="" showValues="true" showLabels="true" baseFontSize="10" DynamicLegend="false" exportEnable="false" LabelSize="0" multiLineLabels="false"/>
    </options>
    <drillInfo active="true" categoryAsValue="true" drillLevelProvider="0" drillType="Parameter">
      <zoomWidth>500</zoomWidth>
      <zoomHeight>500</zoomHeight>
    </drillInfo>
    <events/>
    <valueFormat>
      <bold>false</bold>
      <italic>false</italic>
      <underline>false</underline>
    </valueFormat>
  </chart>
  <chart name="Copy_of_O_Countries_1" width="584" height="377">
    <comment></comment>
    <chartNature style="2"/>
    <chartData valueField="2" groupField="1" groupLabelField="1" orderType="VALUE_DESC" aggregator="0">
      <dataSet-ref>O_set_Countries</dataSet-ref>
      <dataAggregation aggregator="0" valueField="2" applyOnDistinctSerie="false" primaryAxis="true" rendering="Column" orderType="CATEGORY_LABEL_ASC">
        <paletteColors>
          <color>FF0000</color>
          <color>00FF00</color>
          <color>0000FF</color>
          <color>AA00FF</color>
          <color>AAAAFF</color>
          <color>AA0020</color>
          <color>AAAA20</color>
        </paletteColors>
      </dataAggregation>
      <datasLimit size="5" type="0"/>
    </chartData>
    <chartRenderer rendererStyle="0"/>
    <colorRanges/>
    <options>
      <numberFormatOptions formatNumber="1" formatNumberScale="0" numberPrefix="" numberSuffix="" decimalSeparator="." thousandSeparator="," decimals="2" forceDecimal="0"/>
      <drillReportOptions cssName=""/>
      <genericNonPieOptions rotateLabels="0" slantLabels="0" rotateValues="0" placeValuesInside="0" rotateYAxisName="0"/>
      <genericOptions caption="Top 10 Countries" subCaption="From {$O_Date_From} To {$O_Date_End}" showValues="true" showLabels="true" baseFontSize="10" DynamicLegend="false" exportEnable="true" LabelSize="0" multiLineLabels="false"/>
    </options>
    <drillInfo active="false" categoryAsValue="true" drillLevelProvider="0" drillType="Parameter">
      <zoomWidth>500</zoomWidth>
      <zoomHeight>500</zoomHeight>
    </drillInfo>
    <events/>
    <valueFormat>
      <bold>false</bold>
      <italic>false</italic>
      <underline>false</underline>
    </valueFormat>
  </chart>
  <chart name="O_Products_Top5" width="402" height="334" cssClass="chart">
    <comment></comment>
    <chartNature style="4"/>
    <chartData valueField="2" groupField="1" groupLabelField="1" orderType="VALUE_DESC" aggregator="0">
      <dataSet-ref>O_set_Products</dataSet-ref>
      <dataAggregation aggregator="0" valueField="2" applyOnDistinctSerie="false" primaryAxis="true" rendering="Column" orderType="CATEGORY_LABEL_ASC">
        <paletteColors>
          <color>0000ff</color>
          <color>004080</color>
          <color>800080</color>
          <color>0080c0</color>
          <color>8000ff</color>
          <color>AA0020</color>
          <color>AAAA20</color>
          <color>ffffff</color>
        </paletteColors>
      </dataAggregation>
      <datasLimit size="5" type="1"/>
    </chartData>
    <chartRenderer rendererStyle="0"/>
    <colorRanges/>
    <options>
      <numberFormatOptions formatNumber="1" formatNumberScale="0" numberPrefix="" numberSuffix="" decimalSeparator="." thousandSeparator="," decimals="2" forceDecimal="0"/>
      <drillReportOptions cssName=""/>
      <genericNonPieOptions rotateLabels="0" slantLabels="0" rotateValues="0" placeValuesInside="0" rotateYAxisName="0"/>
      <genericOptions caption="" subCaption="From {$Pmp_Date_From} To {$Pmp_Date_End}" showValues="true" showLabels="true" baseFontSize="10" DynamicLegend="true" exportEnable="true" LabelSize="0" multiLineLabels="false"/>
    </options>
    <drillInfo active="false" categoryAsValue="true" drillLevelProvider="0" drillType="Parameter">
      <zoomWidth>500</zoomWidth>
      <zoomHeight>500</zoomHeight>
    </drillInfo>
    <events/>
    <valueFormat>
      <bold>false</bold>
      <italic>false</italic>
      <underline>false</underline>
    </valueFormat>
  </chart>
  <label name="Model_Titre_Dashboard" cssClass="title_db">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>Sales Overview - Dashboard</content>
    </options>
    <events/>
  </label>
  <label name="O_Label_Titre" cssClass="sub_title">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>Overall : Products Sold</content>
    </options>
    <events/>
  </label>
  <label name="P_Label_SubTitle" cssClass="sub_title">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>Products sold by year</content>
    </options>
    <events/>
  </label>
  <label name="O_Label_From_Date">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>From</content>
    </options>
    <events/>
  </label>
  <label name="O_Label_Filter_Date_From" cssClass="label_filter">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>Date from</content>
    </options>
    <events/>
  </label>
  <label name="O_Label_Filtre_Date_To" cssClass="label_filter">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>Date to</content>
    </options>
    <events/>
  </label>
  <label name="O_Explanations" cssClass="explanations">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>&lt;u&gt;This tab aims to show you several functionnalities : &lt;/u&gt;&lt;br&gt; &lt;li&gt;&lt;b&gt;Range Date Parameter&lt;/b&gt;&lt;/li&gt;Choose a start date and an end date and click on "Date Application" in order to the charts take in account the new dates.&lt;br&gt;&lt;br&gt; &lt;li&gt;&lt;b&gt;Export Graphics&lt;/b&gt;&lt;/li&gt;Each graphic can be exported under differents formats. To export them, click on the icon at the top right of each chart.&lt;br&gt;&lt;br&gt;</content>
    </options>
    <events/>
  </label>
  <label name="P_Explanations" cssClass="explanations">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>&lt;u&gt;This tab aims to show you several functionnalities : &lt;/u&gt;&lt;br&gt; &lt;li&gt;&lt;b&gt;Year Parameter&lt;/b&gt;&lt;/li&gt;The user can choose differents parameter formats as for instance listbox or slide&lt;br&gt;&lt;br&gt; &lt;li&gt;&lt;b&gt;Drill&lt;/b&gt;&lt;/li&gt;The user can drill between the charts.&lt;br&gt; Click on one of columns in the chart at the left and the other chart automatically changes its data displayed to match with the column selected.&lt;br&gt;&lt;br&gt; &lt;li&gt;&lt;b&gt;Differents Graphics Kind&lt;/b&gt;&lt;/li&gt;A graphic can be visualized under differents kinds thanks to the list box available at the left of the screen.&lt;br&gt; This list is linked to the chart below it.&lt;br&gt;&lt;br&gt;</content>
    </options>
    <events/>
  </label>
  <label name="Copy_of_O_Label_Titre" cssClass="sub_title">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>Overall : Products Sold</content>
    </options>
    <events/>
  </label>
  <label name="O_Label_Filter_Graphic" cssClass="label_filter">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>Choose the chart kind</content>
    </options>
    <events/>
  </label>
  <label name="O_Label_Top5Countries" cssClass="label_filter_chart">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>Top 5 Cities (in K €)</content>
    </options>
    <events/>
  </label>
  <label name="O_Label_Chart_Countries" cssClass="label_filter_chart">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>Top 5 Countries (in K €)</content>
    </options>
    <events/>
  </label>
  <label name="O_Label_Chart_Products" cssClass="label_filter_chart">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>Top 5 Products (in K €)</content>
    </options>
    <events/>
  </label>
  <label name="M_Label_Map" cssClass="sub_title">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>Quantity sold in the world</content>
    </options>
    <events/>
  </label>
  <label name="C_Label" cssClass="sub_title">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>Quantity sold in France</content>
    </options>
    <events/>
  </label>
  <picture name="Model_Picture_BPM" cssClass="">
    <comment></comment>
    <pictureUrl>Small_BPMConseil_Logo.png</pictureUrl>
    <events/>
  </picture>
  <picture name="Model_Picture_Vanilla" cssClass="">
    <comment></comment>
    <pictureUrl>vanilla_lettering_64.png</pictureUrl>
    <events/>
  </picture>
  <picture name="ComponentPicture_1" cssClass="">
    <comment></comment>
    <pictureUrl>vanilla_lettering_64.png</pictureUrl>
    <events/>
  </picture>
  <olapView name="C_Cube">
    <comment></comment>
    <directoryItemId>130</directoryItemId>
    <reportOptions height="400" width="1000"/>
    <faViewOption isInteractive="true" showDimensions="false" showCubeFunctions="false"/>
    <events/>
  </olapView>
  <button name="O_Btn_Application_Date" cssClass="btn">
    <comment></comment>
    <buttonOptions>
      <label>Date Application</label>
    </buttonOptions>
    <events>
      <event type="onClick"><![CDATA[
				var date_from = document.getElementById('datepicker_O_Filter_Date_From').value;
var date_end = document.getElementById('datepicker_O_Filter_Date_To').value;

 var part1 = date_from.split('/');
 var res1 = part1[2] + '-' + part1[0] + '-' + part1[1];
  var part2 = date_end.split('/');
 var res2 = part2[2] + '-' + part2[0] + '-' + part2[1];
 setParameter('O_Filter_Date_From', res1, false);
 setParameter('O_Filter_Date_To', res2, true);

			]]></event>
    </events>
  </button>
  <button name="Btn_Help" cssClass="btn_help">
    <comment></comment>
    <buttonOptions>
      <label></label>
    </buttonOptions>
    <events>
      <event type="onClick"><![CDATA[
				popupModelPage('popup_Overall',950,400);
			]]></event>
    </events>
  </button>
  <button name="P_Btn_Help" cssClass="btn_help">
    <comment></comment>
    <buttonOptions>
      <label></label>
    </buttonOptions>
    <events>
      <event type="onClick"><![CDATA[
				popupModelPage('popup_Products',1000,350);
			]]></event>
    </events>
  </button>
  <maposm name="M_Map_OSM" width="915" height="687">
    <comment></comment>
    <mapData type="bpm.fd.api.core.model.components.definition.maps.openlayers.OsmData" valueFieldIndex="2" zoneFieldIndex="1" zoneFieldLabelIndex="1">
      <series>
        <serie>
          <name>Polygon_Serie_1</name>
          <type>Polygon</type>
          <hasParent>false</hasParent>
          <colorRanges>
            <minColor>FF0000</minColor>
            <maxColor>00FF00</maxColor>
          </colorRanges>
          <drillable>true</drillable>
          <latitudeFieldIndex>2</latitudeFieldIndex>
          <longitudeFieldIndex>3</longitudeFieldIndex>
          <zoneFieldIndex>1</zoneFieldIndex>
          <points>1</points>
          <dataSet-ref>M_Country</dataSet-ref>
        </serie>
      </series>
      <dataSet-ref>M_Map</dataSet-ref>
    </mapData>
    <options class="bpm.fd.api.core.model.components.definition.maps.openlayers.OsmMapOptions">
      <Zoom>0</Zoom>
      <Originlatitude>0.0</Originlatitude>
      <Originlongitude>0.0</Originlongitude>
      <Boundleft>0.0</Boundleft>
      <Boundbottom>0.0</Boundbottom>
      <Boundright>0.0</Boundright>
      <Boundtop>0.0</Boundtop>
      <Projection></Projection>
      <Showlegend>true</Showlegend>
      <legendOrientation>Horizontal</legendOrientation>
      <legendLayout>Right</legendLayout>
      <numberFormat></numberFormat>
    </options>
    <events/>
  </maposm>
  <dependancies>
    <dependantDirectoryItemId>1</dependantDirectoryItemId>
    <dependantDirectoryItemId>130</dependantDirectoryItemId>
  </dependancies>
</dictionary>