<freeanalysis-schema>
    <version>4.0</version>
    <id>0</id>
    <isSynchronized>false</isSynchronized>
    <document-properties>
        <name>Sales_Analysis</name>
        <author>Charles Martin</author>
        <description>Cube based on the demo_sampledata database</description>
        <creation-date>2011-12-06</creation-date>
        <modification-date>2014-11-26</modification-date>
        <version>1.0</version>
    </document-properties>

    <datasources>
	<datasource-oda>
		<name>sourcedemo_sampledata</name>
		<id>t1</id>
		<odadatasourceextensionid>org.eclipse.birt.report.data.oda.jdbc</odadatasourceextensionid>
		<odaextensionid>org.eclipse.birt.report.data.oda.jdbc</odaextensionid>
		<public-properties>
			<property><name>odaJndiName</name><value></value></property>
			<property><name>odaDriverClass</name><value>org.h2.Driver</value></property>
			<property><name>odaURL</name><value>jdbc:h2:./h2/sampledata;AUTO_SERVER=TRUE;DATABASE_TO_UPPER=FALSE</value></property>
			<property><name>odaPassword</name><value>biplatform</value></property>
			<property><name>odaUser</name><value>biplatform</value></property>
			<property><name>odaAutoCommit</name><value>false</value></property>
		</public-properties>
		<private-properties>
			<property><name>disabledMetadataBidiFormatStr</name><value></value></property>
			<property><name>disabledContentBidiFormatStr</name><value></value></property>
			<property><name>contentBidiFormatStr</name><value>ILYNN</value></property>
			<property><name>metadataBidiFormatStr</name><value>ILYNN</value></property>
		</private-properties>
		<dataobject-oda>
				<id>c1</id>
				<name>setCustomers</name>
				<data-source-id>t1</data-source-id>
				<datasetextensionid>org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet</datasetextensionid>
				<public-properties>
				</public-properties>
				<private-properties>
				</private-properties>
				<querytext><![CDATA[select 
customers.customernumber,
customers.customername,
customers.city,
customers.country
from customers]]></querytext>
				<dataobjecttype>dimension</dataobjecttype>
                <item>
                    <id>l1</id>
                    <name>customernumber</name>
                    <origin>public.customernumber</origin>
                    <type>physical</type>
                    <classe>java.lang.Long</classe>
                    <sql-type>INT UNSIGNED</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
                <item>
                    <id>l2</id>
                    <name>customername</name>
                    <origin>public.customername</origin>
                    <type>physical</type>
                    <classe>java.lang.String</classe>
                    <sql-type>VARCHAR</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
                <item>
                    <id>l3</id>
                    <name>city</name>
                    <origin>public.city</origin>
                    <type>physical</type>
                    <classe>java.lang.String</classe>
                    <sql-type>VARCHAR</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
                <item>
                    <id>l4</id>
                    <name>country</name>
                    <origin>public.country</origin>
                    <type>physical</type>
                    <classe>java.lang.String</classe>
                    <sql-type>VARCHAR</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
</dataobject-oda>
		<dataobject-oda>
				<id>c2</id>
				<name>setProducts</name>
				<data-source-id>t1</data-source-id>
				<datasetextensionid>org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet</datasetextensionid>
				<public-properties>
				</public-properties>
				<private-properties>
				</private-properties>
				<querytext><![CDATA[select 
products.productline,
products.productname,
products.productcode
from products]]></querytext>
				<dataobjecttype>dimension</dataobjecttype>
                <item>
                    <id>l5</id>
                    <name>productline</name>
                    <origin>public.productline</origin>
                    <type>physical</type>
                    <classe>java.lang.String</classe>
                    <sql-type>VARCHAR</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
                <item>
                    <id>l6</id>
                    <name>productname</name>
                    <origin>public.productname</origin>
                    <type>physical</type>
                    <classe>java.lang.String</classe>
                    <sql-type>VARCHAR</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
                <item>
                    <id>l7</id>
                    <name>productcode</name>
                    <origin>public.productcode</origin>
                    <type>physical</type>
                    <classe>java.lang.String</classe>
                    <sql-type>VARCHAR</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
