Subversion Repositories SmartDukaan

Rev

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

Rev 2639 Rev 2712
Line 106... Line 106...
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>
 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>
 107 
					</OrdinalExpression>
108 
				</Level>
 108 
				</Level>
109 
			</Hierarchy>
 109 
			</Hierarchy>
110 
		</Dimension>
 110 
		</Dimension>
- 
 
 111 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="User">
- 
 
 112 
			<Hierarchy name="User" hasAll="true" allMemberName="All" primaryKey="id">
- 
 
 113 
				<Table name="user" schema="" alias="">
- 
 
 114 
				</Table>
- 
 
 115 
				<Level name="Sex" column="sex" type="Numeric" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 116 
					<NameExpression>
- 
 
 117 
						<SQL dialect="generic">
- 
 
 118 
							case when sex=0 then &#39;-&#39; when sex=1 then &#39;M&#39; when sex=2 then &#39;F&#39; end						</SQL>
- 
 
 119 
					</NameExpression>
- 
 
 120 
				</Level>
- 
 
 121 
				<Level name="User" column="email" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 122 
					<Property name="name" column="name" type="String">
- 
 
 123 
					</Property>
- 
 
 124 
					<Property name="DOB" column="date_of_birth" type="String">
- 
 
 125 
					</Property>
- 
 
 126 
					<Property name="Source" column="source" type="String">
- 
 
 127 
					</Property>
- 
 
 128 
				</Level>
- 
 
 129 
			</Hierarchy>
- 
 
 130 
		</Dimension>
111 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 131 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
112 
		</Measure>
 132 
		</Measure>
113 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
 133 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
114 
		</Measure>
 134 
		</Measure>
115 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
 135 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">