Subversion Repositories SmartDukaan

Rev

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

Rev 2801 Rev 2834
Line 108... Line 108...
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="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" schema="" alias="">
 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>
117 
						<SQL dialect="generic">
 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>
 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>
Line 140... Line 140...
140 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
 140 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
141 
					</OrdinalExpression>
 141 
					</OrdinalExpression>
142 
				</Level>
 142 
				</Level>
143 
			</Hierarchy>
 143 
			</Hierarchy>
144 
		</Dimension>
 144 
		</Dimension>
- 
 
 145 
		<Dimension type="StandardDimension" name="Promotion">
- 
 
 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">
- 
 
 148 
				</Level>
- 
 
 149 
			</Hierarchy>
- 
 
 150 
		</Dimension>
145 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 151 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
146 
		</Measure>
 152 
		</Measure>
147 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
 153 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
148 
		</Measure>
 154 
		</Measure>
149 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
 155 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">