</dataobject-oda>
		<dataobject-oda>
				<id>c3</id>
				<name>setTime</name>
				<data-source-id>t1</data-source-id>
				<datasetextensionid>org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet</datasetextensionid>
				<public-properties>
				</public-properties>
				<private-properties>
				</private-properties>
				<querytext><![CDATA[select 
timeline.id,
timeline.year_nb,
timeline.month_nb,
timeline.day_nb
from timeline]]></querytext>
				<dataobjecttype>dimension</dataobjecttype>
                <item>
                    <id>l8</id>
                    <name>id</name>
                    <origin>public.id</origin>
                    <type>physical</type>
                    <classe>java.lang.String</classe>
                    <sql-type>VARCHAR</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
                <item>
                    <id>l9</id>
                    <name>year_nb</name>
                    <origin>public.year_nb</origin>
                    <type>physical</type>
                    <classe>java.lang.String</classe>
                    <sql-type>VARCHAR</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
                <item>
                    <id>l10</id>
                    <name>month_nb</name>
                    <origin>public.month_nb</origin>
                    <type>physical</type>
                    <classe>java.lang.String</classe>
                    <sql-type>VARCHAR</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
                <item>
                    <id>l11</id>
                    <name>day_nb</name>
                    <origin>public.day_nb</origin>
                    <type>physical</type>
                    <classe>java.lang.String</classe>
                    <sql-type>VARCHAR</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
</dataobject-oda>
		<dataobject-oda>
				<id>c4</id>
				<name>setOrders</name>
				<data-source-id>t1</data-source-id>
				<datasetextensionid>org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet</datasetextensionid>
				<public-properties>
				</public-properties>
				<private-properties>
				</private-properties>
				<querytext><![CDATA[select 
orderfact.productcode,
orderfact.customernumber,
orderfact.time_id,
orderfact.totalprice,
orderfact.quantityordered
from orderfact]]></querytext>
				<dataobjecttype>fact</dataobjecttype>
                <item>
                    <id>l12</id>
                    <name>productcode</name>
                    <origin>public.productcode</origin>
                    <type>physical</type>
                    <classe>java.lang.String</classe>
                    <sql-type>VARCHAR</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
                <item>
                    <id>l13</id>
                    <name>customernumber</name>
                    <origin>public.customernumber</origin>
                    <type>physical</type>
                    <classe>java.lang.Integer</classe>
                    <sql-type>INT</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
                <item>
                    <id>l14</id>
                    <name>time_id</name>
                    <origin>public.time_id</origin>
                    <type>physical</type>
                    <classe>java.lang.String</classe>
                    <sql-type>VARCHAR</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
                <item>
                    <id>l15</id>
                    <name>totalprice</name>
                    <origin>public.totalprice</origin>
                    <type>physical</type>
                    <classe>java.lang.Double</classe>
                    <sql-type>DOUBLE</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
                <item>
                    <id>l16</id>
                    <name>quantityordered</name>
                    <origin>public.quantityordered</origin>
                    <type>physical</type>
                    <classe>java.lang.Integer</classe>
                    <sql-type>INT</sql-type>
                    <attribut>U</attribut>
                    <description></description>
                </item>
</dataobject-oda>
	</datasource-oda>
    </datasources>
    <object-relation>
        <object-relation-item>
             <id>l1</id>
             <name>[setOrderstime_id] = [setTimeid]</name>
             <left-object-id>c4</left-object-id>
             <right-object-id>c3</right-object-id>
             <relation-formula>
                 <left-object-column-id>l14</left-object-column-id>
                 <right-object-column-id>l8</right-object-column-id>
                 <object-columns-relation>=</object-columns-relation>
             </relation-formula>
        </object-relation-item>
        <object-relation-item>
             <id>l2</id>
             <name>[setOrderscustomernumber] = [setCustomerscustomernumber]</name>
             <left-object-id>c4</left-object-id>
             <right-object-id>c1</right-object-id>
             <relation-formula>
                 <left-object-column-id>l13</left-object-column-id>
                 <right-object-column-id>l1</right-object-column-id>
                 <object-columns-relation>=</object-columns-relation>
             </relation-formula>
        </object-relation-item>
        <object-relation-item>
             <id>l3</id>
             <name>[setOrdersproductcode] = [setProductsproductcode]</name>
             <left-object-id>c4</left-object-id>
             <right-object-id>c2</right-object-id>
             <relation-formula>
                 <left-object-column-id>l12</left-object-column-id>
                 <right-object-column-id>l7</right-object-column-id>
                 <object-columns-relation>=</object-columns-relation>
             </relation-formula>
        </object-relation-item>
    </object-relation>
