Subversion Repositories SmartDukaan

<Schema name="RepeatSalesSchema">
        <Cube name="RepeatSalesCube" cache="true" enabled="true">
                <Table name="repeatSales">
                </Table>
                <Dimension type="TimeDimension" foreignKey="date_id1" name="First Order Date">
                        <Hierarchy name="FirstOrderDate" 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 approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
                                </Level>
                                <Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
                                </Level>
                                <Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" name="Order Count">
                        <Hierarchy name="Order Count" hasAll="true" allMemberName="All">
                                <Level name="orderCount" table="repeatSales" column="orderCount" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                        <KeyExpression>
                                                <SQL dialect="generic">
                                                        case when orderCount &#60;= 5 then convert(orderCount, char) when orderCount &#62; 5 then &#39;more than 5 orders&#39; end                                              </SQL>
                                        </KeyExpression>
                                        <NameExpression>
                                                <SQL dialect="generic">
                                                        case when orderCount &#60;= 5 then convert(orderCount, char) when orderCount &#62; 5 then &#39;more than 5 orders&#39; end                                              </SQL>
                                        </NameExpression>
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="TimeDimension" foreignKey="date_id2" name="Second Order Date">
                        <Hierarchy name="SecondOrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
                                <Table name="datedim" alias="datedim2">
                                </Table>
                                <Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
                                </Level>
                                <Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
                                </Level>
                                <Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
                                </Level>
                                <Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="grandTotal" name="Grand Total">
                        <Hierarchy name="GrandTotal" hasAll="true" allMemberName="All" primaryKey="id">
                                <Table name="pricerange">
                                </Table>
                                <Level name="Price Range 1" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="averageValue" name="Average Value">
                        <Hierarchy name="averageValue" hasAll="true" allMemberName="All" primaryKey="id">
                                <Table name="pricerange" alias="pricerange5">
                                </Table>
                                <Level name="Price Range 1" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="daysToSecondPurchase" name="Days To Second Purchase">
                        <Hierarchy name="Days To Second Purchase" hasAll="true" allMemberName="All" primaryKey="id">
                                <Table name="daystopurchaserange" alias="SecondPurchaseDaysRange">
                                </Table>
                                <Level name="Days To Second Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="daysToFirstPurchase" name="Days To First Purchase">
                        <Hierarchy name="Days To First Purchase" hasAll="true" allMemberName="All" primaryKey="id">
                                <Table name="daystopurchaserange" alias="firstPurchaseDaysRange">
                                </Table>
                                <Level name="Days To First Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="price_range1" name="First Order Value">
                        <Hierarchy name="First Order Value" hasAll="true" allMemberName="All" primaryKey="id">
                                <Table name="pricerange" alias="firstOrderPrice">
                                </Table>
                                <Level name="Price Range 2" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="price_range2" name="Second Order Value">
                        <Hierarchy name="Second Order Value" hasAll="true" allMemberName="All" primaryKey="id">
                                <Table name="pricerange" alias="secondOrderPrice">
                                </Table>
                                <Level name="Price Range 3" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="pin" name="Geography">
                        <Hierarchy name="Territory" hasAll="true" allMemberName="All" primaryKey="pincode">
                                <Table name="pincodesB">
                                </Table>
                                <Level approxRowCount="25" name="State" column="state" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level approxRowCount="10" 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="item1" name="First Product Category">
                        <Hierarchy name="First Product Category" hasAll="true" allMemberName="All" primaryKey="id">
                                <Table name="item">
                                </Table>
                                <Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="item2" name="Second Product Category">
                        <Hierarchy name="Second Product Category" hasAll="true" allMemberName="All" primaryKey="id">
                                <Table name="item" alias="secondItem">
                                </Table>
                                <Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" name="First Session Source">
                        <Hierarchy name="First Session Source" hasAll="true" allMemberName="All">
                                <Level name="Source" table="repeatSales" column="session_source_url1" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                        <KeyExpression>
                                                <SQL dialect="generic">
                                                        case when session_source_type1 = &#39;Paid&#39; then &#39;Paid&#39; when session_source_url1 like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source_url1 like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end                                              </SQL>
                                        </KeyExpression>
                                        <NameExpression>
                                                <SQL dialect="generic">
                                                        case when session_source_type1 = &#39;Paid&#39; then &#39;Paid&#39; when session_source_url1 like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source_url1 like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end                                              </SQL>
                                        </NameExpression>
                                </Level>
                                <Level name="Site" table="repeatSales" column="session_source_url1" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" name="Second Session Source">
                        <Hierarchy name="Second Session Source" hasAll="true" allMemberName="All">
                                <Level name="Source" table="repeatSales" column="session_source_url2" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                        <KeyExpression>
                                                <SQL dialect="generic">
                                                        case when session_source_type2 = &#39;Paid&#39; then &#39;Paid&#39; when session_source_url2 like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source_url2 like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end                                              </SQL>
                                        </KeyExpression>
                                        <NameExpression>
                                                <SQL dialect="generic">
                                                        case when session_source_type2 = &#39;Paid&#39; then &#39;Paid&#39; when session_source_url2 like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source_url2 like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end                                              </SQL>
                                        </NameExpression>
                                </Level>
                                <Level name="Site" table="repeatSales" column="session_source_url2" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" name="First Pay Mode">
                        <Hierarchy name="First Pay Mode" hasAll="true" allMemberName="All">
                                <Level name="paymode1" table="repeatSales" column="paymode1" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                        <KeyExpression>
                                                <SQL dialect="generic">
                                                        case when paymode1 = 1 then &#39;COD&#39; when paymode1 = 0 then &#39;Prepaid&#39; end                                          </SQL>
                                        </KeyExpression>
                                        <NameExpression>
                                                <SQL dialect="generic">
                                                        case when paymode1 = 1 then &#39;COD&#39; when paymode1 = 0 then &#39;Prepaid&#39; end                                          </SQL>
                                        </NameExpression>
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" name="Second Pay Mode">
                        <Hierarchy name="Second Pay Mode" hasAll="true" allMemberName="All">
                                <Level name="paymode2" table="repeatSales" column="paymode2" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                        <KeyExpression>
                                                <SQL dialect="generic">
                                                        case when paymode2 = 1 then &#39;COD&#39; when paymode1 = 0 then &#39;Prepaid&#39; end                                          </SQL>
                                        </KeyExpression>
                                        <NameExpression>
                                                <SQL dialect="generic">
                                                        case when paymode2 = 1 then &#39;COD&#39; when paymode1 = 0 then &#39;Prepaid&#39; end                                          </SQL>
                                        </NameExpression>
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Measure name="UserCount" column="customer_id" datatype="Numeric" formatString="###,###,###" aggregator="count" visible="true">
                </Measure>
        </Cube>
</Schema>