<?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="Year" id="152">
            <text-property name="promptText">Year</text-property>
            <property name="valueType">dynamic</property>
            <property name="isRequired">true</property>
            <property name="dataSetName">setOrders_P</property>
            <expression name="valueExpr" type="javascript">dataSetRow["timeline_year_nb"]</expression>
            <expression name="labelExpr" type="javascript">dataSetRow["timeline_year_nb"]</expression>
            <expression name="sortByColumn">dataSetRow["timeline_year_nb"]</expression>
            <property name="sortDirection">asc</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">2010</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="setOrders_P" id="151">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">timeline_year_nb</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">timeline_year_nb</text-property>
                    <text-property name="heading">timeline_year_nb</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">timeline_year_nb</property>
                        <property name="dataType">integer</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">sourceSample</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">timeline_year_nb</property>
                    <property name="nativeName">timeline_year_nb</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">4</property>
                </structure>
            </list-property>
            <xml-property name="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>
         <additionalResource>
++++++++%3CsqlFilter%3E%0A++++++++++++%3Cname%3Etoday%3C%2Fname%3E%0A++++++++++++%3CdataStreamElement%3Etimeline_id%3C%2FdataStreamElement%3E%0A++++++++++++%3CdataStream%3Etimeline%3C%2FdataStream%3E%0A++++++++++++%3Cquery%3E%26lt%3B%3D+NOW%28%29%3C%2Fquery%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2FsqlFilter%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>
  <design:ResultSets derivedMetaData="true">
    <design:resultSetDefinitions>
      <design:resultSetColumns>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>timeline_year_nb</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>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: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="setOrders" id="153">
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">orderfact_status</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">orderfact_status</text-property>
                    <text-property name="heading">orderfact_status</text-property>
                </structure>
                <structure>
                    <property name="columnName">customers_country</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">customers_country</text-property>
                    <text-property name="heading">customers_country</text-property>
                </structure>
                <structure>
                    <property name="columnName">orderfact_ordernumber</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">orderfact_ordernumber</text-property>
                    <text-property name="heading">orderfact_ordernumber</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">Pmp_Order_Year</property>
                    <property name="paramName">Year</property>
                    <property name="nativeName">Pmp_Order_Year</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">orderfact_status</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">customers_country</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">orderfact_ordernumber</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">orderfact_status</property>
                    <property name="nativeName">orderfact_status</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">customers_country</property>
                    <property name="nativeName">customers_country</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">orderfact_ordernumber</property>
                    <property name="nativeName">orderfact_ordernumber</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>orderfact_status</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
         </select>
         <select>
             <dataStreamElementName>customers_country</dataStreamElementName>
             <dataStreamName>customers</dataStreamName>
         </select>
         <prompt>Pmp_Order_Year</prompt>
         <agg>
             <function>COUNT</function>
             <formula>false</formula>
             <col>orderfact_ordernumber</col>
             <dataStreamName>orderfact</dataStreamName>
             <outputName>orderfact_ordernumber</outputName>
         </agg>
         <orderBy>
             <dataStreamElementName>orderfact_status</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>customers_country</dataStreamElementName>
             <dataStreamName>customers</dataStreamName>
          </orderBy>
         <orderBy>
             <dataStreamElementName>orderfact_ordernumber</dataStreamElementName>
             <dataStreamName>orderfact</dataStreamName>
          </orderBy>
         <additionalResource>
