Subversion Repositories SmartDukaan

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
5896 anupam.sin 1 
<Schema name="RepeatSalesSchema">
2 
	<Cube name="RepeatSalesCube" cache="true" enabled="true">
3 
		<Table name="repeatSales">
4 
		</Table>
5 
		<Dimension type="StandardDimension" foreignKey="grandTotal" name="Grand Total">
6 
			<Hierarchy name="GrandTotal" hasAll="true" allMemberName="All" primaryKey="id">
7 
				<Table name="pricerange">
8 
				</Table>
9 
				<Level name="Price Range 1" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
10 
				</Level>
11 
			</Hierarchy>
12 
		</Dimension>
13 
		<Dimension type="StandardDimension" foreignKey="price_range1" name="First Order Value">
14 
			<Hierarchy name="First Order Value" hasAll="true" allMemberName="All" primaryKey="id">
15 
				<Table name="pricerange" alias="firstOrderPrice">
16 
				</Table>
17 
				<Level name="Price Range 2" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
18 
				</Level>
19 
			</Hierarchy>
20 
		</Dimension>
21 
		<Dimension type="StandardDimension" foreignKey="price_range2" name="Second Order Value">
22 
			<Hierarchy name="Second Order Value" hasAll="true" allMemberName="All" primaryKey="id">
23 
				<Table name="pricerange" alias="secondOrderPrice">
24 
				</Table>
25 
				<Level name="Price Range 3" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
26 
				</Level>
27 
			</Hierarchy>
28 
		</Dimension>
29 
		<Dimension type="StandardDimension" foreignKey="pin" name="Geography">
30 
			<Hierarchy name="Territory" hasAll="true" allMemberName="All" primaryKey="pincode">
31 
				<Table name="pincodesB">
32 
				</Table>
33 
				<Level approxRowCount="25" name="State" column="state" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
34 
				</Level>
35 
				<Level approxRowCount="10" name="City" column="city" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
36 
				</Level>
37 
				<Level name="Pincode" column="pincode" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
38 
				</Level>
39 
			</Hierarchy>
40 
		</Dimension>
41 
		<Dimension type="StandardDimension" foreignKey="item1" name="First Product Category">
42 
			<Hierarchy name="First Product Category" hasAll="true" allMemberName="All" primaryKey="id">
43 
				<Table name="item">
44 
				</Table>
45 
				<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
46 
				</Level>
47 
				<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
48 
				</Level>
49 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
50 
				</Level>
51 
			</Hierarchy>
52 
		</Dimension>
53 
		<Dimension type="StandardDimension" foreignKey="item2" name="Second Product Category">
54 
			<Hierarchy name="Second Product Category" hasAll="true" allMemberName="All" primaryKey="id">
55 
				<Table name="item" alias="secondItem">
56 
				</Table>
57 
				<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
58 
				</Level>
59 
				<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
60 
				</Level>
61 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
62 
				</Level>
63 
			</Hierarchy>
64 
		</Dimension>
65 
		<Dimension type="StandardDimension" name="First Session Source">
66 
			<Hierarchy name="First Session Source" hasAll="true" allMemberName="All">
67 
				<Level name="Source" table="repeatSales" column="session_source_url1" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
68 
					<KeyExpression>
69 
						<SQL dialect="generic">
70 
							case when session_source_type1 = &#39;Paid&#39; then &#39;Paid&#39; when session_source_url1 like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source_url1 like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
71 
					</KeyExpression>
72 
					<NameExpression>
73 
						<SQL dialect="generic">
74 
							case when session_source_type1 = &#39;Paid&#39; then &#39;Paid&#39; when session_source_url1 like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source_url1 like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
75 
					</NameExpression>
76 
				</Level>
77 
				<Level name="Site" table="repeatSales" column="session_source_url1" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
78 
				</Level>
79 
			</Hierarchy>
80 
		</Dimension>
81 
		<Dimension type="StandardDimension" name="Second Session Source">
82 
			<Hierarchy name="Second Session Source" hasAll="true" allMemberName="All">
83 
				<Level name="Source" table="repeatSales" column="session_source_url2" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
84 
					<KeyExpression>
85 
						<SQL dialect="generic">
86 
							case when session_source_type2 = &#39;Paid&#39; then &#39;Paid&#39; when session_source_url2 like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source_url2 like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
