Subversion Repositories SmartDukaan

Rev

Rev 5896 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5896 Rev 7203
Line 170... Line 170...
170 
				</Level>
 170 
				</Level>
171 
				<Level name="StoreId" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 171 
				<Level name="StoreId" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
172 
				</Level>
 172 
				</Level>
173 
			</Hierarchy>
 173 
			</Hierarchy>
174 
		</Dimension>
 174 
		</Dimension>
- 
 
 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>
175 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
 203 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
176 
		</Measure>
 204 
		</Measure>
177 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
 205 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
178 
		</Measure>
 206 
		</Measure>
179 
		<Measure name="Transfer Price" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
 207 
		<Measure name="Transfer Price" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
180 
			<MeasureExpression>
 208 
			<MeasureExpression>
181 
				<SQL dialect="generic">
 209 
				<SQL dialect="generic">
182 
					transfer_price*quantity				</SQL>
 210 
					transfer_price*quantity				</SQL>
183 
			</MeasureExpression>
 211 
			</MeasureExpression>
184 
		</Measure>
 212 
		</Measure>
- 
 
 213 
		<Measure name="NLC" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
- 
 
 214 
			<MeasureExpression>
- 
 
 215 
				<SQL dialect="generic">
- 
 
 216 
					nlc*quantity				</SQL>
- 
 
 217 
			</MeasureExpression>
- 
 
 218 
		</Measure>
185 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[Transfer Price]" dimension="Measures" visible="true">
 219 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[NLC]" dimension="Measures" visible="true">
186 
		</CalculatedMember>
 220 
		</CalculatedMember>
187 
		<CalculatedMember name="Average Selling Price" caption="Average Selling Price" formula="[Measures].[Total Sales]/[Measures].[Quantity]" dimension="Measures" visible="true">
 221 
		<CalculatedMember name="Average Selling Price" caption="Average Selling Price" formula="[Measures].[Total Sales]/[Measures].[Quantity]" dimension="Measures" visible="true">
188 
		</CalculatedMember>
 222 
		</CalculatedMember>
189 
	</Cube>
 223 
	</Cube>
190 
	<Cube name="SalesBookingCube" cache="true" enabled="true">
 224 
	<Cube name="SalesBookingCube" cache="true" enabled="true">
Line 358... Line 392...
358 
				</Level>
 392 
				</Level>
359 
				<Level name="StoreId" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 393 
				<Level name="StoreId" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
360 
				</Level>
 394 
				</Level>
361 
			</Hierarchy>
 395 
			</Hierarchy>
362 
		</Dimension>
 396 
		</Dimension>
- 
 
 397 
		<Dimension type="StandardDimension" foreignKey="insurer" name="Insurer">
- 
 
 398 
			<Hierarchy name="Insurer" hasAll="true" allMemberName="All">
- 
 
 399 
				<Level name="Insurer" table="sales" column="insurer" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 400 
					<KeyExpression>
- 
 
 401 
						<SQL dialect="generic">
- 
 
 402 
							case when insurer > 0 then &#39;New India Assurance&#39;  else &#39;N/A&#39; end						</SQL>
- 
 
 403 
					</KeyExpression>
- 
 
 404 
					<NameExpression>
- 
 
 405 
						<SQL dialect="generic">
- 
 
 406 
							case when insurer > 0 then &#39;New India Assurance&#39;  else &#39;N/A&#39; end						</SQL>
- 
 
 407 
					</NameExpression>
- 
 
 408 
				</Level>
- 
 
 409 
			</Hierarchy>
- 
 
 410 
		</Dimension>
- 
 
 411 
		<Dimension type="StandardDimension" foreignKey="otg" name="OTG">
- 
 
 412 
			<Hierarchy name="OTG" hasAll="true" allMemberName="All">
- 
 
 413 
				<Level name="OTG" table="sales" column="otg" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 414 
					<KeyExpression>
- 
 
 415 
						<SQL dialect="generic">
- 
 
 416 
							case when otg = 1 then &#39;Yes&#39;  else &#39;No&#39; end						</SQL>
- 
 
 417 
					</KeyExpression>
- 
 
 418 
					<NameExpression>
- 
 
 419 
						<SQL dialect="generic">
- 
 
 420 
							case when otg = 1 then &#39;Yes&#39;  else &#39;No&#39; end						</SQL>
- 
 
 421 
					</NameExpression>
- 
 
 422 
				</Level>
- 
 
 423 
			</Hierarchy>
- 
 
 424 
		</Dimension>
363 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
 425 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
364 
		</Measure>
 426 
		</Measure>
365 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
 427 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
366 
		</Measure>
 428 
		</Measure>
367 
		<Measure name="Transfer Price" datatype="Numeric" formatString="##,##,##,##,###" aggregator="sum" visible="true">
 429 
		<Measure name="Transfer Price" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
368 
			<MeasureExpression>
 430 
			<MeasureExpression>
369 
				<SQL dialect="generic">
 431 
				<SQL dialect="generic">
370 
					transfer_price*quantity				</SQL>
 432 
					transfer_price*quantity				</SQL>
371 
			</MeasureExpression>
 433 
			</MeasureExpression>
372 
		</Measure>
 434 
		</Measure>
- 
 
 435 
		<Measure name="NLC" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
- 
 
 436 
			<MeasureExpression>
- 
 
 437 
				<SQL dialect="generic">
- 
 
 438 
					nlc*quantity				</SQL>
- 
 
 439 
			</MeasureExpression>
- 
 
 440 
		</Measure>
373 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[Transfer Price]" dimension="Measures" visible="true">
 441 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[NLC]" dimension="Measures" visible="true">
374 
		</CalculatedMember>
 442 
		</CalculatedMember>
375 
		<CalculatedMember name="Average Selling Price" caption="Average Selling Price" formula="[Measures].[Total Sales]/[Measures].[Quantity]" dimension="Measures" visible="true">
 443 
		<CalculatedMember name="Average Selling Price" caption="Average Selling Price" formula="[Measures].[Total Sales]/[Measures].[Quantity]" dimension="Measures" visible="true">
376 
		</CalculatedMember>
 444 
		</CalculatedMember>
377 
	</Cube>
 445 
	</Cube>
378 
</Schema>
 446 
</Schema>