Subversion Repositories SmartDukaan

Rev

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

Rev 3222 Rev 3393
Line 90... Line 90...
90 
				</Level>
 90 
				</Level>
91 
			</Hierarchy>
 91 
			</Hierarchy>
92 
		</Dimension>
 92 
		</Dimension>
93 
		<Dimension type="StandardDimension" name="Order Hour">
 93 
		<Dimension type="StandardDimension" name="Order Hour">
94 
			<Hierarchy name="Order Hour" hasAll="true" allMemberName="All">
 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">
 95 
				<Level name="Order Hour Range" table="sales" column="order_hour" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
96 
					<KeyExpression>
 96 
					<KeyExpression>
97 
						<SQL dialect="generic">
 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>
 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>
 99 
					</KeyExpression>
100 
					<NameExpression>
 100 
					<NameExpression>
Line 104... Line 104...
104 
					<OrdinalExpression>
 104 
					<OrdinalExpression>
105 
						<SQL dialect="generic">
 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>
 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 
				<Level name="Order Hour" table="sales" column="order_hour" ordinalColumn="order_hour" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 110 
				</Level>
109 
			</Hierarchy>
 111 
			</Hierarchy>
110 
		</Dimension>
 112 
		</Dimension>
111 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
 113 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
112 
			<Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id">
 114 
			<Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id">
113 
				<Table name="user">
 115 
				<Table name="user">
114 
				</Table>
 116 
				</Table>
115 
				<Level name="Source" column="source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 117 
				<Level name="Source" column="source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
116 
					<KeyExpression>
 118 
					<KeyExpression>
117 
						<SQL dialect="generic">
 119 
						<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>
 120 
							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; when source like &#39;PAID%&#39; then &#39;Paid&#39; else &#39;Referer&#39; end						</SQL>
119 
					</KeyExpression>
 121 
					</KeyExpression>
120 
					<NameExpression>
 122 
					<NameExpression>
121 
						<SQL dialect="generic">
 123 
						<SQL dialect="generic">
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>
 124 
							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; when source like &#39;PAID%&#39; then &#39;Paid&#39; else &#39;Referer&#39; end						</SQL>
123 
					</NameExpression>
 125 
					</NameExpression>
124 
					<OrdinalExpression>
 126 
					<OrdinalExpression>
125 
						<SQL dialect="generic">
 127 
						<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>
 128 
							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; when source like &#39;PAID%&#39; then &#39;Paid&#39; else &#39;Referer&#39; end						</SQL>
127 
					</OrdinalExpression>
 129 
					</OrdinalExpression>
128 
				</Level>
 130 
				</Level>
129 
				<Level name="Site" column="source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 131 
				<Level name="Site" column="source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
130 
					<KeyExpression>
 132 
					<KeyExpression>
131 
						<SQL dialect="generic">
 133 
						<SQL dialect="generic">
Line 151... Line 153...
151 
		<Dimension type="StandardDimension" name="Session Source">
 153 
		<Dimension type="StandardDimension" name="Session Source">
152 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
 154 
			<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">
 155 
				<Level name="Source" table="sales" column="session_source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
154 
					<KeyExpression>
 156 
					<KeyExpression>
155 
						<SQL dialect="generic">
 157 
						<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>
 158 
							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; when session_source like &#39;PAID%&#39; then &#39;Paid&#39; else &#39;Referer&#39; end						</SQL>
157 
					</KeyExpression>
 159 
					</KeyExpression>
158 
					<NameExpression>
 160 
					<NameExpression>
159 
						<SQL dialect="generic">
 161 
						<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>
 162 
							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; when session_source like &#39;PAID%&#39; then &#39;Paid&#39; else &#39;Referer&#39; end						</SQL>
161 
					</NameExpression>
 163 
					</NameExpression>
162 
					<OrdinalExpression>
 164 
					<OrdinalExpression>
163 
						<SQL dialect="generic">
 165 
						<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>
 166 
							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; when session_source like &#39;PAID%&#39; then &#39;Paid&#39; else &#39;Referer&#39; end						</SQL>
165 
					</OrdinalExpression>
 167 
					</OrdinalExpression>
166 
				</Level>
 168 
				</Level>