<security>
    <server-connection>
    </server-connection>
    <security-provider>
    </security-provider>
</security>
<olap>

    <defaultRoleName></defaultRoleName>
    <measureCaption></measureCaption>
    <UserDefinedFunctions>
    </UserDefinedFunctions>
    <Dimension-group>
    </Dimension-group>
    <Measure-group>
    </Measure-group>
    <Security-group>
    </Security-group>
    <Aggregate>
    </Aggregate>
    <Dimension>
    <Dimension-item>
        <id>g1</id>
        <name>Customers</name>
        <caption></caption>
        <description></description>
        <dimension-group-id></dimension-group-id>
        <IsDate>false</IsDate>
        <LoadMethod>cube_startup</LoadMethod>
        <order></order>
        <properties></properties>
        <geolicalisable>true</geolicalisable>
		<isOneColumnDate>false</isOneColumnDate>
        <Hierarchy>
            <id>n1</id>
            <name>defaultHiera</name>
            <caption></caption>
            <memberReaderClass></memberReaderClass>
            <allMemberCaption></allMemberCaption>
            <desc></desc>
            <dimension-id>g1</dimension-id>
            <allMember>All Customers</allMember>
            <Level>
                <id>o1</id>
                <name>Country</name>
                <caption></caption>
                <captionColumn></captionColumn>
                <formatter></formatter>
                <type></type>
                <levelType></levelType>
                <ordinalColumn></ordinalColumn>
                <level-nb>0</level-nb>
                <hierarchy-parent-id>n1</hierarchy-parent-id>
                <description></description>
                <uniqueMembers>false</uniqueMembers>
                <dataobjectitem-code-id>l4</dataobjectitem-code-id>
                <closure-dataobject-id></closure-dataobject-id>
                <closure-parent-dataobjectitem-id></closure-parent-dataobjectitem-id>
                <closure-child-dataobjectitem-id></closure-child-dataobjectitem-id>
                <null-parent-value></null-parent-value>
            <Property>
                <id>1</id>
                <caption></caption>
                <name>geolocalizableProperty</name>
                <dataobjectitem-id>l4</dataobjectitem-id>
                <type>String</type>
                <formatter></formatter>
            </Property>
            </Level>
            <Level>
                <id>o2</id>
                <name>City</name>
                <caption></caption>
                <captionColumn></captionColumn>
                <formatter></formatter>
                <type></type>
                <levelType></levelType>
                <ordinalColumn></ordinalColumn>
                <level-nb>1</level-nb>
                <hierarchy-parent-id>n1</hierarchy-parent-id>
                <description></description>
                <uniqueMembers>false</uniqueMembers>
                <dataobjectitem-code-id>l3</dataobjectitem-code-id>
                <closure-dataobject-id></closure-dataobject-id>
                <closure-parent-dataobjectitem-id></closure-parent-dataobjectitem-id>
                <closure-child-dataobjectitem-id></closure-child-dataobjectitem-id>
                <null-parent-value></null-parent-value>
            <Property>
                <id>2</id>
                <caption></caption>
                <name>geolocalizableProperty</name>
                <dataobjectitem-id>l3</dataobjectitem-id>
                <type>String</type>
                <formatter></formatter>
            </Property>
            </Level>
            <Level>
                <id>o3</id>
                <name>Customername</name>
                <caption></caption>
                <captionColumn></captionColumn>
                <formatter></formatter>
                <type></type>
                <levelType></levelType>
                <ordinalColumn></ordinalColumn>
                <level-nb>2</level-nb>
                <hierarchy-parent-id>n1</hierarchy-parent-id>
                <description></description>
                <uniqueMembers>false</uniqueMembers>
                <dataobjectitem-code-id>l2</dataobjectitem-code-id>
                <closure-dataobject-id></closure-dataobject-id>
                <closure-parent-dataobjectitem-id></closure-parent-dataobjectitem-id>
                <closure-child-dataobjectitem-id></closure-child-dataobjectitem-id>
                <null-parent-value></null-parent-value>
            </Level>
        </Hierarchy>
    </Dimension-item>
    <Dimension-item>
        <id>g2</id>
        <name>Time</name>
        <caption></caption>
        <description></description>
        <dimension-group-id></dimension-group-id>
        <IsDate>true</IsDate>
        <LoadMethod>cube_startup</LoadMethod>
        <order></order>
        <properties></properties>
        <geolicalisable>false</geolicalisable>
		<isOneColumnDate>false</isOneColumnDate>
        <Hierarchy>
            <id>n2</id>
            <name>defaultHiera</name>
            <caption></caption>
            <memberReaderClass></memberReaderClass>
            <allMemberCaption></allMemberCaption>
            <desc></desc>
            <dimension-id>g2</dimension-id>
            <allMember>All Time</allMember>
            <Level>
                <id>o4</id>
                <name>Year</name>
                <caption></caption>
                <captionColumn></captionColumn>
                <formatter></formatter>
                <type></type>
                <levelType></levelType>
                <ordinalColumn></ordinalColumn>
                <level-nb>0</level-nb>
                <hierarchy-parent-id>n2</hierarchy-parent-id>
                <description></description>
                <uniqueMembers>false</uniqueMembers>
                <dataobjectitem-code-id>l9</dataobjectitem-code-id>
                <closure-dataobject-id></closure-dataobject-id>
                <closure-parent-dataobjectitem-id></closure-parent-dataobjectitem-id>
                <closure-child-dataobjectitem-id></closure-child-dataobjectitem-id>
                <null-parent-value></null-parent-value>
            </Level>
            <Level>
                <id>o5</id>
                <name>Month</name>
                <caption></caption>
                <captionColumn></captionColumn>
                <formatter></formatter>
                <type></type>
                <levelType></levelType>
                <ordinalColumn></ordinalColumn>
                <level-nb>1</level-nb>
                <hierarchy-parent-id>n2</hierarchy-parent-id>
                <description></description>
                <uniqueMembers>false</uniqueMembers>
                <dataobjectitem-code-id>l10</dataobjectitem-code-id>
                <closure-dataobject-id></closure-dataobject-id>
                <closure-parent-dataobjectitem-id></closure-parent-dataobjectitem-id>
                <closure-child-dataobjectitem-id></closure-child-dataobjectitem-id>
                <null-parent-value></null-parent-value>
            </Level>
            <Level>
                <id>o6</id>
                <name>Day</name>
                <caption></caption>
                <captionColumn></captionColumn>
                <formatter></formatter>
                <type></type>
                <levelType></levelType>
                <ordinalColumn></ordinalColumn>
                <level-nb>2</level-nb>
                <hierarchy-parent-id>n2</hierarchy-parent-id>
                <description></description>
                <uniqueMembers>false</uniqueMembers>
                <dataobjectitem-code-id>l11</dataobjectitem-code-id>
                <closure-dataobject-id></closure-dataobject-id>
                <closure-parent-dataobjectitem-id></closure-parent-dataobjectitem-id>
                <closure-child-dataobjectitem-id></closure-child-dataobjectitem-id>
                <null-parent-value></null-parent-value>
            </Level>
        </Hierarchy>
    </Dimension-item>
    <Dimension-item>
        <id>g3</id>
        <name>Products</name>
        <caption></caption>
        <description></description>
        <dimension-group-id></dimension-group-id>
        <IsDate>false</IsDate>
        <LoadMethod>cube_startup</LoadMethod>
        <order></order>
        <properties></properties>
        <geolicalisable>false</geolicalisable>
		<isOneColumnDate>false</isOneColumnDate>
        <Hierarchy>
            <id>n3</id>
            <name>defaultHiera</name>
            <caption></caption>
            <memberReaderClass></memberReaderClass>
            <allMemberCaption></allMemberCaption>
            <desc></desc>
            <dimension-id>g3</dimension-id>
            <allMember>All Products</allMember>
            <Level>
                <id>o7</id>
                <name>Productline</name>
                <caption></caption>
                <captionColumn></captionColumn>
                <formatter></formatter>
                <type></type>
                <levelType></levelType>
                <ordinalColumn></ordinalColumn>
                <level-nb>0</level-nb>
                <hierarchy-parent-id>n3</hierarchy-parent-id>
                <description></description>
                <uniqueMembers>false</uniqueMembers>
                <dataobjectitem-code-id>l5</dataobjectitem-code-id>
                <closure-dataobject-id></closure-dataobject-id>
                <closure-parent-dataobjectitem-id></closure-parent-dataobjectitem-id>
                <closure-child-dataobjectitem-id></closure-child-dataobjectitem-id>
                <null-parent-value></null-parent-value>
            </Level>
            <Level>
                <id>o8</id>
                <name>Productname</name>
                <caption></caption>
                <captionColumn></captionColumn>
                <formatter></formatter>
                <type></type>
                <levelType></levelType>
                <ordinalColumn></ordinalColumn>
                <level-nb>1</level-nb>
                <hierarchy-parent-id>n3</hierarchy-parent-id>
                <description></description>
                <uniqueMembers>false</uniqueMembers>
                <dataobjectitem-code-id>l6</dataobjectitem-code-id>
                <closure-dataobject-id></closure-dataobject-id>
                <closure-parent-dataobjectitem-id></closure-parent-dataobjectitem-id>
                <closure-child-dataobjectitem-id></closure-child-dataobjectitem-id>
                <null-parent-value></null-parent-value>
            </Level>
        </Hierarchy>
    </Dimension-item>
    </Dimension>
    <Measure>
    <Measure-item>
        <id>h1</id>
        <name>Price</name>
        <caption></caption>
        <description></description>
        <measure-group-id></measure-group-id>
        <type>physical</type>
        <order>0</order>
        <origin-id>l15</origin-id>
        <formula></formula>
        <label></label>
        <visible>true</visible>
        <aggregator>sum</aggregator>
        <color-rules><![CDATA[null]]></color-rules>
        <formatString>Standard</formatString>
    </Measure-item>
    <Measure-item>
        <id>h2</id>
        <name>Quantity</name>
        <caption></caption>
        <description></description>
        <measure-group-id></measure-group-id>
        <type>physical</type>
        <order>0</order>
        <origin-id>l16</origin-id>
        <formula></formula>
        <label></label>
        <visible>true</visible>
        <aggregator>sum</aggregator>
        <color-rules><![CDATA[null]]></color-rules>
        <formatString>Standard</formatString>
    </Measure-item>
    </Measure>
    <Cube>
    <Cube-item>
        <id>i1</id>
        <name>Sales Analysis</name>
        <defaultMeasure></defaultMeasure>
        <enabled>true</enabled>
        <cached>true</cached>
        <description></description>
        <type>Rolap</type>
        <fact-dataobject-id>c4</fact-dataobject-id>
        <datasource-id>t1</datasource-id>
        <dimension-item-id>g1</dimension-item-id>
        <dimension-item-id>g2</dimension-item-id>
        <dimension-item-id>g3</dimension-item-id>
        <measure-item-id>h1</measure-item-id>
        <measure-item-id>h2</measure-item-id>
    </Cube-item>
    </Cube>
    <VirtualCube>
    </VirtualCube>
    <NamedSets>
    </NamedSets>
</olap>

</freeanalysis-schema>

