Subversion Repositories SmartDukaan

Rev

Rev 5391 | Rev 5710 | Go to most recent revision | 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">
5200 anupam.sin 52 
					<NameExpression>
53 
						<SQL dialect="generic">
5417 anupam.sin 54 
							concat(IFNULL(model_name, &#39;&#39;), &#39; &#39;, IFNULL(model_number, &#39;&#39;))						</SQL>
5200 anupam.sin 55 
					</NameExpression>
56 
				</Level>
5417 anupam.sin 57 
				<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
58 
				</Level>
5200 anupam.sin 59 
			</Hierarchy>
60 
		</Dimension>
61 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
62 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
63 
				<Table name="item">
64 
				</Table>
65 
				<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
66 
				</Level>
67 
				<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
68 
				</Level>
69 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
70 
				</Level>
71 
			</Hierarchy>
72 
		</Dimension>
73 
		<Dimension type="StandardDimension" foreignKey="price_range" name="Price">
74 
			<Hierarchy name="Price Range" hasAll="true" allMemberName="All" primaryKey="id">
75 
				<Table name="pricerange">
76 
				</Table>
77 
				<Level name="Price Range" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
78 
				</Level>
79 
			</Hierarchy>
80 
		</Dimension>
81 
		<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment">
82 
			<Hierarchy name="Payment" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
83 
				<Table name="paymentmethod">
84 
				</Table>
85 
				<Level approxRowCount="6" name="Gateway" column="gateway" nameColumn="gateway" ordinalColumn="gateway" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
86 
				</Level>
87 
				<Level name="Payment Method" column="paymentmethodname" nameColumn="paymentmethodname" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
88 
				</Level>
89 
			</Hierarchy>
90 
		</Dimension>
91 
		<Dimension type="StandardDimension" foreignKey="order_hour" name="Order Hour">
92 
			<Hierarchy name="Order Hour" hasAll="true" allMemberName="All" primaryKey="hour_id">
93 
				<Table name="orderhour">
94 
				</Table>
95 
				<Level name="Hour Range" column="hour_range" ordinalColumn="hour_id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
96 
				</Level>
97 
				<Level name="Hour" column="hour_id" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
98 
				</Level>
99 
			</Hierarchy>
100 
		</Dimension>
101 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
102 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
103 
				<Table name="user">
104 
				</Table>
105 
				<Level name="Source" column="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
106 
					<KeyExpression>
107 
						<SQL dialect="generic">
108 
							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>
109 
					</KeyExpression>
110 
					<NameExpression>
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 
					</NameExpression>
114 
				</Level>
115 
				<Level name="Site" column="source_url" nameColumn="source_url" ordinalColumn="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
116 
				</Level>
117 
			</Hierarchy>
118 
		</Dimension>
119 
		<Dimension type="StandardDimension" name="Promotion">
120 
			<Hierarchy name="Promotion" hasAll="true" allMemberName="All">
121 
				<Level name="CouponCode" table="sales" column="coupon_code" nameColumn="coupon_code" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
122 
				</Level>
123 
			</Hierarchy>
124 
		</Dimension>
125 
		<Dimension type="StandardDimension" name="Session Source">
126 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
127 
				<Level name="Source" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
128 
					<KeyExpression>
129 
						<SQL dialect="generic">
130 
							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>
131 
					</KeyExpression>
132 
					<NameExpression>
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 
					</NameExpression>
136 
				</Level>
137 
				<Level name="Site" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
138 
				</Level>
139 
			</Hierarchy>
140 
		</Dimension>
141 
		<Dimension type="StandardDimension" name="Affiliate">
142 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
143 
				<Level name="Affiliate" table="sales" column="aff_name" nameColumn="aff_name" ordinalColumn="aff_name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
144 
				</Level>
145 
			</Hierarchy>
146 
		</Dimension>
147 
		<Dimension type="StandardDimension" foreignKey="days_to_purchase" name="Days To Purchase">
148 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All" primaryKey="id">
149 
				<Table name="daystopurchaserange">
150 
				</Table>
151 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
152 
				</Level>
153 
			</Hierarchy>
154 
		</Dimension>
5391 anupam.sin 155 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
5200 anupam.sin 156 
		</Measure>
5391 anupam.sin 157 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
5200 anupam.sin 158 
		</Measure>
5391 anupam.sin 159 
		<Measure name="Transfer Price" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
5200 anupam.sin 160 
			<MeasureExpression>
161 
				<SQL dialect="generic">
162 
					transfer_price*quantity				</SQL>
163 
			</MeasureExpression>
164 
		</Measure>
165 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[Transfer Price]" dimension="Measures" visible="true">
166 
		</CalculatedMember>
167 
		<CalculatedMember name="Average Selling Price" caption="Average Selling Price" formula="[Measures].[Total Sales]/[Measures].[Quantity]" dimension="Measures" visible="true">
168 
		</CalculatedMember>
169 
	</Cube>
170 
	<Cube name="SalesBookingCube" cache="true" enabled="true">
171 
		<Table name="sales">
172 
		</Table>
5161 anupam.sin 173 
		<Dimension type="TimeDimension" foreignKey="booking_date_id" name="BookingDate">
174 
			<Hierarchy name="BookingDate" hasAll="true" allMemberName="All" primaryKey="date_id">
5200 anupam.sin 175 
				<Table name="datedim" alias="bookingdatedim">
5161 anupam.sin 176 
				</Table>
177 
				<Level approxRowCount="3" name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
178 
				</Level>
179 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
180 
				</Level>
5200 anupam.sin 181 
				<Level approxRowCount="12" name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
5161 anupam.sin 182 
				</Level>
183 
				<Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
184 
				</Level>
185 
			</Hierarchy>
186 
		</Dimension>
2401 ankur.sing 187 
		<Dimension type="StandardDimension" foreignKey="pincode" name="Geography">
188 
			<Hierarchy name="Territory" hasAll="true" allMemberName="All" primaryKey="pincode">
189 
				<Table name="pincodesB">
190 
				</Table>
3542 vikas 191 
				<Level approxRowCount="25" name="State" column="state" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2401 ankur.sing 192 
				</Level>
3542 vikas 193 
				<Level approxRowCount="10" name="City" column="city" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2401 ankur.sing 194 
				</Level>
195 
				<Level name="Pincode" column="pincode" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
196 
				</Level>
197 
			</Hierarchy>
198 
		</Dimension>
199 
		<Dimension type="StandardDimension" foreignKey="status" name="OrderStatus">
200 
			<Hierarchy name="StatusDim" hasAll="true" allMemberName="All" primaryKey="status">
201 
				<Table name="orderstatus">
202 
				</Table>
5161 anupam.sin 203 
				<Level name="isValid" column="isValid" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2401 ankur.sing 204 
				</Level>
5161 anupam.sin 205 
				<Level name="StatusGroup" column="statusGroup" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2401 ankur.sing 206 
				</Level>
5161 anupam.sin 207 
				<Level name="StatusSubGroup" column="statusSubGroup" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
208 
				</Level>
209 
				<Level name="StatusName" column="statusName" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
210 
				</Level>
2401 ankur.sing 211 
			</Hierarchy>
212 
		</Dimension>
213 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Product">
5161 anupam.sin 214 
			<Hierarchy name="Product Name" hasAll="true" allMemberName="All" primaryKey="id">
2401 ankur.sing 215 
				<Table name="item">
216 
				</Table>
217 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
218 
				</Level>
5417 anupam.sin 219 
				<Level name="Product" column="catalog_item_id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
4029 vikas 220 
					<NameExpression>
221 
						<SQL dialect="generic">
5417 anupam.sin 222 
							concat(IFNULL(model_name, &#39;&#39;), &#39; &#39;, IFNULL(model_number, &#39;&#39;))						</SQL>
4029 vikas 223 
					</NameExpression>
224 
				</Level>
5417 anupam.sin 225 
				<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
226 
				</Level>
4029 vikas 227 
			</Hierarchy>
2401 ankur.sing 228 
		</Dimension>
2532 vikas 229 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
230 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
2553 vikas 231 
				<Table name="item">
2532 vikas 232 
				</Table>
233 
				<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
234 
				</Level>
235 
				<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
236 
				</Level>
2553 vikas 237 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
238 
				</Level>
2532 vikas 239 
			</Hierarchy>
240 
		</Dimension>
3481 vikas 241 
		<Dimension type="StandardDimension" foreignKey="price_range" name="Price">
242 
			<Hierarchy name="Price Range" hasAll="true" allMemberName="All" primaryKey="id">
3542 vikas 243 
				<Table name="pricerange">
3481 vikas 244 
				</Table>
4033 vikas 245 
				<Level name="Price Range" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
2553 vikas 246 
				</Level>
247 
			</Hierarchy>
248 
		</Dimension>
2596 vikas 249 
		<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment">
250 
			<Hierarchy name="Payment" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
2639 vikas 251 
				<Table name="paymentmethod">
2596 vikas 252 
				</Table>
3542 vikas 253 
				<Level approxRowCount="6" name="Gateway" column="gateway" nameColumn="gateway" ordinalColumn="gateway" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2596 vikas 254 
				</Level>
3542 vikas 255 
				<Level name="Payment Method" column="paymentmethodname" nameColumn="paymentmethodname" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2596 vikas 256 
				</Level>
257 
			</Hierarchy>
258 
		</Dimension>
3542 vikas 259 
		<Dimension type="StandardDimension" foreignKey="order_hour" name="Order Hour">
260 
			<Hierarchy name="Order Hour" hasAll="true" allMemberName="All" primaryKey="hour_id">
261 
				<Table name="orderhour">
262 
				</Table>
263 
				<Level name="Hour Range" column="hour_range" ordinalColumn="hour_id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
2639 vikas 264 
				</Level>
3542 vikas 265 
				<Level name="Hour" column="hour_id" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
3393 vikas 266 
				</Level>
2639 vikas 267 
			</Hierarchy>
268 
		</Dimension>
2853 vikas 269 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
3707 vikas 270 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
2834 vikas 271 
				<Table name="user">
2712 vikas 272 
				</Table>
3707 vikas 273 
				<Level name="Source" column="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
274 
					<KeyExpression>
275 
						<SQL dialect="generic">
4029 vikas 276 
							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 277 
					</KeyExpression>
278 
					<NameExpression>
279 
						<SQL dialect="generic">
4029 vikas 280 
							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 281 
					</NameExpression>
282 
				</Level>
3437 vikas 283 
				<Level name="Site" column="source_url" nameColumn="source_url" ordinalColumn="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
2712 vikas 284 
				</Level>
285 
			</Hierarchy>
286 
		</Dimension>
2834 vikas 287 
		<Dimension type="StandardDimension" name="Promotion">
288 
			<Hierarchy name="Promotion" hasAll="true" allMemberName="All">
289 
				<Level name="CouponCode" table="sales" column="coupon_code" nameColumn="coupon_code" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
290 
				</Level>
291 
			</Hierarchy>
292 
		</Dimension>
2853 vikas 293 
		<Dimension type="StandardDimension" name="Session Source">
294 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
3707 vikas 295 
				<Level name="Source" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
296 
					<KeyExpression>
297 
						<SQL dialect="generic">
4029 vikas 298 
							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 299 
					</KeyExpression>
300 
					<NameExpression>
301 
						<SQL dialect="generic">
4029 vikas 302 
							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 303 
					</NameExpression>
304 
				</Level>
3542 vikas 305 
				<Level name="Site" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
2853 vikas 306 
				</Level>
307 
			</Hierarchy>
308 
		</Dimension>
3393 vikas 309 
		<Dimension type="StandardDimension" name="Affiliate">
310 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
311 
				<Level name="Affiliate" table="sales" column="aff_name" nameColumn="aff_name" ordinalColumn="aff_name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
2853 vikas 312 
				</Level>
313 
			</Hierarchy>
314 
		</Dimension>
3484 vikas 315 
		<Dimension type="StandardDimension" foreignKey="days_to_purchase" name="Days To Purchase">
316 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All" primaryKey="id">
3542 vikas 317 
				<Table name="daystopurchaserange">
3484 vikas 318 
				</Table>
319 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
2853 vikas 320 
				</Level>
321 
			</Hierarchy>
322 
		</Dimension>
5391 anupam.sin 323 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
2401 ankur.sing 324 
		</Measure>
5391 anupam.sin 325 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
2596 vikas 326 
		</Measure>
5391 anupam.sin 327 
		<Measure name="Transfer Price" datatype="Numeric" formatString="##,##,##,##,###" aggregator="sum" visible="true">
4029 vikas 328 
			<MeasureExpression>
329 
				<SQL dialect="generic">
330 
					transfer_price*quantity				</SQL>
331 
			</MeasureExpression>
2596 vikas 332 
		</Measure>
333 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[Transfer Price]" dimension="Measures" visible="true">
2553 vikas 334 
		</CalculatedMember>
5161 anupam.sin 335 
		<CalculatedMember name="Average Selling Price" caption="Average Selling Price" formula="[Measures].[Total Sales]/[Measures].[Quantity]" dimension="Measures" visible="true">
336 
		</CalculatedMember>
2401 ankur.sing 337 
	</Cube>
338 
</Schema>