Subversion Repositories SmartDukaan

<Schema name="SalesSchema">
        <Cube name="SalesCube" cache="true" enabled="true">
                <Table name="salesNew">
                </Table>
                <Dimension type="TimeDimension" foreignKey="date_id" name="OrderDate">
                        <Hierarchy name="OrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
                                <Table name="datedim">
                                </Table>
                                <Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
                                </Level>
                                <Level name="Quarter" column="quarter" type="String" uniqueMembers="true" levelType="TimeQuarters" hideMemberIf="Never">
                                </Level>
                                <Level name="Month" column="monthname" type="String" uniqueMembers="true" levelType="TimeMonths" hideMemberIf="Never">
                                </Level>
                                <Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="true" levelType="TimeDays" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="pincode" name="Geography">
                        <Hierarchy name="Territory" hasAll="true" allMemberName="All" primaryKey="pincode">
                                <Table name="pincodesB">
                                </Table>
                                <Level name="State" column="state" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level name="City" column="city" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level name="Pincode" column="pincode" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="status" name="OrderStatus">
                        <Hierarchy name="StatusDim" hasAll="true" allMemberName="All" primaryKey="status">
                                <Table name="orderstatus">
                                </Table>
                                <Level name="IsValid" column="isvalid" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level name="Status" column="description" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="item_id" name="Product">
                        <Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="id">
                                <Table name="item">
                                </Table>
                                <Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level name="Color" column="color" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Measure name="TotalSales" column="unit_price" datatype="Numeric" formatString="##,###.00" aggregator="sum" visible="true">
                </Measure>
                <Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
                </Measure>
        </Cube>
</Schema>