foodmart_aggregate

<?xml version='1.0'?>
<Schema name='FoodMart' metamodelVersion='4.0'>
    <!--
    == This software is subject to the terms of the Eclipse Public License v1.0
    == Agreement, available at the following URL:
    == http://www.eclipse.org/legal/epl-v10.html.
    == You must accept the terms of that agreement to use this software.
    ==
    == Copyright (C) 2000-2005 Julian Hyde
    == Copyright (C) 2005-2013 Pentaho and others
    == All Rights Reserved.
    -->

    <PhysicalSchema>

        <Table name='store'>
            <Key>
                <Column name='store_id'/>
            </Key>
        </Table>

        <Table name='sales_fact_1997'/>

        <Table name='agg_c_special_sales_fact_1997'/>

    </PhysicalSchema>

    <Dimension name='Store Dimension' table='store' key='Store Id'>
        <Attributes>
            <Attribute name='Store Country' hasHierarchy='false'>
                <Key>
                    <Column name='store_country'/>
                </Key>
            </Attribute>
            <Attribute name='Store State' keyColumn='store_state' hasHierarchy='false'/>
            <Attribute name='Store City' hasHierarchy='false'>
                <Key>
                    <Column name='store_state'/>
                    <Column name='store_city'/>
                </Key>
                <Name>
                    <Column name='store_city'/>
                </Name>
            </Attribute>
            <Attribute name='Store Id' keyColumn='store_id' hasHierarchy='false'/>

        </Attributes>

        <Hierarchies>
            <Hierarchy name='Stores' allMemberName='All Stores'>
                <Level attribute='Store State'/>
            </Hierarchy>

        </Hierarchies>
    </Dimension>

    <Cube name='Sales With Pre-aggregates'>
        <Dimensions>

            <Dimension source='Store Dimension'/>
        </Dimensions>


        <MeasureGroups>
            <MeasureGroup name='Sales' table='sales_fact_1997'>
                <Measures>
                    <Measure name='Store Cost' column='store_cost' aggregator='sum' formatString='#,###.00'/>
                    <Measure name='Store Sales' column='store_sales' aggregator='sum' formatString='#,###.00'/>
                </Measures>
                <DimensionLinks>
                    <ForeignKeyLink dimension='Store Dimension' foreignKeyColumn='store_id'/>
                </DimensionLinks>
            </MeasureGroup>
            <MeasureGroup table='agg_c_special_sales_fact_1997' type='aggregate'>
                <Measures>
                    <MeasureRef name='Store Cost' aggColumn='store_cost_sum'/>
                    <MeasureRef name='Store Sales' aggColumn='store_sales_sum'/>
                </Measures>
                <DimensionLinks>
                    <ForeignKeyLink dimension='Store Dimension' foreignKeyColumn='store_id'/>
                </DimensionLinks>
            </MeasureGroup>
    </MeasureGroups>
    </Cube>

</Schema>