Subversion Repositories SmartDukaan

Rev

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

Rev 2712 Rev 2801
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">
 111 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="Source">
112 
			<Hierarchy name="User" hasAll="true" allMemberName="All" primaryKey="id">
 112 
			<Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id">
113 
				<Table name="user" schema="" alias="">
 113 
				<Table name="user" schema="" alias="">
114 
				</Table>
 114 
				</Table>
115 
				<Level name="Sex" column="sex" type="Numeric" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 115 
				<Level name="Source" column="source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 116 
					<KeyExpression>
- 
 
 117 
						<SQL dialect="generic">
- 
 
 118 
							case when source is null then &#39;Unknown&#39; when source like &#39;DIRECT%&#39; then &#39;Direct&#39; when source like &#39;ORGANIC%&#39; then &#39;Organic&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 119 
					</KeyExpression>
116 
					<NameExpression>
 120 
					<NameExpression>
117 
						<SQL dialect="generic">
 121 
						<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>
 122 
							case when source is null then &#39;Unknown&#39; when source like &#39;DIRECT%&#39; then &#39;Direct&#39; when source like &#39;ORGANIC%&#39; then &#39;Organic&#39; else &#39;Referer&#39; end						</SQL>
119 
					</NameExpression>
 123 
					</NameExpression>
- 
 
 124 
					<OrdinalExpression>
- 
 
 125 
						<SQL dialect="generic">
- 
 
 126 
							case when source is null then &#39;Unknown&#39; when source like &#39;DIRECT%&#39; then &#39;Direct&#39; when source like &#39;ORGANIC%&#39; then &#39;Organic&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 127 
					</OrdinalExpression>
120 
				</Level>
 128 
				</Level>
121 
				<Level name="User" column="email" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 129 
				<Level name="Site" column="source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 130 
					<KeyExpression>
122 
					<Property name="name" column="name" type="String">
 131 
						<SQL dialect="generic">
- 
 
 132 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
123 
					</Property>
 133 
					</KeyExpression>
- 
 
 134 
					<NameExpression>
124 
					<Property name="DOB" column="date_of_birth" type="String">
 135 
						<SQL dialect="generic">
- 
 
 136 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
125 
					</Property>
 137 
					</NameExpression>
- 
 
 138 
					<OrdinalExpression>
126 
					<Property name="Source" column="source" type="String">
 139 
						<SQL dialect="generic">
- 
 
 140 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
127 
					</Property>
 141 
					</OrdinalExpression>
128 
				</Level>
 142 
				</Level>
129 
			</Hierarchy>
 143 
			</Hierarchy>
130 
		</Dimension>
 144 
		</Dimension>
131 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 145 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
132 
		</Measure>
 146 
		</Measure>