Subversion Repositories SmartDukaan

Rev

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