Subversion Repositories SmartDukaan

Rev

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

Rev 3393 Rev 3437
Line 112... Line 112...
112 
		</Dimension>
 112 
		</Dimension>
113 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
 113 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
114 
			<Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id">
 114 
			<Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id">
115 
				<Table name="user">
 115 
				<Table name="user">
116 
				</Table>
 116 
				</Table>
117 
				<Level name="Source" column="source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 - 
 
118 
					<KeyExpression>
 - 
 
119 
						<SQL dialect="generic">
 - 
 
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>
 117 
				<Level name="Source" column="source_type" nameColumn="source_type" ordinalColumn="source_type" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
121 
					</KeyExpression>
 - 
 
122 
					<NameExpression>
 - 
 
123 
						<SQL dialect="generic">
 - 
 
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>
 - 
 
125 
					</NameExpression>
 - 
 
126 
					<OrdinalExpression>
 - 
 
127 
						<SQL dialect="generic">
 - 
 
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>
 - 
 
129 
					</OrdinalExpression>
 - 
 
130 
				</Level>
 118 
				</Level>
131 
				<Level name="Site" column="source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 119 
				<Level name="Site" column="source_url" nameColumn="source_url" ordinalColumn="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
132 
					<KeyExpression>
 - 
 
133 
						<SQL dialect="generic">
 - 
 
134 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
 - 
 
135 
					</KeyExpression>
 - 
 
136 
					<NameExpression>
 - 
 
137 
						<SQL dialect="generic">
 - 
 
138 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
 - 
 
139 
					</NameExpression>
 - 
 
140 
					<OrdinalExpression>
 - 
 
141 
						<SQL dialect="generic">
 - 
 
142 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
 - 
 
143 
					</OrdinalExpression>
 - 
 
144 
				</Level>
 120 
				</Level>
145 
			</Hierarchy>
 121 
			</Hierarchy>
146 
		</Dimension>
 122 
		</Dimension>
147 
		<Dimension type="StandardDimension" name="Promotion">
 123 
		<Dimension type="StandardDimension" name="Promotion">
148 
			<Hierarchy name="Promotion" hasAll="true" allMemberName="All">
 124 
			<Hierarchy name="Promotion" hasAll="true" allMemberName="All">
Line 150... Line 126...
150 
				</Level>
 126 
				</Level>
151 
			</Hierarchy>
 127 
			</Hierarchy>
152 
		</Dimension>
 128 
		</Dimension>
153 
		<Dimension type="StandardDimension" name="Session Source">
 129 
		<Dimension type="StandardDimension" name="Session Source">
154 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
 130 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
155 
				<Level name="Source" table="sales" column="session_source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 - 
 
156 
					<KeyExpression>
 - 
 
157 
						<SQL dialect="generic">
 - 
 
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>
 131 
				<Level name="Source" table="sales" column="session_source_type" nameColumn="session_source_type" ordinalColumn="session_source_type" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
159 
					</KeyExpression>
 - 
 
160 
					<NameExpression>
 - 
 
161 
						<SQL dialect="generic">
 - 
 
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>
 - 
 
163 
					</NameExpression>
 - 
 
164 
					<OrdinalExpression>
 - 
 
165 
						<SQL dialect="generic">
 - 
 
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>
 - 
 
167 
					</OrdinalExpression>
 - 
 
168 
				</Level>
 132 
				</Level>
169 
				<Level name="Site" table="sales" column="session_source" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 133 
				<Level name="Site" table="sales" column="session_source_url" nameColumn="session_source_url" ordinalColumn="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
170 
					<KeyExpression>
 - 
 
171 
						<SQL dialect="generic">
 - 
 
172 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(session_source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
 - 
 
173 
					</KeyExpression>
 - 
 
174 
					<NameExpression>
 - 
 
175 
						<SQL dialect="generic">
 - 
 
176 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(session_source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
 - 
 
177 
					</NameExpression>
 - 
 
178 
					<OrdinalExpression>
 - 
 
179 
						<SQL dialect="generic">
 - 
 
180 
							SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(session_source,&#39;://&#39;,-1),&#39;/&#39;,1),&#39;www.&#39;,-1)						</SQL>
 - 
 
181 
					</OrdinalExpression>
 - 
 
182 
				</Level>
 134 
				</Level>
183 
			</Hierarchy>
 135 
			</Hierarchy>
184 
		</Dimension>
 136 
		</Dimension>
185 
		<Dimension type="StandardDimension" name="Affiliate">
 137 
		<Dimension type="StandardDimension" name="Affiliate">
186 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
 138 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">