Subversion Repositories SmartDukaan

Rev

Rev 3707 | Rev 3838 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
3543 vikas 1 
<Schema name="ProductActivitySchema">
2 
	<Cube name="ProductActivityCube" cache="true" enabled="true">
3 
		<Table name="productactivity">
4 
		</Table>
5 
		<Dimension type="TimeDimension" foreignKey="date_id" name="OrderDate">
6 
			<Hierarchy name="OrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
7 
				<Table name="datedim">
8 
				</Table>
9 
				<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
10 
				</Level>
11 
				<Level name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
12 
				</Level>
13 
				<Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
14 
				</Level>
15 
				<Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
16 
				</Level>
17 
			</Hierarchy>
18 
		</Dimension>
19 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Category">
20 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
21 
				<Table name="item">
22 
				</Table>
23 
				<Level name="Parent" column="parent_category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
24 
				</Level>
25 
				<Level name="Category" column="category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
26 
				</Level>
27 
				<Level name="Product Group" column="product_group" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
28 
				</Level>
29 
			</Hierarchy>
30 
		</Dimension>
31 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Product">
32 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
33 
				<Table name="item">
34 
				</Table>
35 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
36 
				</Level>
37 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
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">
3707 vikas 45 
				<Level name="Paid First Source" table="productactivity" column="is_first_source_paid" type="Boolean" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
3543 vikas 46 
				</Level>
47 
			</Hierarchy>
48 
		</Dimension>
49 
		<Dimension type="StandardDimension" foreignKey="first_source_id" name="First Source">
3707 vikas 50 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
3543 vikas 51 
				<Table name="source">
52 
				</Table>
3707 vikas 53 
				<Level name="First Source" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
54 
					<KeyExpression>
55 
						<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>
57 
					</KeyExpression>
58 
					<NameExpression>
59 
						<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>
61 
					</NameExpression>
3543 vikas 62 
				</Level>
3707 vikas 63 
				<Level name="site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
64 
				</Level>
3543 vikas 65 
			</Hierarchy>
66 
		</Dimension>
67 
		<Dimension type="StandardDimension" name="Paid Session Source">
68 
			<Hierarchy name="Paid Session Source" hasAll="true" allMemberName="All">
3707 vikas 69 
				<Level name="Paid Session Source" table="productactivity" column="is_session_source_paid" type="Boolean" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
3543 vikas 70 
				</Level>
71 
			</Hierarchy>
72 
		</Dimension>
73 
		<Dimension type="StandardDimension" foreignKey="session_source_id" name="Session Source">
74 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All" primaryKey="id">
75 
				<Table name="source" alias="session_source">
76 
				</Table>
3707 vikas 77 
				<Level name="SessionSource" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
78 
					<KeyExpression>
79 
						<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>
81 
					</KeyExpression>
82 
					<NameExpression>
83 
						<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>
85 
					</NameExpression>
3543 vikas 86 
				</Level>
3707 vikas 87 
				<Level name="Site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
88 
				</Level>
3543 vikas 89 
			</Hierarchy>
90 
		</Dimension>
3708 vikas 91 
		<Measure name="View" column="unique_view" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 92 
		</Measure>
3708 vikas 93 
		<Measure name="AddToCart" column="unique_add_to_cart" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 94 
		</Measure>
3708 vikas 95 
		<Measure name="Shipping" column="unique_shipping_access" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 96 
		</Measure>
3708 vikas 97 
		<Measure name="ProceedToPay" column="unique_proceed_to_pay" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 98 
		</Measure>
3708 vikas 99 
		<Measure name="Order Creation" column="unique_order_creation" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 100 
		</Measure>
3708 vikas 101 
		<Measure name="PaymentFail" column="unique_payment_failure" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 102 
		</Measure>
3708 vikas 103 
		<Measure name="PaymentOk" column="unique_payment_success" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 104 
		</Measure>
105 
	</Cube>
106 
</Schema>