Subversion Repositories SmartDukaan

Rev

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

Rev 2596 Rev 2639
Line 80... Line 80...
80 
				</Level>
 80 
				</Level>
81 
			</Hierarchy>
 81 
			</Hierarchy>
82 
		</Dimension>
 82 
		</Dimension>
83 
		<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment">
 83 
		<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment">
84 
			<Hierarchy name="Payment" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
 84 
			<Hierarchy name="Payment" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
85 
				<Table name="paymentmethod" schema="">
 85 
				<Table name="paymentmethod">
86 
				</Table>
 86 
				</Table>
87 
				<Level name="Gateway" column="gateway" nameColumn="gateway" ordinalColumn="gateway" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 87 
				<Level name="Gateway" column="gateway" nameColumn="gateway" ordinalColumn="gateway" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
88 
				</Level>
 88 
				</Level>
89 
				<Level name="Payment Method" column="paymentmethodname" nameColumn="paymentmethodname" ordinalColumn="paymentmethodname" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 89 
				<Level name="Payment Method" column="paymentmethodname" nameColumn="paymentmethodname" ordinalColumn="paymentmethodname" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
90 
				</Level>
 90 
				</Level>
91 
			</Hierarchy>
 91 
			</Hierarchy>
92 
		</Dimension>
 92 
		</Dimension>
- 
 
 93 
		<Dimension type="StandardDimension" name="Order Hour">
- 
 
 94 
			<Hierarchy name="Order Hour" hasAll="true" allMemberName="All">
- 
 
 95 
				<Level name="Order Hour" table="sales" column="order_hour" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 96 
					<KeyExpression>
- 
 
 97 
						<SQL dialect="generic">
- 
 
 98 
							case when order_hour&#60;6 then 0 when order_hour&#60;12 then 6 when order_hour&#60;15 then 12 when order_hour&#60;18 then 15 else 18 end						</SQL>
- 
 
 99 
					</KeyExpression>
- 
 
 100 
					<NameExpression>
- 
 
 101 
						<SQL dialect="generic">
- 
 
 102 
							case when order_hour&#60;6 then &#34;0am - 6am&#34; when order_hour&#60;12 then &#34;6am - 12pm&#34; when order_hour&#60;15 then &#34;12pm - 15pm&#34; when order_hour&#60;18 then &#34;15pm - 18pm&#34; else &#34;18pm - 24pm&#34; end						</SQL>
- 
 
 103 
					</NameExpression>
- 
 
 104 
					<OrdinalExpression>
- 
 
 105 
						<SQL dialect="generic">
- 
 
 106 
							case when order_hour&#60;6 then 0 when order_hour&#60;12 then 6 when order_hour&#60;15 then 12 when order_hour&#60;18 then 15 else 18 end						</SQL>
- 
 
 107 
					</OrdinalExpression>
- 
 
 108 
				</Level>
- 
 
 109 
			</Hierarchy>
- 
 
 110 
		</Dimension>
93 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 111 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
94 
		</Measure>
 112 
		</Measure>
95 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
 113 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
96 
		</Measure>
 114 
		</Measure>
97 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
 115 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">