87 
					</KeyExpression>
88 
					<NameExpression>
89 
						<SQL dialect="generic">
90 
							case when session_source_type2 = &#39;Paid&#39; then &#39;Paid&#39; when session_source_url2 like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source_url2 like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
91 
					</NameExpression>
92 
				</Level>
93 
				<Level name="Site" table="repeatSales" column="session_source_url2" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
94 
				</Level>
95 
			</Hierarchy>
96 
		</Dimension>
97 
		<Dimension type="StandardDimension" foreignKey="daysToPurchase" name="Days To First Purchase">
98 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All" primaryKey="id">
99 
				<Table name="daystopurchaserange">
100 
				</Table>
101 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
102 
				</Level>
103 
			</Hierarchy>
104 
		</Dimension>
105 
		<Dimension type="StandardDimension" name="First Pay Mode">
106 
			<Hierarchy name="First Pay Mode" hasAll="true" allMemberName="All">
107 
				<Level name="paymode1" table="repeatSales" column="paymode1" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
108 
					<KeyExpression>
109 
						<SQL dialect="generic">
110 
							case when paymode1 = 1 then &#39;COD&#39; when paymode1 = 0 then &#39;Prepaid&#39; end						</SQL>
111 
					</KeyExpression>
112 
					<NameExpression>
113 
						<SQL dialect="generic">
114 
							case when paymode1 = 1 then &#39;COD&#39; when paymode1 = 0 then &#39;Prepaid&#39; end						</SQL>
115 
					</NameExpression>
116 
				</Level>
117 
			</Hierarchy>
118 
		</Dimension>
119 
		<Dimension type="StandardDimension" name="Second Pay Mode">
120 
			<Hierarchy name="Second Pay Mode" hasAll="true" allMemberName="All">
121 
				<Level name="paymode2" table="repeatSales" column="paymode2" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
122 
					<KeyExpression>
123 
						<SQL dialect="generic">
124 
							case when paymode2 = 1 then &#39;COD&#39; when paymode1 = 0 then &#39;Prepaid&#39; end						</SQL>
125 
					</KeyExpression>
126 
					<NameExpression>
127 
						<SQL dialect="generic">
128 
							case when paymode2 = 1 then &#39;COD&#39; when paymode1 = 0 then &#39;Prepaid&#39; end						</SQL>
129 
					</NameExpression>
130 
				</Level>
131 
			</Hierarchy>
132 
		</Dimension>
133 
		<Dimension type="StandardDimension" name="Order Count">
134 
			<Hierarchy name="Order Count" hasAll="true" allMemberName="All">
135 
				<Level name="orderCount" table="repeatSales" column="orderCount" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
136 
					<KeyExpression>
137 
						<SQL dialect="generic">
138 
							case when orderCount &#60;= 5 then convert(orderCount, char) when orderCount &#62; 5 then &#39;more than 5 orders&#39; end						</SQL>
139 
					</KeyExpression>
140 
					<NameExpression>
141 
						<SQL dialect="generic">
142 
							case when orderCount &#60;= 5 then convert(orderCount, char) when orderCount &#62; 5 then &#39;more than 5 orders&#39; end						</SQL>
143 
					</NameExpression>
144 
				</Level>
145 
			</Hierarchy>
146 
		</Dimension>
147 
		<Dimension type="TimeDimension" foreignKey="date_id1" name="First Order Date">
148 
			<Hierarchy name="FirstOrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
149 
				<Table name="datedim">
150 
				</Table>
151 
				<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
152 
				</Level>
153 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
154 
				</Level>
155 
				<Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
156 
				</Level>
157 
				<Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
158 
				</Level>
159 
			</Hierarchy>
160 
		</Dimension>
161 
		<Dimension type="TimeDimension" foreignKey="date_id2" name="Second Order Date">
162 
			<Hierarchy name="SecondOrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
163 
				<Table name="datedim" alias="datedim2">
164 
				</Table>
165 
				<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
166 
				</Level>
167 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
168 
				</Level>
169 
				<Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
170 
				</Level>
171 
				<Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
172 
				</Level>
173 
			</Hierarchy>
174 
		</Dimension>
175 
		<Measure name="UserCount" column="customer_id" datatype="Numeric" formatString="###,###,###" aggregator="count" visible="true">
176 
		</Measure>
177 
	</Cube>
178 
</Schema>