Subversion Repositories SmartDukaan

Rev

Rev 3708 | Rev 5156 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3708 Rev 3838
Line 16... Line 16...
16 
				</Level>
 16 
				</Level>
17 
			</Hierarchy>
 17 
			</Hierarchy>
18 
		</Dimension>
 18 
		</Dimension>
19 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Category">
 19 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Category">
20 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
 20 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
21 
				<Table name="item">
 21 
				<Table name="catalog_item">
22 
				</Table>
 22 
				</Table>
23 
				<Level name="Parent" column="parent_category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 23 
				<Level name="Parent" column="parent_category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
24 
				</Level>
 24 
				</Level>
25 
				<Level name="Category" column="category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 25 
				<Level name="Category" column="category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
26 
				</Level>
 26 
				</Level>
Line 28... Line 28...
28 
				</Level>
 28 
				</Level>
29 
			</Hierarchy>
 29 
			</Hierarchy>
30 
		</Dimension>
 30 
		</Dimension>
31 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Product">
 31 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Product">
32 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
 32 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
33 
				<Table name="item">
 33 
				<Table name="catalog_item">
34 
				</Table>
 34 
				</Table>
35 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 35 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
36 
				</Level>
 36 
				</Level>
37 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 37 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
38 
				</Level>
 38 
				</Level>
39 
				<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 - 
 
40 
				</Level>
 - 
 
41 
			</Hierarchy>
 - 
 
42 
		</Dimension>
 - 
 
43 
		<Dimension type="StandardDimension" name="Paid First Source">
 - 
 
44 
			<Hierarchy name="Paid First Source" hasAll="true" allMemberName="All">
 - 
 
45 
				<Level name="Paid First Source" table="productactivity" column="is_first_source_paid" type="Boolean" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 - 
 
46 
				</Level>
 - 
 
47 
			</Hierarchy>
 39 
			</Hierarchy>
48 
		</Dimension>
 40 
		</Dimension>
49 
		<Dimension type="StandardDimension" foreignKey="first_source_id" name="First Source">
 41 
		<Dimension type="StandardDimension" foreignKey="first_source_id" name="First Source">
50 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
 42 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
51 
				<Table name="source">
 43 
				<Table name="source">
52 
				</Table>
 44 
				</Table>
53 
				<Level name="First Source" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 45 
				<Level name="First Source" column="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
54 
					<KeyExpression>
 46 
					<KeyExpression>
55 
						<SQL dialect="generic">
 47 
						<SQL dialect="generic">
56 
							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>
 48 
							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>
57 
					</KeyExpression>
 49 
					</KeyExpression>
58 
					<NameExpression>
 50 
					<NameExpression>
59 
						<SQL dialect="generic">
 51 
						<SQL dialect="generic">
60 
							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>
 52 
							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>
61 
					</NameExpression>
 53 
					</NameExpression>
62 
				</Level>
 54 
				</Level>
63 
				<Level name="site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 55 
				<Level name="site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
64 
				</Level>
 56 
				</Level>
65 
			</Hierarchy>
 57 
			</Hierarchy>
66 
		</Dimension>
 58 
		</Dimension>
67 
		<Dimension type="StandardDimension" name="Paid Session Source">
 - 
 
68 
			<Hierarchy name="Paid Session Source" hasAll="true" allMemberName="All">
 - 
 
69 
				<Level name="Paid Session Source" table="productactivity" column="is_session_source_paid" type="Boolean" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 - 
 
70 
				</Level>
 - 
 
71 
			</Hierarchy>
 - 
 
72 
		</Dimension>
 - 
 
73 
		<Dimension type="StandardDimension" foreignKey="session_source_id" name="Session Source">
 59 
		<Dimension type="StandardDimension" foreignKey="session_source_id" name="Session Source">
74 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All" primaryKey="id">
 60 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All" primaryKey="id">
75 
				<Table name="source" alias="session_source">
 61 
				<Table name="source" alias="session_source">
76 
				</Table>
 62 
				</Table>
77 
				<Level name="SessionSource" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 63 
				<Level name="SessionSource" column="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
78 
					<KeyExpression>
 64 
					<KeyExpression>
79 
						<SQL dialect="generic">
 65 
						<SQL dialect="generic">
80 
							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>
 66 
							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>
81 
					</KeyExpression>
 67 
					</KeyExpression>
82 
					<NameExpression>
 68 
					<NameExpression>
83 
						<SQL dialect="generic">
 69 
						<SQL dialect="generic">
84 
							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>
 70 
							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>
85 
					</NameExpression>
 71 
					</NameExpression>
86 
				</Level>
 72 
				</Level>
87 
				<Level name="Site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 73 
				<Level name="Site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
88 
				</Level>
 74 
				</Level>
89 
			</Hierarchy>
 75 
			</Hierarchy>
Line 94... Line 80...
94 
		</Measure>
 80 
		</Measure>
95 
		<Measure name="Shipping" column="unique_shipping_access" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 81 
		<Measure name="Shipping" column="unique_shipping_access" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
96 
		</Measure>
 82 
		</Measure>
97 
		<Measure name="ProceedToPay" column="unique_proceed_to_pay" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 83 
		<Measure name="ProceedToPay" column="unique_proceed_to_pay" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
98 
		</Measure>
 84 
		</Measure>
99 
		<Measure name="Order Creation" column="unique_order_creation" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 85 
		<Measure name="Order Creation" column="order_creation" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
100 
		</Measure>
 86 
		</Measure>
101 
		<Measure name="PaymentFail" column="unique_payment_failure" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 87 
		<Measure name="PaymentFail" column="payment_failure" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
102 
		</Measure>
 88 
		</Measure>
103 
		<Measure name="PaymentOk" column="unique_payment_success" formatString="##,###" aggregator="sum" visible="true">
 89 
		<Measure name="PaymentOk" column="payment_success" formatString="##,###" aggregator="sum" visible="true">
104 
		</Measure>
 90 
		</Measure>
105 
	</Cube>
 91 
	</Cube>
106 
</Schema>
 92 
</Schema>