
<dictionary version="v2.0" name="dictionnaire_SalesDashboard">
  <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>
  <dataSet>
    <name>sales_byproductline</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>
         <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>products_line</dataStreamElementName>
             <dataStreamName>products</dataStreamName>
          </orderBy>
     </sqlQuery>
</freeMetaDataQuery>
]]></queryText>
    <parameters/>
  </dataSet>
  <dataSet>
    <name>sales_by_year</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>timeline_year_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline_month_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>timeline_month_name</dataStreamElementName>
             <dataStreamName>timeline</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>timeline_year_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline_month_nb</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>timeline_month_name</dataStreamElementName>
             <dataStreamName>timeline</dataStreamName>
          </orderBy>
         <additionalResource>
++++++++%3Cprompt%3E%0A++++++++++++%3Cname%3EpromptOnproducts_line%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_line%3C%2ForiginDataStreamElement%3E%0A++++++++++++%3CdestinationDataStream%3Eproducts%3C%2FdestinationDataStream%3E%0A++++++++++++%3CdestinationDataStreamElement%3Eproducts_line%3C%2FdestinationDataStreamElement%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2Fprompt%3E%0A>
         </additionalResource>
     </sqlQuery>
</freeMetaDataQuery>
]]></queryText>
    <parameters>
      <parameter name="promptOnproducts_line" label="promptOnproducts_line" position="1"/>
    </parameters>
  </dataSet>
  <dataSet>
    <name>parameter_year</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>
  <filter name="O_Filter_Date_From">
    <comment></comment>
    <filterRenderer rendererStyle="6"/>
    <options submitOnChange="false" initParameterWithFirstValue="true" selectFirstValue="true" hidden="false" Required="false"/>
    <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="2012/01/01"/>
    <label></label>
    <events/>
  </filter>
  <filter name="Filter_parameter_year" cssClass="label_filter">
    <comment></comment>
    <filterData columnLabelIndex="1" columnValueIndex="1" columnOrderIndex="1">
      <dataSet-ref>parameter_year</dataSet-ref>
    </filterData>
    <filterRenderer rendererStyle="0"/>
    <options submitOnChange="true" initParameterWithFirstValue="true" selectFirstValue="true" hidden="false" Required="false"/>
    <dropDownOptions size="1"/>
    <label>Choose a year</label>
    <events/>
  </filter>
  <chart name="Chart_productLine" width="470" height="356">
    <comment></comment>
    <chartNature style="10"/>
    <multiSeriesChartData groupField="1" groupLabelField="1" orderType="CATEGORY_ASC">
      <dataAggregation aggregator="0" valueField="2" applyOnDistinctSerie="false" measureName="Sales" primaryAxis="true" rendering="Column">
        <paletteColors>
          <color>59c2f3</color>
          <color>00FF00</color>
          <color>0000FF</color>
          <color>AA00FF</color>
          <color>AAAAFF</color>
          <color>AA0020</color>
          <color>AAAA20</color>
        </paletteColors>
      </dataAggregation>
      <dataSet-ref>sales_byproductline</dataSet-ref>
      <datasLimit size="5" type="0"/>
    </multiSeriesChartData>
    <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="Sales by product line (in K €)" subCaption="For all the years" showValues="false" 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="Chart_Line_Year_ProductLine" width="496" height="349">
    <comment></comment>
    <chartNature style="17"/>
    <multiSeriesChartData groupField="2" groupLabelField="3" orderType="CATEGORY_ASC" serieField="1">
      <dataAggregation aggregator="0" valueField="4" applyOnDistinctSerie="true" measureName="None" primaryAxis="true" rendering="Column">
        <paletteColors>
          <color>59c2f3</color>
          <color>8000ff</color>
          <color>0000FF</color>
          <color>800080</color>
          <color>AAAAFF</color>
          <color>AA0020</color>
          <color>AAAA20</color>
        </paletteColors>
      </dataAggregation>
      <dataSet-ref>sales_by_year</dataSet-ref>
      <datasLimit size="5" type="0"/>
    </multiSeriesChartData>
    <chartRenderer rendererStyle="0"/>
    <colorRanges/>
    <options>
      <numberFormatOptions formatNumber="1" formatNumberScale="0" numberPrefix="" numberSuffix="" decimalSeparator="." thousandSeparator="," decimals="2" forceDecimal="0"/>
      <drillReportOptions cssName=""/>
      <genericNonPieOptions rotateLabels="1" slantLabels="0" rotateValues="0" placeValuesInside="0" rotateYAxisName="0"/>
      <genericOptions caption="Sales by year (in K €)" subCaption="Product Line : {$promptOnproducts_line}" showValues="true" showLabels="true" baseFontSize="10" DynamicLegend="false" exportEnable="false" 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>This tab aims to show you several functionnalities : &lt;br&gt; - Range Date Parameter : &lt;br&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; - Export Graphics : &lt;br&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; - Differents Graphics Kind : &lt;br&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; - Drill : &lt;br&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 clicked.</content>
    </options>
    <events/>
  </label>
  <label name="P_Explanations" cssClass="explanations">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>This tab aims to show you several functionnalities : &lt;br&gt; - Year Parameter : &lt;br&gt; The user can choose differents parameter formats as for instance listbox or slide&lt;br&gt; -Drill : &lt;br&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.</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="popup_explanations">
    <comment></comment>
    <labelRenderer rendererStyle="0"/>
    <options>
      <content>&lt;u&gt;This dashboard 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;Report Integration&lt;/b&gt;&lt;/li&gt;The user can integrate reports inside dashboard</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>
  <report name="Report_Orders">
    <comment></comment>
    <directoryItemId>36</directoryItemId>
    <parameter name="Year"/>
    <reportOptions height="400" width="1000"/>
    <events/>
  </report>
  <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,300);
			]]></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,150);
			]]></event>
    </events>
  </button>
  <button name="Model_Btn_Help" cssClass="btn_help">
    <comment></comment>
    <buttonOptions>
      <label></label>
    </buttonOptions>
    <events>
      <event type="onClick"><![CDATA[
				popupModelPage('popup_model',1000,300)
			]]></event>
    </events>
  </button>
  <dependancies>
    <dependantDirectoryItemId>1</dependantDirectoryItemId>
    <dependantDirectoryItemId>36</dependantDirectoryItemId>
  </dependancies>
</dictionary>