Subversion Repositories SmartDukaan

<Schema name="ProductActivitySchema">
        <Cube name="ProductActivityCube" cache="true" enabled="true">
                <Table name="productactivity">
                </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="catalog_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="catalog_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; 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>
                <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="order_creation" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
                </Measure>
                <Measure name="PaymentFail" column="payment_failure" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
                </Measure>
                <Measure name="PaymentOk" column="payment_success" formatString="##,###" aggregator="sum" visible="true">
                </Measure>
        </Cube>
</Schema>