Subversion Repositories SmartDukaan

Rev

Rev 7203 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
2401 ankur.sing 1 
<Schema name="SalesSchema">
2 
	<Cube name="SalesCube" cache="true" enabled="true">
2596 vikas 3 
		<Table name="sales">
2401 ankur.sing 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>
5161 anupam.sin 9 
				<Level approxRowCount="3" name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
2401 ankur.sing 10 
				</Level>
3542 vikas 11 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
2401 ankur.sing 12 
				</Level>
3542 vikas 13 
				<Level approxRowCount="8" name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
2401 ankur.sing 14 
				</Level>
3542 vikas 15 
				<Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
2401 ankur.sing 16 
				</Level>
17 
			</Hierarchy>
18 
		</Dimension>
5200 anupam.sin 19 
		<Dimension type="StandardDimension" foreignKey="pincode" name="Geography">
20 
			<Hierarchy name="Territory" hasAll="true" allMemberName="All" primaryKey="pincode">
21 
				<Table name="pincodesB">
22 
				</Table>
23 
				<Level approxRowCount="25" name="State" column="state" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
24 
				</Level>
25 
				<Level approxRowCount="10" name="City" column="city" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
26 
				</Level>
27 
				<Level name="Pincode" column="pincode" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
28 
				</Level>
29 
			</Hierarchy>
30 
		</Dimension>
31 
		<Dimension type="StandardDimension" foreignKey="status" name="OrderStatus">
32 
			<Hierarchy name="StatusDim" hasAll="true" allMemberName="All" primaryKey="status">
33 
				<Table name="orderstatus">
34 
				</Table>
35 
				<Level name="isValid" column="isValid" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
36 
				</Level>
37 
				<Level name="StatusGroup" column="statusGroup" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
38 
				</Level>
39 
				<Level name="StatusSubGroup" column="statusSubGroup" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
40 
				</Level>
41 
				<Level name="StatusName" column="statusName" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
42 
				</Level>
43 
			</Hierarchy>
44 
		</Dimension>
45 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Product">
46 
			<Hierarchy name="Product Name" hasAll="true" allMemberName="All" primaryKey="id">
47 
				<Table name="item">
48 
				</Table>
49 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
50 
				</Level>
5417 anupam.sin 51 
				<Level name="Product" column="catalog_item_id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
5710 anupam.sin 52 
					<KeyExpression>
53 
						<SQL dialect="generic">
