Subversion Repositories SmartDukaan

Rev

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

Rev 2834 Rev 2853
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="Source">
 111 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
112 
			<Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id">
 112 
			<Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id">
113 
				<Table name="user">
 113 
				<Table name="user">
114 
				</Table>
 114 
				</Table>
115 
				<Level name="Source" column="source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 115 
				<Level name="Source" column="source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
116 
					<KeyExpression>
 116 
					<KeyExpression>
Line 146... Line 146...
146 
			<Hierarchy name="Promotion" hasAll="true" allMemberName="All">
 146 
			<Hierarchy name="Promotion" hasAll="true" allMemberName="All">
147 
				<Level name="CouponCode" table="sales" column="coupon_code" nameColumn="coupon_code" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 147 
				<Level name="CouponCode" table="sales" column="coupon_code" nameColumn="coupon_code" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
148 
				</Level>
 148 
				</Level>
149 
			</Hierarchy>
 149 
			</Hierarchy>
150 
		</Dimension>
 150 
		</Dimension>
- 
 
 151 
		<Dimension type="StandardDimension" name="Session Source">
- 
 
 152 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
- 
 
 153 
				<Level name="Source" table="sales" column="session_source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 154 
					<KeyExpression>
- 
 
 155 
						<SQL dialect="generic">
- 
 
 156 
							case when session_source is null then &#39;Unknown&#39; when session_source like &#39;DIRECT%&#39; then &#39;Direct&#39; when session_source like &#39;ORGANIC%&#39; then &#39;Organic&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 157 
					</KeyExpression>
- 
 
 158 
					<NameExpression>
- 
 
 159 
						<SQL dialect="generic">
- 
 
 160 
							case when session_source is null then &#39;Unknown&#39; when session_source like &#39;DIRECT%&#39; then &#39;Direct&#39; when session_source like &#39;ORGANIC%&#39; then &#39;Organic&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 161 
					</NameExpression>
- 
 
 162 
					<OrdinalExpression>
- 
 
 163 
						<SQL dialect="generic">
- 
 
 164 
							case when session_source is null then &#39;Unknown&#39; when session_source like &#39;DIRECT%&#39; then &#39;Direct&#39; when session_source like &#39;ORGANIC%&#39; then &#39;Organic&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 165 
					</OrdinalExpression>
- 
 
 166 
				</Level>
- 
 
 167 
				<Level name="Site" table="sales" column="session_source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 168 
					<KeyExpression>
- 
 
 169 
						<SQL dialect="generic">
- 
 
 170 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(session_source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
- 
 
 171 
					</KeyExpression>
- 
 
 172 
					<NameExpression>
- 
 
 173 
						<SQL dialect="generic">
- 
 
 174 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(session_source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
- 
 
 175 
					</NameExpression>
- 
 
 176 
					<OrdinalExpression>
- 
 
 177 
						<SQL dialect="generic">
- 
 
 178 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(session_source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
- 
 
 179 
					</OrdinalExpression>
- 
 
 180 
				</Level>
- 
 
 181 
			</Hierarchy>
- 
 
 182 
		</Dimension>
- 
 
 183 
		<Dimension type="TimeDimension" foreignKey="customer_id" name="First Source TIme">
- 
 
 184 
			<Hierarchy name="First Source TIme" hasAll="true" allMemberName="All" primaryKey="id" primaryKeyTable="user">
- 
 
 185 
				<Join leftKey="source_start_date_id" rightKey="date_id">
- 
 
 186 
					<Table name="user">
- 
 
 187 
					</Table>
- 
 
 188 
					<Table name="datedim">
- 
 
 189 
					</Table>
- 
 
 190 
				</Join>
- 
 
 191 
				<Level name="Year" table="datedim" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
- 
 
 192 
				</Level>
- 
 
 193 
				<Level name="Quarter" table="datedim" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
- 
 
 194 
				</Level>
- 
 
 195 
				<Level name="Month" table="datedim" column="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
- 
 
 196 
				</Level>
- 
 
 197 
				<Level name="Date" table="datedim" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
- 
 
 198 
				</Level>
- 
 
 199 
			</Hierarchy>
- 
 
 200 
		</Dimension>
- 
 
 201 
		<Dimension type="TimeDimension" foreignKey="session_start_date_id" name="Session Time">
- 
 
 202 
			<Hierarchy name="Session Time" hasAll="true" allMemberName="All" primaryKey="date_id">
- 
 
 203 
				<Table name="datedim" schema="" alias="">
- 
 
 204 
				</Table>
- 
 
 205 
				<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
- 
 
 206 
				</Level>
- 
 
 207 
				<Level name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
- 
 
 208 
				</Level>
- 
 
 209 
				<Level name="Month" column="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
- 
 
 210 
				</Level>
- 
 
 211 
				<Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays">
- 
 
 212 
				</Level>
- 
 
 213 
			</Hierarchy>
- 
 
 214 
		</Dimension>
151 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 215 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
152 
		</Measure>
 216 
		</Measure>
153 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
 217 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
154 
		</Measure>
 218 
		</Measure>
155 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
 219 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">