++++++++%3CsqlFilter%3E%0A++++++++++++%3Cname%3Etoday%3C%2Fname%3E%0A++++++++++++%3CdataStreamElement%3Etimeline_id%3C%2FdataStreamElement%3E%0A++++++++++++%3CdataStream%3Etimeline%3C%2FdataStream%3E%0A++++++++++++%3Cquery%3E%26lt%3B%3D+NOW%28%29%3C%2Fquery%3E%0A++++++++++++%3CgroupNames%3E%3C%2FgroupNames%3E%0A++++++++%3C%2FsqlFilter%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_Order_Year</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>orderfact_status</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>orderfact_status</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>orderfact_status</design:label>
            <design:formattingHints>
              <design:displaySize>8</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>customers_country</design:name>
              <design:position>2</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>customers_country</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>customers_country</design:label>
            <design:formattingHints>
              <design:displaySize>8</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>orderfact_ordernumber</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_ordernumber</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>orderfact_ordernumber</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>
    <cubes>
        <tabular-cube name="Orders" id="155">
            <property name="dimensions">
                <tabular-dimension name="GroupCountry" id="156">
                    <property name="defaultHierarchy">NewTabularHierarchy</property>
                    <property name="hierarchies">
                        <tabular-hierarchy name="NewTabularHierarchy" id="157">
                            <property name="levels">
                                <tabular-level name="customers_country" id="158">
                                    <property name="dataType">string</property>
                                    <property name="columnName">customers_country</property>
                                </tabular-level>
                            </property>
                        </tabular-hierarchy>
                    </property>
                </tabular-dimension>
                <tabular-dimension name="GroupStatus" id="159">
                    <property name="defaultHierarchy">NewTabularHierarchy1</property>
                    <property name="hierarchies">
                        <tabular-hierarchy name="NewTabularHierarchy1" id="160">
                            <property name="levels">
                                <tabular-level name="orderfact_status" id="161">
                                    <property name="dataType">string</property>
                                    <property name="columnName">orderfact_status</property>
                                </tabular-level>
                            </property>
                        </tabular-hierarchy>
                    </property>
                </tabular-dimension>
            </property>
            <property name="measureGroups">
                <tabular-measure-group name="Summary Field" id="162">
                    <property name="measures">
                        <tabular-measure name="orderfact_ordernumber" id="163">
                            <property name="function">sum</property>
                            <property name="isCalculated">false</property>
                            <expression name="measureExpression" type="javascript">dataSetRow["orderfact_ordernumber"]</expression>
                            <property name="dataType">integer</property>
                            <property name="isVisible">true</property>
                        </tabular-measure>
                    </property>
                </tabular-measure-group>
            </property>
            <property name="dataSet">setOrders</property>
        </tabular-cube>
    </cubes>
    <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">1in</property>
            <page-header>
                <grid id="118">
                    <property name="width">7.875in</property>
                    <column id="119">
                        <property name="width">2.1354166666666665in</property>
                    </column>
                    <column id="120">
                        <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="239">
                                <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">"Orders Report&lt;br>Year : " +params["Year"].value</expression>
                                <property name="contentType">html</property>
                            </text-data>
                        </cell>
                        <cell id="125">
                            <property name="verticalAlign">middle</property>
                            <image id="128">
                                <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="99">
                    <property name="width">7.84375in</property>
                    <column id="100">
                        <property name="width">1.40625in</property>
                    </column>
                    <column id="101">
                        <property name="width">5.510416666666667in</property>
                    </column>
                    <column id="102">
                        <property name="width">0.9270833333333334in</property>
                    </column>
                    <row id="103">
                        <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="105">
                            <text id="240">
                                <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"  target="_blank">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>
        <grid id="9">
            <property name="width">7.947916666666667in</property>
            <column id="10">
                <property name="width">6.614583333333333in</property>
            </column>
            <column id="11">
                <property name="width">1.3333333333333333in</property>
            </column>
            <row id="18">
                <cell id="19">
                    <property name="colSpan">2</property>
                    <property name="rowSpan">1</property>
                    <property name="textAlign">center</property>
                    <extended-item extensionName="Chart" id="154">
                        <xml-property name="xmlRepresentation"><![CDATA[<model:ChartWithoutAxes xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:attribute="http://www.birt.eclipse.org/ChartModelAttribute" xmlns:layout="http://www.birt.eclipse.org/ChartModelLayout" xmlns:model="http://www.birt.eclipse.org/ChartModel" xmlns:type="http://www.birt.eclipse.org/ChartModelType">
  <Version>2.6</Version>
  <Type>Pie Chart</Type>
  <SubType>Standard</SubType>
  <Block>
    <Children xsi:type="layout:TitleBlock">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Insets>
        <Top>3.0</Top>
        <Left>3.0</Left>
        <Bottom>3.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Visible>true</Visible>
      <Label>
        <Caption>
          <Value>Orders by status</Value>
          <Font>
            <Name>Calibri</Name>
            <Size>14.0</Size>
            <Bold>true</Bold>
            <Alignment>
              <horizontalAlignment>Center</horizontalAlignment>
              <verticalAlignment>Center</verticalAlignment>
            </Alignment>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>true</Visible>
      </Label>
    </Children>
    <Children xsi:type="layout:Plot">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Insets>
        <Top>3.0</Top>
        <Left>3.0</Left>
        <Bottom>3.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>false</Visible>
      </Outline>
      <Visible>true</Visible>
      <HorizontalSpacing>5</HorizontalSpacing>
      <VerticalSpacing>5</VerticalSpacing>
      <ClientArea>
        <Outline>
          <Style>Solid</Style>
          <Thickness>0</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>0.0</Left>
          <Bottom>0.0</Bottom>
          <Right>0.0</Right>
        </Insets>
      </ClientArea>
    </Children>
    <Children xsi:type="layout:Legend">
      <Bounds>
        <Left>0.0</Left>
        <Top>0.0</Top>
        <Width>0.0</Width>
        <Height>0.0</Height>
      </Bounds>
      <Insets>
        <Top>3.0</Top>
        <Left>3.0</Left>
        <Bottom>3.0</Bottom>
        <Right>3.0</Right>
      </Insets>
      <Row>-1</Row>
      <Column>-1</Column>
      <Rowspan>-1</Rowspan>
      <Columnspan>-1</Columnspan>
      <Outline>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>51</Red>
          <Green>104</Green>
          <Blue>183</Blue>
        </Color>
        <Visible>true</Visible>
      </Outline>
      <Visible>true</Visible>
      <ClientArea>
        <Outline>
          <Style>Solid</Style>
          <Thickness>0</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>2.0</Top>
          <Left>2.0</Left>
          <Bottom>2.0</Bottom>
          <Right>2.0</Right>
        </Insets>
      </ClientArea>
      <Text>
        <Value></Value>
        <Font>
          <Name>Calibri</Name>
          <Alignment/>
        </Font>
      </Text>
      <Orientation>Vertical</Orientation>
      <Direction>Top_Bottom</Direction>
      <Separator>
        <Style>Solid</Style>
        <Thickness>1</Thickness>
        <Color>
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Color>
        <Visible>true</Visible>
      </Separator>
      <Position>Right</Position>
      <ItemType>Categories</ItemType>
      <Title>
        <Caption>
          <Value></Value>
          <Font>
            <Alignment/>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>false</Visible>
      </Title>
      <TitlePosition>Above</TitlePosition>
    </Children>
    <Bounds>
      <Left>0.0</Left>
      <Top>0.0</Top>
      <Width>212.0</Width>
      <Height>130.0</Height>
    </Bounds>
    <Insets>
      <Top>3.0</Top>
      <Left>3.0</Left>
      <Bottom>3.0</Bottom>
      <Right>3.0</Right>
    </Insets>
    <Row>-1</Row>
    <Column>-1</Column>
    <Rowspan>-1</Rowspan>
    <Columnspan>-1</Columnspan>
    <Outline>
      <Style>Solid</Style>
      <Thickness>1</Thickness>
      <Color>
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>0</Green>
        <Blue>0</Blue>
      </Color>
      <Visible>false</Visible>
    </Outline>
    <Visible>true</Visible>
  </Block>
  <Dimension>Two_Dimensional</Dimension>
  <Units>Points</Units>
  <SeriesThickness>20.0</SeriesThickness>
  <GridColumnCount>0</GridColumnCount>
  <ExtendedProperties>
    <Name>enable.area.alt</Name>
    <Value>false</Value>
  </ExtendedProperties>
  <SampleData>
    <BaseSampleData>
      <DataSetRepresentation>'A','B','C','D','E'</DataSetRepresentation>
    </BaseSampleData>
    <OrthogonalSampleData>
      <DataSetRepresentation>6,4,12,8,10</DataSetRepresentation>
      <SeriesDefinitionIndex>0</SeriesDefinitionIndex>
    </OrthogonalSampleData>
  </SampleData>
  <Interactivity/>
  <EmptyMessage>
    <Caption>
      <Value>This chart contains no data.</Value>
      <Font>
        <Alignment>
          <horizontalAlignment>Center</horizontalAlignment>
          <verticalAlignment>Center</verticalAlignment>
        </Alignment>
      </Font>
    </Caption>
    <Background xsi:type="attribute:ColorDefinition">
      <Transparency>64</Transparency>
      <Red>127</Red>
      <Green>127</Green>
      <Blue>127</Blue>
    </Background>
    <Outline>
      <Color>
        <Transparency>128</Transparency>
        <Red>127</Red>
        <Green>127</Green>
        <Blue>127</Blue>
      </Color>
      <Visible>true</Visible>
    </Outline>
    <Insets>
      <Top>10.0</Top>
      <Left>10.0</Left>
      <Bottom>10.0</Bottom>
      <Right>10.0</Right>
    </Insets>
    <Visible>false</Visible>
  </EmptyMessage>
  <SeriesDefinitions>
    <Query>
      <Definition></Definition>
    </Query>
    <SeriesPalette>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>0</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>51</Red>
        <Green>104</Green>
        <Blue>183</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>153</Red>
        <Green>204</Green>
        <Blue>255</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>204</Green>
        <Blue>255</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>51</Red>
        <Green>51</Green>
        <Blue>153</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>128</Green>
        <Blue>192</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>170</Red>
        <Green>85</Green>
        <Blue>85</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>128</Green>
        <Blue>0</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>192</Red>
        <Green>192</Green>
        <Blue>192</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>192</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>7</Red>
        <Green>146</Green>
        <Blue>94</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>128</Green>
        <Blue>255</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>128</Green>
        <Blue>192</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>128</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>128</Green>
        <Blue>192</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>128</Green>
        <Blue>192</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>0</Green>
        <Blue>255</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>64</Green>
        <Blue>64</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>128</Green>
        <Blue>64</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>80</Red>
        <Green>240</Green>
        <Blue>120</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>64</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>0</Green>
        <Blue>64</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>0</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>128</Green>
        <Blue>64</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>128</Red>
        <Green>128</Green>
        <Blue>128</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>128</Green>
        <Blue>255</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>64</Green>
        <Blue>0</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>0</Red>
        <Green>0</Green>
        <Blue>0</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>255</Green>
        <Blue>255</Blue>
      </Entries>
      <Entries xsi:type="attribute:ColorDefinition">
        <Transparency>255</Transparency>
        <Red>255</Red>
        <Green>128</Green>
        <Blue>0</Blue>
      </Entries>
    </SeriesPalette>
    <SeriesDefinitions>
      <Query>
        <Definition></Definition>
      </Query>
      <SeriesPalette>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>51</Red>
          <Green>104</Green>
          <Blue>183</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>153</Red>
          <Green>204</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>204</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>51</Red>
          <Green>51</Green>
          <Blue>153</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>170</Red>
          <Green>85</Green>
          <Blue>85</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>192</Red>
          <Green>192</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>192</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>7</Red>
          <Green>146</Green>
          <Blue>94</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>128</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>192</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>0</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>64</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>80</Red>
          <Green>240</Green>
          <Blue>120</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>64</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>0</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>0</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>64</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>128</Red>
          <Green>128</Green>
          <Blue>128</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>64</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>0</Red>
          <Green>0</Green>
          <Blue>0</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Entries>
        <Entries xsi:type="attribute:ColorDefinition">
          <Transparency>255</Transparency>
          <Red>255</Red>
          <Green>128</Green>
          <Blue>0</Blue>
        </Entries>
      </SeriesPalette>
      <Series xsi:type="type:PieSeries">
        <Visible>true</Visible>
        <Label>
          <Caption>
            <Value></Value>
            <Font>
              <Name>Calibri</Name>
              <Alignment/>
            </Font>
          </Caption>
          <Background xsi:type="attribute:ColorDefinition">
            <Transparency>0</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </Background>
          <Outline>
            <Style>Solid</Style>
            <Thickness>1</Thickness>
            <Color>
              <Transparency>255</Transparency>
              <Red>0</Red>
              <Green>0</Green>
              <Blue>0</Blue>
            </Color>
            <Visible>false</Visible>
          </Outline>
          <Insets>
            <Top>0.0</Top>
            <Left>2.0</Left>
            <Bottom>0.0</Bottom>
            <Right>3.0</Right>
          </Insets>
          <Visible>true</Visible>
        </Label>
        <DataDefinition>
          <Definition>row[&quot;orderfact_ordernumber&quot;]</Definition>
          <Grouping>
            <GroupType>Text</GroupType>
            <AggregateExpression>Sum</AggregateExpression>
          </Grouping>
        </DataDefinition>
        <SeriesIdentifier>Series 1</SeriesIdentifier>
        <DataPoint>
          <Components>
            <Type>Orthogonal_Value</Type>
          </Components>
          <Components>
            <Type>Percentile_Orthogonal_Value</Type>
            <FormatSpecifier xsi:type="attribute:JavaNumberFormatSpecifier">
              <Pattern>##.##%</Pattern>
            </FormatSpecifier>
          </Components>
          <Separator>, </Separator>
        </DataPoint>
        <LabelPosition>Outside</LabelPosition>
        <Stacked>false</Stacked>
        <Triggers>
          <Condition>onmouseover</Condition>
          <Action>
            <Type>Show_Tooltip</Type>
            <Value xsi:type="attribute:TooltipValue">
              <Text></Text>
              <Delay>200</Delay>
            </Value>
          </Action>
        </Triggers>
        <Explosion>5</Explosion>
        <Title>
          <Caption>
            <Value></Value>
            <Font>
              <Size>16.0</Size>
              <Bold>true</Bold>
              <Alignment/>
            </Font>
          </Caption>
          <Background xsi:type="attribute:ColorDefinition">
            <Transparency>0</Transparency>
            <Red>255</Red>
            <Green>255</Green>
            <Blue>255</Blue>
          </Background>
          <Outline>
            <Style>Solid</Style>
            <Thickness>1</Thickness>
            <Color>
              <Transparency>255</Transparency>
              <Red>0</Red>
              <Green>0</Green>
              <Blue>0</Blue>
            </Color>
          </Outline>
          <Insets>
            <Top>0.0</Top>
            <Left>2.0</Left>
            <Bottom>0.0</Bottom>
            <Right>3.0</Right>
          </Insets>
          <Visible>false</Visible>
        </Title>
        <TitlePosition>Below</TitlePosition>
        <LeaderLineAttributes>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>true</Visible>
        </LeaderLineAttributes>
        <LeaderLineLength>10.0</LeaderLineLength>
        <InnerRadius>50.0</InnerRadius>
      </Series>
      <Grouping>
        <GroupType>Text</GroupType>
        <AggregateExpression>Sum</AggregateExpression>
      </Grouping>
    </SeriesDefinitions>
    <Series>
      <Visible>true</Visible>
      <Label>
        <Caption>
          <Value></Value>
          <Font>
            <Alignment/>
          </Font>
        </Caption>
        <Background xsi:type="attribute:ColorDefinition">
          <Transparency>0</Transparency>
          <Red>255</Red>
          <Green>255</Green>
          <Blue>255</Blue>
        </Background>
        <Outline>
          <Style>Solid</Style>
          <Thickness>1</Thickness>
          <Color>
            <Transparency>255</Transparency>
            <Red>0</Red>
            <Green>0</Green>
            <Blue>0</Blue>
          </Color>
          <Visible>false</Visible>
        </Outline>
        <Insets>
          <Top>0.0</Top>
          <Left>2.0</Left>
          <Bottom>0.0</Bottom>
          <Right>3.0</Right>
        </Insets>
        <Visible>false</Visible>
      </Label>
      <DataDefinition>
        <Definition>row[&quot;orderfact_status&quot;]</Definition>
      </DataDefinition>
      <SeriesIdentifier></SeriesIdentifier>
      <DataPoint>
        <Components>
          <Type>Orthogonal_Value</Type>
        </Components>
        <Separator>, </Separator>
      </DataPoint>
      <LabelPosition>Outside</LabelPosition>
      <Stacked>false</Stacked>
    </Series>
    <Grouping>
      <Enabled>true</Enabled>
      <GroupType>Text</GroupType>
      <AggregateExpression>Sum</AggregateExpression>
    </Grouping>
  </SeriesDefinitions>
</model:ChartWithoutAxes>
]]></xml-property>
                        <property name="outputFormat">PNG</property>
                        <property name="inheritColumns">false</property>
                        <property name="height">3.5416666666666665in</property>
                        <property name="width">7.072916666666667in</property>
                        <property name="dataSet">setOrders</property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">orderfact_status</property>
                                <expression name="expression" type="javascript">dataSetRow["orderfact_status"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">customers_country</property>
                                <expression name="expression" type="javascript">dataSetRow["customers_country"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">orderfact_ordernumber</property>
                                <expression name="expression" type="javascript">dataSetRow["orderfact_ordernumber"]</expression>
                                <property name="dataType">float</property>
                            </structure>
                        </list-property>
                    </extended-item>
                </cell>
            </row>
            <row id="54">
                <cell id="55">
                    <property name="colSpan">2</property>
                    <property name="rowSpan">1</property>
                    <label id="134">
                        <property name="backgroundColor">#FFFFFF</property>
                        <property name="fontFamily">"Calibri"</property>
                        <property name="fontSize">14pt</property>
                        <property name="fontWeight">bold</property>
                        <property name="color">#000000</property>
                        <property name="marginTop">10pt</property>
                        <property name="paddingTop">1pt</property>
                        <property name="textAlign">center</property>
                        <text-property name="text">Number of Orders by country and status</text-property>
                    </label>
                    <extended-item extensionName="Crosstab" extensionVersion="3.7.0" id="164">
                        <property name="cube">Orders</property>
                        <property name="measures">
                            <extended-item extensionName="MeasureView" id="176">
                                <property name="measure">orderfact_ordernumber</property>
                                <property name="detail">
                                    <extended-item extensionName="AggregationCell" id="177">
                                        <property name="aggregationOnRow">GroupCountry/customers_country</property>
                                        <property name="aggregationOnColumn">GroupStatus/orderfact_status</property>
                                        <list-property name="highlightRules">
                                            <structure>
                                                <property name="operator">is-true</property>
                                                <expression name="testExpr" type="javascript">if (data["orderfact_ordernumber_GroupCountry/customers_country_GroupStatus/orderfact_status"] > 0 &amp;&amp; data["orderfact_ordernumber_GroupCountry/customers_country_GroupStatus/orderfact_status"] &lt;=5) {true;}else{false;}</expression>
                                                <property name="backgroundColor">#FD5A76</property>
                                                <property name="fontSize">12pt</property>
                                                <property name="fontWeight">bold</property>
                                            </structure>
                                        </list-property>
                                        <property name="content">
                                            <data id="178">
                                                <property name="fontFamily">"Calibri"</property>
                                                <structure name="numberFormat">
                                                    <property name="category">Fixed</property>
                                                    <property name="pattern">#,##0{RoundingMode=HALF_UP}</property>
                                                </structure>
                                                <property name="textAlign">center</property>
                                                <list-property name="highlightRules">
                                                    <structure>
                                                        <property name="operator">is-true</property>
                                                        <property name="backgroundColor">#FD5A76</property>
                                                        <expression name="testExpr" type="javascript">if (data["orderfact_ordernumber_GroupCountry/customers_country_GroupStatus/orderfact_status"] > 0 &amp;&amp; data["orderfact_ordernumber_GroupCountry/customers_country_GroupStatus/orderfact_status"] &lt;=5) {true;}else{false;}</expression>
                                                    </structure>
                                                </list-property>
                                                <property name="resultSetColumn">orderfact_ordernumber_GroupCountry/customers_country_GroupStatus/orderfact_status</property>
                                            </data>
                                        </property>
                                    </extended-item>
                                </property>
                                <property name="aggregations">
                                    <extended-item extensionName="AggregationCell" id="182">
                                        <property name="aggregationOnColumn">GroupStatus/orderfact_status</property>
                                        <property name="backgroundColor">#C0C0C0</property>
                                        <property name="borderTopStyle">solid</property>
                                        <property name="borderTopWidth">thin</property>
                                        <property name="borderLeftStyle">solid</property>
                                        <property name="borderLeftWidth">thin</property>
                                        <property name="borderBottomStyle">solid</property>
                                        <property name="borderBottomWidth">thin</property>
                                        <property name="borderRightStyle">solid</property>
                                        <property name="borderRightWidth">thin</property>
                                        <property name="content">
                                            <data id="183">
                                                <property name="fontFamily">"Calibri"</property>
                                                <property name="fontSize">11pt</property>
                                                <property name="fontWeight">bold</property>
                                                <property name="color">#000000</property>
                                                <property name="borderBottomStyle">none</property>
                                                <property name="borderLeftStyle">none</property>
                                                <property name="borderRightStyle">none</property>
                                                <property name="borderTopStyle">none</property>
                                                <structure name="numberFormat">
                                                    <property name="category">Fixed</property>
                                                    <property name="pattern">#,##0{RoundingMode=HALF_UP}</property>
                                                </structure>
                                                <property name="textAlign">center</property>
                                                <property name="display">block</property>
                                                <property name="resultSetColumn">orderfact_ordernumber_GroupStatus/orderfact_status</property>
                                            </data>
                                        </property>
                                    </extended-item>
                                    <extended-item extensionName="AggregationCell" id="232">
                                        <property name="aggregationOnRow">GroupCountry/customers_country</property>
                                        <property name="backgroundColor">#C0C0C0</property>
                                        <property name="content">
                                            <data id="233">
                                                <property name="fontFamily">"Calibri"</property>
                                                <property name="fontSize">11pt</property>
                                                <property name="fontWeight">bold</property>
                                                <property name="fontStyle">normal</property>
                                                <property name="textAlign">center</property>
                                                <property name="resultSetColumn">orderfact_ordernumber_GroupCountry/customers_country</property>
                                            </data>
                                        </property>
                                    </extended-item>
                                    <extended-item extensionName="AggregationCell" id="234">
                                        <property name="backgroundColor">#C0C0C0</property>
                                        <property name="content">
                                            <data id="235">
                                                <property name="fontFamily">"Calibri"</property>
                                                <property name="fontSize">12pt</property>
                                                <property name="fontWeight">bold</property>
                                                <property name="textAlign">center</property>
                                                <property name="resultSetColumn">orderfact_ordernumber</property>
                                            </data>
                                        </property>
                                    </extended-item>
                                </property>
                                <property name="header">
                                    <extended-item extensionName="CrosstabCell" id="179">
                                        <property name="content">
                                            <label id="180">
                                                <text-property name="text">orderfact_ordernumber</text-property>
                                            </label>
                                        </property>
                                    </extended-item>
                                    <extended-item extensionName="CrosstabCell" id="236">
                                        <property name="content">
                                            <label id="237">
                                                <text-property name="text">orderfact_ordernumber</text-property>
                                            </label>
                                        </property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="rows">
                            <extended-item extensionName="CrosstabView" id="171">
                                <property name="grandTotal">
                                    <extended-item extensionName="CrosstabCell" id="181">
                                        <property name="content">
                                            <label id="184">
                                                <property name="fontWeight">bold</property>
                                                <property name="color">#FFFFFF</property>
                                                <text-property name="text">Grand Total</text-property>
                                            </label>
                                        </property>
                                        <property name="fontFamily">"Calibri"</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="color">#FFFFFF</property>
                                        <property name="backgroundColor">#3368B7</property>
                                        <property name="textAlign">center</property>
                                    </extended-item>
                                </property>
                                <property name="views">
                                    <extended-item extensionName="DimensionView" id="172">
                                        <property name="dimension">GroupCountry</property>
                                        <property name="levels">
                                            <extended-item extensionName="LevelView" name="NewLevel View1" id="173">
                                                <property name="level">GroupCountry/customers_country</property>
                                                <property name="member">
                                                    <extended-item extensionName="CrosstabCell" id="174">
                                                        <property name="content">
                                                            <data name="customers_country" id="175">
                                                                <property name="resultSetColumn">customers_country</property>
                                                            </data>
                                                        </property>
                                                        <property name="fontFamily">"Calibri"</property>
                                                        <property name="fontWeight">bold</property>
                                                        <property name="color">#FFFFFF</property>
                                                        <property name="backgroundColor">#3368B7</property>
                                                        <property name="textAlign">center</property>
                                                    </extended-item>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="columns">
                            <extended-item extensionName="CrosstabView" id="166">
                                <property name="grandTotal">
                                    <extended-item extensionName="CrosstabCell" id="231">
                                        <property name="content">
                                            <label id="238">
                                                <text-property name="text">Grand Total</text-property>
                                            </label>
                                        </property>
                                        <property name="fontFamily">"Calibri"</property>
                                        <property name="fontWeight">bold</property>
                                        <property name="color">#FFFFFF</property>
                                        <property name="backgroundColor">#3368B7</property>
                                        <property name="textAlign">center</property>
                                    </extended-item>
                                </property>
                                <property name="views">
                                    <extended-item extensionName="DimensionView" id="167">
                                        <property name="dimension">GroupStatus</property>
                                        <property name="levels">
                                            <extended-item extensionName="LevelView" name="NewLevel View" id="168">
                                                <property name="level">GroupStatus/orderfact_status</property>
                                                <property name="member">
                                                    <extended-item extensionName="CrosstabCell" id="169">
                                                        <property name="content">
                                                            <data name="orderfact_status" id="170">
                                                                <property name="fontWeight">bold</property>
                                                                <property name="color">#FFFFFF</property>
                                                                <property name="textAlign">center</property>
                                                                <property name="resultSetColumn">orderfact_status</property>
                                                            </data>
                                                        </property>
                                                        <property name="fontFamily">"Calibri"</property>
                                                        <property name="fontWeight">bold</property>
                                                        <property name="color">#FFFFFF</property>
                                                        <property name="backgroundColor">#3368B7</property>
                                                        <property name="textAlign">center</property>
                                                    </extended-item>
                                                </property>
                                            </extended-item>
                                        </property>
                                    </extended-item>
                                </property>
                            </extended-item>
                        </property>
                        <property name="header">
                            <extended-item extensionName="CrosstabCell" id="165">
                                <property name="fontFamily">"Calibri"</property>
                                <property name="fontWeight">bold</property>
                                <property name="color">#FFFFFF</property>
                                <property name="backgroundColor">#3368B7</property>
                                <property name="textAlign">center</property>
                            </extended-item>
                        </property>
                        <property name="hideMeasureHeader">true</property>
                        <property name="marginTop">10pt</property>
                        <list-property name="boundDataColumns">
                            <structure>
                                <property name="name">orderfact_status</property>
                                <expression name="expression">dimension["GroupStatus"]["orderfact_status"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">customers_country</property>
                                <expression name="expression">dimension["GroupCountry"]["customers_country"]</expression>
                                <property name="dataType">string</property>
                            </structure>
                            <structure>
                                <property name="name">orderfact_ordernumber_GroupCountry/customers_country_GroupStatus/orderfact_status</property>
                                <property name="dataType">integer</property>
                                <simple-property-list name="aggregateOn">
                                    <value>GroupCountry/customers_country</value>
                                    <value>GroupStatus/orderfact_status</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">measure["orderfact_ordernumber"]</expression>
                                    </structure>
                                </list-property>
                            </structure>
                            <structure>
                                <property name="name">orderfact_ordernumber_GroupStatus/orderfact_status</property>
                                <property name="dataType">integer</property>
                                <simple-property-list name="aggregateOn">
                                    <value>GroupStatus/orderfact_status</value>
                                </simple-property-list>
                                <property name="aggregateFunction">SUM</property>
                                <list-property name="arguments">
                                    <structure>
                                        <property name="name">Expression</property>
                                        <expression name="value" type="javascript">measure["orderfact_ordernumber"]</expression>
                                    </structure>
                                </list-property>
                            </structure>
                            <structure>
                                <property name="name">orderfact_ordernumber_GroupCountry/customers_country</property>
                                <expression name="expression">measure["orderfact_ordernumber"]</expression>
                                <property name="dataType">float</property>
                                <simple-property-list name="aggregateOn">
                                    <value>GroupCountry/customers_country</value>
                                </simple-property-list>
                                <property name="aggregateFunction">sum</property>
                            </structure>
                            <structure>
                                <property name="name">orderfact_ordernumber</property>
                                <expression name="expression">measure["orderfact_ordernumber"]</expression>
                                <property name="dataType">float</property>
                                <property name="aggregateFunction">sum</property>
                            </structure>
                        </list-property>
                    </extended-item>
                </cell>
            </row>
        </grid>
    </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">BPMConseil_Logo.jpg</property>
            <property name="data">
                [encoded data, 137230 characters]
</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>
    </list-property>
</report>
