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="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>
                                <Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension type="StandardDimension" name="Paid First Source">
                        <Hierarchy name="Paid First Source" hasAll="true" allMemberName="All">
                                <Level name="Paid First Source" table="productactivity" column="is_first_source_paid" type="Boolean" 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="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                        <KeyExpression>
                                                <SQL dialect="generic">
                                                        case when url like &#39;saholic.com%&#39; then &#39;Direct&#39;  when url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end                                            </SQL>
                                        </KeyExpression>
                                        <NameExpression>
                                                <SQL dialect="generic">
                                                        case when url like &#39;saholic.com%&#39; then &#39;Direct&#39; when 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" name="Paid Session Source">
                        <Hierarchy name="Paid Session Source" hasAll="true" allMemberName="All">
                                <Level name="Paid Session Source" table="productactivity" column="is_session_source_paid" type="Boolean" uniqueMembers="true" 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="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
                                        <KeyExpression>
                                                <SQL dialect="generic">
                                                        case when url like &#39;saholic.com%&#39; then &#39;Direct&#39; when url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end                                             </SQL>
                                        </KeyExpression>
                                        <NameExpression>
                                                <SQL dialect="generic">
                                                        case when url like &#39;saholic.com%&#39; then &#39;Direct&#39; when 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="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" formatString="##,###" aggregator="sum" visible="true">
                </Measure>
        </Cube>
</Schema>