167 
				<Level name="Site" table="sales" column="session_source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 169 
				<Level name="Site" table="sales" column="session_source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
168 
					<KeyExpression>
 170 
					<KeyExpression>
169 
						<SQL dialect="generic">
 171 
						<SQL dialect="generic">
Line 178... Line 180...
178 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(session_source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
 180 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(session_source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
179 
					</OrdinalExpression>
 181 
					</OrdinalExpression>
180 
				</Level>
 182 
				</Level>
181 
			</Hierarchy>
 183 
			</Hierarchy>
182 
		</Dimension>
 184 
		</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" alias="datedim2">
 - 
 
189 
					</Table>
 - 
 
190 
				</Join>
 - 
 
191 
				<Level name="Year" table="datedim2" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
 - 
 
192 
				</Level>
 - 
 
193 
				<Level name="Quarter" table="datedim2" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
 - 
 
194 
				</Level>
 - 
 
195 
				<Level name="Month" table="datedim2" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
 - 
 
196 
				</Level>
 - 
 
197 
				<Level name="Date" table="datedim2" 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" alias="datedim3">
 - 
 
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="monthnumber" nameColumn="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" hideMemberIf="Never">
 - 
 
212 
				</Level>
 - 
 
213 
			</Hierarchy>
 - 
 
214 
		</Dimension>
 - 
 
215 
		<Dimension type="StandardDimension" name="Affiliate">
 185 
		<Dimension type="StandardDimension" name="Affiliate">
216 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
 186 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
217 
				<Level name="Affiliate" table="sales" column="aff_name" nameColumn="aff_name" ordinalColumn="aff_name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 187 
				<Level name="Affiliate" table="sales" column="aff_name" nameColumn="aff_name" ordinalColumn="aff_name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
218 
				</Level>
 188 
				</Level>
219 
			</Hierarchy>
 189 
			</Hierarchy>
220 
		</Dimension>
 190 
		</Dimension>
- 
 
 191 
		<Dimension type="StandardDimension" name="Days To Purchase">
- 
 
 192 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All">
- 
 
 193 
				<Level name="Days To Purchase" table="sales" column="first_source_start_date_id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 194 
					<KeyExpression>
- 
 
 195 
						<SQL dialect="generic">
- 
 
 196 
							case when session_start_date_id-first_source_start_date_id&#62;30 then &#39;&#62; month&#39; when session_start_date_id-first_source_start_date_id&#62;15 then &#39;&#62; 15 days&#39; when session_start_date_id-first_source_start_date_id&#62;7 then &#39;&#62; 7 days&#39; when session_start_date_id-first_source_start_date_id&#62;2 then &#39;&#62; 2 days&#39; when session_start_date_id-first_source_start_date_id&#62;1 then &#39;&#62; 1 day&#39; else &#39;same day&#39; end						</SQL>
- 
 
 197 
					</KeyExpression>
- 
 
 198 
					<NameExpression>
- 
 
 199 
						<SQL dialect="generic">
- 
 
 200 
							case when session_start_date_id-first_source_start_date_id&#62;30 then &#39;&#62; month&#39; when session_start_date_id-first_source_start_date_id&#62;15 then &#39;&#62; 15 days&#39; when session_start_date_id-first_source_start_date_id&#62;7 then &#39;&#62; 7 days&#39; when session_start_date_id-first_source_start_date_id&#62;2 then &#39;&#62; 2 days&#39; when session_start_date_id-first_source_start_date_id&#62;1 then &#39;&#62; 1 day&#39; else &#39;same day&#39; end						</SQL>
- 
 
 201 
					</NameExpression>
- 
 
 202 
					<OrdinalExpression>
- 
 
 203 
						<SQL dialect="generic">
- 
 
 204 
							session_start_date_id-first_source_start_date_id						</SQL>
- 
 
 205 
					</OrdinalExpression>
- 
 
 206 
				</Level>
- 
 
 207 
			</Hierarchy>
- 
 
 208 
		</Dimension>
221 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 209 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
222 
		</Measure>
 210 
		</Measure>
223 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
 211 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
224 
		</Measure>
 212 
		</Measure>
225 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
 213 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">