<Schema name="FKlubDW">
    <Cube name="Sales">
        <Table name="sales"/>
        <Dimension name="Product" foreignKey="productid">
            <Hierarchy hasAll="true" allMemberName="All Products" primaryKey="productid">
                <Table name="product"/>
                <Level name="Name" column="name" uniqueMembers="true"/>
            </Hierarchy>
        </Dimension>
        <Dimension name="Time" foreignKey="timeid">
            <Hierarchy hasAll="false" primaryKey="timeid">
                <Table name="time"/>
                <Level name="Hour" column="hour" type="Numeric" uniqueMembers="true"/>
                <Level name="Minute" column="minute" type="Numeric" uniqueMembers="true"/>
            </Hierarchy>
        </Dimension>
        <Dimension name="Date" foreignKey="dateid">
            <Hierarchy hasAll="false" primaryKey="dateid">
                <Table name="date"/>
                <Level name="Year" column="year" type="Numeric" uniqueMembers="true"/>
                <Level name="Month" column="month" type="Numeric" uniqueMembers="true"/>
                <Level name="Day" column="day" type="Numeric" uniqueMembers="true"/>
                <Level name="Special" column="special" uniqueMembers="false"/>
            </Hierarchy>
        </Dimension>
        <Dimension name="Member" foreignKey="memberid">
            <Hierarchy hasAll="false" primaryKey="memberid">
                <Table name="member"/>
                <Level name="Balance" column="balance" uniqueMembers="true"/>
                <Level name="Year" column="year" uniqueMembers="false"/>
            </Hierarchy>
        </Dimension>
        <Measure name="Sale Price" column="sales" aggregator="sum" formatString="#,###"/>
    </Cube>
</Schema>