54 
							concat(IFNULL(model_name, &#39;&#39;), &#39; &#39;, IFNULL(model_number, &#39;&#39;))						</SQL>
55 
					</KeyExpression>
5200 anupam.sin 56 
					<NameExpression>
57 
						<SQL dialect="generic">
5417 anupam.sin 58 
							concat(IFNULL(model_name, &#39;&#39;), &#39; &#39;, IFNULL(model_number, &#39;&#39;))						</SQL>
5200 anupam.sin 59 
					</NameExpression>
60 
				</Level>
5417 anupam.sin 61 
				<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
62 
				</Level>
5200 anupam.sin 63 
			</Hierarchy>
64 
		</Dimension>
65 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
66 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
67 
				<Table name="item">
68 
				</Table>
69 
				<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
70 
				</Level>
71 
				<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
72 
				</Level>
73 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
74 
				</Level>
75 
			</Hierarchy>
76 
		</Dimension>
77 
		<Dimension type="StandardDimension" foreignKey="price_range" name="Price">
78 
			<Hierarchy name="Price Range" hasAll="true" allMemberName="All" primaryKey="id">
79 
				<Table name="pricerange">
80 
				</Table>
81 
				<Level name="Price Range" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
82 
				</Level>
83 
			</Hierarchy>
84 
		</Dimension>
85 
		<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment">
86 
			<Hierarchy name="Payment" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
87 
				<Table name="paymentmethod">
88 
				</Table>
89 
				<Level approxRowCount="6" name="Gateway" column="gateway" nameColumn="gateway" ordinalColumn="gateway" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
90 
				</Level>
91 
				<Level name="Payment Method" column="paymentmethodname" nameColumn="paymentmethodname" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
92 
				</Level>
93 
			</Hierarchy>
94 
		</Dimension>
95 
		<Dimension type="StandardDimension" foreignKey="order_hour" name="Order Hour">
96 
			<Hierarchy name="Order Hour" hasAll="true" allMemberName="All" primaryKey="hour_id">
97 
				<Table name="orderhour">
98 
				</Table>
99 
				<Level name="Hour Range" column="hour_range" ordinalColumn="hour_id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
100 
				</Level>
101 
				<Level name="Hour" column="hour_id" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
102 
				</Level>
103 
			</Hierarchy>
104 
		</Dimension>
105 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
106 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
107 
				<Table name="user">
108 
				</Table>
109 
				<Level name="Source" column="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
110 
					<KeyExpression>
111 
						<SQL dialect="generic">
112 
							case when source_type = &#39;Paid&#39; 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>
113 
					</KeyExpression>
114 
					<NameExpression>
115 
						<SQL dialect="generic">
116 
							case when source_type = &#39;Paid&#39; 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>
117 
					</NameExpression>
118 
				</Level>
119 
				<Level name="Site" column="source_url" nameColumn="source_url" ordinalColumn="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
120 
				</Level>
121 
			</Hierarchy>
122 
		</Dimension>
123 
		<Dimension type="StandardDimension" name="Promotion">
124 
			<Hierarchy name="Promotion" hasAll="true" allMemberName="All">
125 
				<Level name="CouponCode" table="sales" column="coupon_code" nameColumn="coupon_code" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
126 
				</Level>
127 
			</Hierarchy>
128 
		</Dimension>
129 
		<Dimension type="StandardDimension" name="Session Source">
130 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
131 
				<Level name="Source" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
132 
					<KeyExpression>
133 
						<SQL dialect="generic">
134 
							case when session_source_type = &#39;Paid&#39; 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>
135 
					</KeyExpression>
136 
					<NameExpression>
137 
						<SQL dialect="generic">
138 
							case when session_source_type = &#39;Paid&#39; 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>
139 
					</NameExpression>
140 
				</Level>
141 
				<Level name="Site" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
142 
				</Level>
143 
			</Hierarchy>
144 
		</Dimension>
145 
		<Dimension type="StandardDimension" name="Affiliate">
146 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
147 
				<Level name="Affiliate" table="sales" column="aff_name" nameColumn="aff_name" ordinalColumn="aff_name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
148 
				</Level>
149 
			</Hierarchy>
150 
		</Dimension>
151 
		<Dimension type="StandardDimension" foreignKey="days_to_purchase" name="Days To Purchase">
152 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All" primaryKey="id">
153 
				<Table name="daystopurchaserange">
154 
				</Table>
155 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
156 
				</Level>
157 
			</Hierarchy>
158 
		</Dimension>
5799 anupam.sin 159 
		<Dimension type="StandardDimension" foreignKey="pickupStoreId" name="PickupType">
160 
			<Hierarchy name="PickupType" hasAll="true" allMemberName="All">
161 
				<Level name="PickupType" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
162 
					<KeyExpression>
163 
						<SQL dialect="generic">
5896 anupam.sin 164 
							case when pickupStoreId is null then &#39;HomeDelivery&#39;  else &#39;Store Pickup&#39; end						</SQL>
5799 anupam.sin 165 
					</KeyExpression>
166 
					<NameExpression>
167 
						<SQL dialect="generic">
5896 anupam.sin 168 
							case when pickupStoreId is null then &#39;HomeDelivery&#39;  else &#39;Store Pickup&#39; end						</SQL>
5799 anupam.sin 169 
					</NameExpression>
170 
				</Level>
5896 anupam.sin 171 
				<Level name="StoreId" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
5799 anupam.sin 172 
				</Level>
173 
			</Hierarchy>
174 
		</Dimension>
7203 anupam.sin 175 
		<Dimension type="StandardDimension" foreignKey="insurer" name="Insurer">
176 
			<Hierarchy name="Insurer" hasAll="true" allMemberName="All">
177 
				<Level name="Insurer" table="sales" column="insurer" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
178 
					<KeyExpression>
179 
						<SQL dialect="generic">
180 
							case when insurer > 0 then &#39;New India Assurance&#39;  else &#39;N/A&#39; end						</SQL>
181 
					</KeyExpression>
182 
					<NameExpression>
183 
						<SQL dialect="generic">
184 
							case when insurer > 0 then &#39;New India Assurance&#39;  else &#39;N/A&#39; end						</SQL>
185 
					</NameExpression>
186 
				</Level>
187 
			</Hierarchy>
188 
		</Dimension>
189 
		<Dimension type="StandardDimension" foreignKey="otg" name="OTG">
190 
			<Hierarchy name="OTG" hasAll="true" allMemberName="All">
191 
				<Level name="OTG" table="sales" column="otg" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
192 
					<KeyExpression>
193 
						<SQL dialect="generic">
194 
							case when otg = 1 then &#39;Yes&#39;  else &#39;No&#39; end						</SQL>
195 
					</KeyExpression>
196 
					<NameExpression>
197 
						<SQL dialect="generic">
198 
							case when otg = 1 then &#39;Yes&#39;  else &#39;No&#39; end						</SQL>
199 
					</NameExpression>
200 
				</Level>
201 
			</Hierarchy>
202 
		</Dimension>
7890 anupam.sin 203 
		<Dimension type="StandardDimension" foreignKey="source" name="OrderSource">
204 
			<Hierarchy name="OrderSource" hasAll="true" allMemberName="All">
205 
				<Level name="OrderSource" table="sales" column="otg" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
206 
					<KeyExpression>
207 
						<SQL dialect="generic">
208 
							case when source = 1 then &#39;WEBSITE&#39;  when source = 2 then &#39;STORE&#39; when source = 3 then &#39;AMAZON&#39; end	</SQL>
209 
					</KeyExpression>
210 
					<NameExpression>
211 
						<SQL dialect="generic">
212 
							case when source = 1 then &#39;WEBSITE&#39;  when source = 2 then &#39;STORE&#39; when source = 3 then &#39;AMAZON&#39; end </SQL>
213 
					</NameExpression>
214 
				</Level>
215 
			</Hierarchy>
216 
		</Dimension>
5391 anupam.sin 217 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
5200 anupam.sin 218 
		</Measure>
5391 anupam.sin 219 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
5200 anupam.sin 220 
		</Measure>
5391 anupam.sin 221 
		<Measure name="Transfer Price" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
5200 anupam.sin 222 
			<MeasureExpression>
223 
				<SQL dialect="generic">
224 
					transfer_price*quantity				</SQL>
225 
			</MeasureExpression>
226 
		</Measure>
7203 anupam.sin 227 
		<Measure name="NLC" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
228 
			<MeasureExpression>
229 
				<SQL dialect="generic">
230 
					nlc*quantity				</SQL>
231 
			</MeasureExpression>
232 
		</Measure>
233 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[NLC]" dimension="Measures" visible="true">
5200 anupam.sin 234 
		</CalculatedMember>
235 
		<CalculatedMember name="Average Selling Price" caption="Average Selling Price" formula="[Measures].[Total Sales]/[Measures].[Quantity]" dimension="Measures" visible="true">
236 
		</CalculatedMember>
237 
	</Cube>
238 
	<Cube name="SalesBookingCube" cache="true" enabled="true">
239 
		<Table name="sales">
240 
		</Table>
5161 anupam.sin 241 
		<Dimension type="TimeDimension" foreignKey="booking_date_id" name="BookingDate">
242 
			<Hierarchy name="BookingDate" hasAll="true" allMemberName="All" primaryKey="date_id">
5200 anupam.sin 243 
				<Table name="datedim" alias="bookingdatedim">
5161 anupam.sin 244 
				</Table>
245 
				<Level approxRowCount="3" name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
246 
				</Level>
247 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
248 
				</Level>
5200 anupam.sin 249 
				<Level approxRowCount="12" name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
5161 anupam.sin 250 
				</Level>
251 
				<Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
252 
				</Level>
253 
			</Hierarchy>
254 
		</Dimension>
2401 ankur.sing 255 
		<Dimension type="StandardDimension" foreignKey="pincode" name="Geography">
256 
			<Hierarchy name="Territory" hasAll="true" allMemberName="All" primaryKey="pincode">
257 
				<Table name="pincodesB">
258 
				</Table>
3542 vikas 259 
				<Level approxRowCount="25" name="State" column="state" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2401 ankur.sing 260 
				</Level>
3542 vikas 261 
				<Level approxRowCount="10" name="City" column="city" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2401 ankur.sing 262 
				</Level>
263 
				<Level name="Pincode" column="pincode" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
264 
				</Level>
265 
			</Hierarchy>
266 
		</Dimension>
267 
		<Dimension type="StandardDimension" foreignKey="status" name="OrderStatus">
268 
			<Hierarchy name="StatusDim" hasAll="true" allMemberName="All" primaryKey="status">
269 
				<Table name="orderstatus">
270 
				</Table>
5161 anupam.sin 271 
				<Level name="isValid" column="isValid" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2401 ankur.sing 272 
				</Level>
5161 anupam.sin 273 
				<Level name="StatusGroup" column="statusGroup" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2401 ankur.sing 274 
				</Level>
5161 anupam.sin 275 
				<Level name="StatusSubGroup" column="statusSubGroup" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
276 
				</Level>
277 
				<Level name="StatusName" column="statusName" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
278 
				</Level>
2401 ankur.sing 279 
			</Hierarchy>
280 
		</Dimension>
281 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Product">
5161 anupam.sin 282 
			<Hierarchy name="Product Name" hasAll="true" allMemberName="All" primaryKey="id">
2401 ankur.sing 283 
				<Table name="item">
284 
				</Table>
285 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
286 
				</Level>
5417 anupam.sin 287 
				<Level name="Product" column="catalog_item_id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
5710 anupam.sin 288 
					<KeyExpression>
289 
						<SQL dialect="generic">
290 
							concat(IFNULL(model_name, &#39;&#39;), &#39; &#39;, IFNULL(model_number, &#39;&#39;))						</SQL>
291 
					</KeyExpression>
4029 vikas 292 
					<NameExpression>
293 
						<SQL dialect="generic">
5417 anupam.sin 294 
							concat(IFNULL(model_name, &#39;&#39;), &#39; &#39;, IFNULL(model_number, &#39;&#39;))						</SQL>
4029 vikas 295 
					</NameExpression>
296 
				</Level>
5417 anupam.sin 297 
				<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
298 
				</Level>
4029 vikas 299 
			</Hierarchy>
2401 ankur.sing 300 
		</Dimension>
2532 vikas 301 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
302 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
2553 vikas 303 
				<Table name="item">
2532 vikas 304 
				</Table>
305 
				<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
306 
				</Level>
307 
				<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
308 
				</Level>
2553 vikas 309 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
310 
				</Level>
2532 vikas 311 
			</Hierarchy>
312 
		</Dimension>
3481 vikas 313 
		<Dimension type="StandardDimension" foreignKey="price_range" name="Price">
314 
			<Hierarchy name="Price Range" hasAll="true" allMemberName="All" primaryKey="id">
3542 vikas 315 
				<Table name="pricerange">
3481 vikas 316 
				</Table>
4033 vikas 317 
				<Level name="Price Range" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
2553 vikas 318 
				</Level>
319 
			</Hierarchy>
320 
		</Dimension>
2596 vikas 321 
		<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment">
322 
			<Hierarchy name="Payment" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
2639 vikas 323 
				<Table name="paymentmethod">
2596 vikas 324 
				</Table>
3542 vikas 325 
				<Level approxRowCount="6" name="Gateway" column="gateway" nameColumn="gateway" ordinalColumn="gateway" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2596 vikas 326 
				</Level>
3542 vikas 327 
				<Level name="Payment Method" column="paymentmethodname" nameColumn="paymentmethodname" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2596 vikas 328 
				</Level>
329 
			</Hierarchy>
330 
		</Dimension>
3542 vikas 331 
		<Dimension type="StandardDimension" foreignKey="order_hour" name="Order Hour">
332 
			<Hierarchy name="Order Hour" hasAll="true" allMemberName="All" primaryKey="hour_id">
333 
				<Table name="orderhour">
334 
				</Table>
335 
				<Level name="Hour Range" column="hour_range" ordinalColumn="hour_id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2639 vikas 336 
				</Level>
3542 vikas 337 
				<Level name="Hour" column="hour_id" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
3393 vikas 338 
				</Level>
2639 vikas 339 
			</Hierarchy>
340 
		</Dimension>
2853 vikas 341 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
3707 vikas 342 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
2834 vikas 343 
				<Table name="user">
2712 vikas 344 
				</Table>
3707 vikas 345 
				<Level name="Source" column="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
346 
					<KeyExpression>
347 
						<SQL dialect="generic">
4029 vikas 348 
							case when source_type = &#39;Paid&#39; 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>
3707 vikas 349 
					</KeyExpression>
350 
					<NameExpression>
351 
						<SQL dialect="generic">
4029 vikas 352 
							case when source_type = &#39;Paid&#39; 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>
3707 vikas 353 
					</NameExpression>
354 
				</Level>
3437 vikas 355 
				<Level name="Site" column="source_url" nameColumn="source_url" ordinalColumn="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
2712 vikas 356 
				</Level>
357 
			</Hierarchy>
358 
		</Dimension>
2834 vikas 359 
		<Dimension type="StandardDimension" name="Promotion">
360 
			<Hierarchy name="Promotion" hasAll="true" allMemberName="All">
361 
				<Level name="CouponCode" table="sales" column="coupon_code" nameColumn="coupon_code" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
362 
				</Level>
363 
			</Hierarchy>
364 
		</Dimension>
2853 vikas 365 
		<Dimension type="StandardDimension" name="Session Source">
366 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
3707 vikas 367 
				<Level name="Source" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
368 
					<KeyExpression>
369 
						<SQL dialect="generic">
4029 vikas 370 
							case when session_source_type = &#39;Paid&#39; 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>
3707 vikas 371 
					</KeyExpression>
372 
					<NameExpression>
373 
						<SQL dialect="generic">
4029 vikas 374 
							case when session_source_type = &#39;Paid&#39; 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>
3707 vikas 375 
					</NameExpression>
376 
				</Level>
3542 vikas 377 
				<Level name="Site" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
2853 vikas 378 
				</Level>
379 
			</Hierarchy>
380 
		</Dimension>
3393 vikas 381 
		<Dimension type="StandardDimension" name="Affiliate">
382 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
383 
				<Level name="Affiliate" table="sales" column="aff_name" nameColumn="aff_name" ordinalColumn="aff_name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
2853 vikas 384 
				</Level>
385 
			</Hierarchy>
386 
		</Dimension>
3484 vikas 387 
		<Dimension type="StandardDimension" foreignKey="days_to_purchase" name="Days To Purchase">
388 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All" primaryKey="id">
3542 vikas 389 
				<Table name="daystopurchaserange">
3484 vikas 390 
				</Table>
391 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
2853 vikas 392 
				</Level>
393 
			</Hierarchy>
394 
		</Dimension>
5799 anupam.sin 395 
		<Dimension type="StandardDimension" foreignKey="pickupStoreId" name="PickupType">
396 
			<Hierarchy name="PickupType" hasAll="true" allMemberName="All">
397 
				<Level name="PickupType" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
398 
					<KeyExpression>
399 
						<SQL dialect="generic">
5896 anupam.sin 400 
							case when pickupStoreId is null then &#39;HomeDelivery&#39;  else &#39;Store Pickup&#39; end						</SQL>
5799 anupam.sin 401 
					</KeyExpression>
402 
					<NameExpression>
403 
						<SQL dialect="generic">
5896 anupam.sin 404 
							case when pickupStoreId is null then &#39;HomeDelivery&#39;  else &#39;Store Pickup&#39; end						</SQL>
5799 anupam.sin 405 
					</NameExpression>
406 
				</Level>
5896 anupam.sin 407 
				<Level name="StoreId" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
5799 anupam.sin 408 
				</Level>
409 
			</Hierarchy>
410 
		</Dimension>
7203 anupam.sin 411 
		<Dimension type="StandardDimension" foreignKey="insurer" name="Insurer">
412 
			<Hierarchy name="Insurer" hasAll="true" allMemberName="All">
413 
				<Level name="Insurer" table="sales" column="insurer" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
414 
					<KeyExpression>
415 
						<SQL dialect="generic">
416 
							case when insurer > 0 then &#39;New India Assurance&#39;  else &#39;N/A&#39; end						</SQL>
417 
					</KeyExpression>
418 
					<NameExpression>
419 
						<SQL dialect="generic">
420 
							case when insurer > 0 then &#39;New India Assurance&#39;  else &#39;N/A&#39; end						</SQL>
421 
					</NameExpression>
422 
				</Level>
423 
			</Hierarchy>
424 
		</Dimension>
425 
		<Dimension type="StandardDimension" foreignKey="otg" name="OTG">
426 
			<Hierarchy name="OTG" hasAll="true" allMemberName="All">
427 
				<Level name="OTG" table="sales" column="otg" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
428 
					<KeyExpression>
429 
						<SQL dialect="generic">
430 
							case when otg = 1 then &#39;Yes&#39;  else &#39;No&#39; end						</SQL>
431 
					</KeyExpression>
432 
					<NameExpression>
433 
						<SQL dialect="generic">
434 
							case when otg = 1 then &#39;Yes&#39;  else &#39;No&#39; end						</SQL>
435 
					</NameExpression>
436 
				</Level>
437 
			</Hierarchy>
438 
		</Dimension>
7890 anupam.sin 439 
		<Dimension type="StandardDimension" foreignKey="source" name="OrderSource">
440 
			<Hierarchy name="OrderSource" hasAll="true" allMemberName="All">
441 
				<Level name="OrderSource" table="sales" column="otg" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
442 
					<KeyExpression>
443 
						<SQL dialect="generic">
444 
							case when source = 1 then &#39;WEBSITE&#39;  when source = 2 then &#39;STORE&#39; when source = 3 then &#39;AMAZON&#39; end	</SQL>
445 
					</KeyExpression>
446 
					<NameExpression>
447 
						<SQL dialect="generic">
448 
							case when source = 1 then &#39;WEBSITE&#39;  when source = 2 then &#39;STORE&#39; when source = 3 then &#39;AMAZON&#39; end </SQL>
449 
					</NameExpression>
450 
				</Level>
451 
			</Hierarchy>
452 
		</Dimension>
5391 anupam.sin 453 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
2401 ankur.sing 454 
		</Measure>
5391 anupam.sin 455 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
2596 vikas 456 
		</Measure>
7203 anupam.sin 457 
		<Measure name="Transfer Price" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
4029 vikas 458 
			<MeasureExpression>
459 
				<SQL dialect="generic">
460 
					transfer_price*quantity				</SQL>
461 
			</MeasureExpression>
2596 vikas 462 
		</Measure>
7203 anupam.sin 463 
		<Measure name="NLC" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
464 
			<MeasureExpression>
465 
				<SQL dialect="generic">
466 
					nlc*quantity				</SQL>
467 
			</MeasureExpression>
468 
		</Measure>
469 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[NLC]" dimension="Measures" visible="true">
2553 vikas 470 
		</CalculatedMember>
5161 anupam.sin 471 
		<CalculatedMember name="Average Selling Price" caption="Average Selling Price" formula="[Measures].[Total Sales]/[Measures].[Quantity]" dimension="Measures" visible="true">
472 
		</CalculatedMember>
2401 ankur.sing 473 
	</Cube>
474 
</Schema>