Subversion Repositories SmartDukaan

<Schema name="ProductActivitySchema">
        <Cube name="ProductActivityCube" cache="true" enabled="true">
                <Table name="productactivity">
                        <AggName name="agg_dateonly_productactivity" ignorecase="true">
                                <AggFactCount column="fact_count">
                                </AggFactCount>
                                <AggForeignKey factColumn="date_id" aggColumn="date_id">
                                </AggForeignKey>
                                <AggMeasure column="unique_view" name="[Measures].[View]">
                                </AggMeasure>
                                <AggMeasure column="unique_add_to_cart" name="[Measures].[AddToCart]">
                                </AggMeasure>
                                <AggMeasure column="unique_shipping_access" name="[Measures].[Shipping]">
                                </AggMeasure>
                                <AggMeasure column="unique_payment_success" name="[Measures].[PaymentOk]">
                                </AggMeasure>
                                <AggMeasure column="unique_order_creation" name="[Measures].[Order Creation]">
                                </AggMeasure>
                                <AggMeasure column="unique_payment_failure" name="[Measures].[PaymentFail]">
                                </AggMeasure>
                                <AggMeasure column="unique_proceed_to_pay" name="[Measures].[ProceedToPay]">
                                </AggMeasure>
                        </AggName>
                        <AggName name="agg_lostitem_productactivity" ignorecase="true">
                                <AggFactCount column="fact_count">
                                </AggFactCount>
                                <AggForeignKey factColumn="date_id" aggColumn="date_id">
                                </AggForeignKey>
                                <AggForeignKey factColumn="session_source_id" aggColumn="session_source_id">
                                </AggForeignKey>
                                <AggForeignKey factColumn="first_source_id" aggColumn="first_source_id">
                                </AggForeignKey>
                                <AggMeasure column="unique_view" name="[Measures].[View]">
                                </AggMeasure>
                                <AggMeasure column="unique_add_to_cart" name="[Measures].[AddToCart]">
                                </AggMeasure>
                                <AggMeasure column="unique_shipping_access" name="[Measures].[Shipping]">
                                </AggMeasure>
                                <AggMeasure column="unique_payment_success" name="[Measures].[PaymentOk]">
                                </AggMeasure>
                                <AggMeasure column="unique_order_creation" name="[Measures].[Order Creation]">
                                </AggMeasure>
                                <AggMeasure column="unique_payment_failure" name="[Measures].[PaymentFail]">
                                </AggMeasure>
                                <AggMeasure column="unique_proceed_to_pay" name="[Measures].[ProceedToPay]">
                                </AggMeasure>
                        </AggName>
                        <AggName name="agg_dateitem_productactivity" ignorecase="true">
                                <AggFactCount column="fact_count">
                                </AggFactCount>
                                <AggForeignKey factColumn="date_id" aggColumn="date_id">
                                </AggForeignKey>
                                <AggForeignKey factColumn="catalog_item_id" aggColumn="catalog_item_id">
                                </AggForeignKey>
                                <AggMeasure column="unique_view" name="[Measures].[View]">
                                </AggMeasure>
                                <AggMeasure column="unique_add_to_cart" name="[Measures].[AddToCart]">
                                </AggMeasure>
                                <AggMeasure column="unique_shipping_access" name="[Measures].[Shipping]">
                                </AggMeasure>
                                <AggMeasure column="unique_payment_success" name="[Measures].[PaymentOk]">
                                </AggMeasure>
                                <AggMeasure column="unique_order_creation" name="[Measures].[Order Creation]">
                                </AggMeasure>
                                <AggMeasure column="unique_payment_failure" name="[Measures].[PaymentFail]">
                                </AggMeasure>
                                <AggMeasure column="unique_proceed_to_pay" name="[Measures].[ProceedToPay]">
                                </AggMeasure>
                        </AggName>
                </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="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 name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Category">
                        <Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
                                <Table name="item">
                                </Table>
                                <Level name="Parent" column="parent_category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level name="Category" column="category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                                <Level name="Product Group" column="product_group" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Product">
                        <Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
                                <Table name="item">
                                </Table>
                                <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>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="first_source_id" name="First Source">
                        <Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
                                <Table name="source">
                                </Table>
                                <Level name="First Source" column="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                        <KeyExpression>
                                                <SQL dialect="generic">
                                                        case when source.is_paid = 1 then &#39;Paid&#39; when source.url like &#39;saholic.com%&#39; then &#39;Direct&#39; when source.url like &#39;google.co%&#39; then &#39;Search&#39; when source.url like &#39;email%&#39; then &#39;Newsletter&#39; else &#39;Referer&#39; end                                           </SQL>
                                        </KeyExpression>
                                        <NameExpression>
                                                <SQL dialect="generic">
                                                        case when source.is_paid = 1 then &#39;Paid&#39; when source.url like &#39;saholic.com%&#39; then &#39;Direct&#39; when source.url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end                                           </SQL>
                                        </NameExpression>
                                </Level>
                                <Level name="site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="session_source_id" name="Session Source">
                        <Hierarchy name="Session Source" hasAll="true" allMemberName="All" primaryKey="id">
                                <Table name="source" alias="session_source">
                                </Table>
                                <Level name="SessionSource" column="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                        <KeyExpression>
                                                <SQL dialect="generic">
                                                        case when session_source.is_paid = 1 then &#39;Paid&#39; when session_source.url like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source.url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end                                           </SQL>
                                        </KeyExpression>
                                        <NameExpression>
                                                <SQL dialect="generic">
                                                        case when session_source.is_paid = 1 then &#39;Paid&#39; when session_source.url like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source.url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end                                           </SQL>
                                        </NameExpression>
                                </Level>
                                <Level name="Site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Price Range">
                        <Hierarchy name="Price Range" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
                                <Table name="item">
                                </Table>
                                <Level name="Price Range" column="price_range" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Measure name="View" column="unique_view" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
                </Measure>
                <Measure name="AddToCart" column="unique_add_to_cart" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
                </Measure>
                <Measure name="Shipping" column="unique_shipping_access" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
                </Measure>
                <Measure name="ProceedToPay" column="unique_proceed_to_pay" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
                </Measure>
                <Measure name="Order Creation" column="unique_order_creation" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
                </Measure>
                <Measure name="PaymentFail" column="unique_payment_failure" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
                </Measure>
                <Measure name="PaymentOk" column="unique_payment_success" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
                </Measure>
        </Cube>
</Schema>