Subversion Repositories SmartDukaan

Rev

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

Rev 3543 Rev 3707
Line 40... Line 40...
40 
				</Level>
 40 
				</Level>
41 
			</Hierarchy>
 41 
			</Hierarchy>
42 
		</Dimension>
 42 
		</Dimension>
43 
		<Dimension type="StandardDimension" name="Paid First Source">
 43 
		<Dimension type="StandardDimension" name="Paid First Source">
44 
			<Hierarchy name="Paid First Source" hasAll="true" allMemberName="All">
 44 
			<Hierarchy name="Paid First Source" hasAll="true" allMemberName="All">
45 
				<Level name="Paid First Source" table="productactivity" column="is_first_source_paid" type="Boolean" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 45 
				<Level name="Paid First Source" table="productactivity" column="is_first_source_paid" type="Boolean" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
46 
				</Level>
 46 
				</Level>
47 
			</Hierarchy>
 47 
			</Hierarchy>
48 
		</Dimension>
 48 
		</Dimension>
49 
		<Dimension type="StandardDimension" foreignKey="first_source_id" name="First Source">
 49 
		<Dimension type="StandardDimension" foreignKey="first_source_id" name="First Source">
50 
			<Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id">
 50 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
51 
				<Table name="source">
 51 
				<Table name="source">
52 
				</Table>
 52 
				</Table>
53 
				<Level name="First Source" column="url" nameColumn="url" ordinalColumn="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 53 
				<Level name="First Source" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 54 
					<KeyExpression>
- 
 
 55 
						<SQL dialect="generic">
- 
 
 56 
							case when url like &#39;saholic.com%&#39; then &#39;Direct&#39;  when url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 57 
					</KeyExpression>
- 
 
 58 
					<NameExpression>
- 
 
 59 
						<SQL dialect="generic">
- 
 
 60 
							case when url like &#39;saholic.com%&#39; then &#39;Direct&#39; when url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 61 
					</NameExpression>
- 
 
 62 
				</Level>
- 
 
 63 
				<Level name="site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
54 
				</Level>
 64 
				</Level>
55 
			</Hierarchy>
 65 
			</Hierarchy>
56 
		</Dimension>
 66 
		</Dimension>
57 
		<Dimension type="StandardDimension" name="Paid Session Source">
 67 
		<Dimension type="StandardDimension" name="Paid Session Source">
58 
			<Hierarchy name="Paid Session Source" hasAll="true" allMemberName="All">
 68 
			<Hierarchy name="Paid Session Source" hasAll="true" allMemberName="All">
59 
				<Level name="Paid Session Source" table="productactivity" column="is_session_source_paid" type="Boolean" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 69 
				<Level name="Paid Session Source" table="productactivity" column="is_session_source_paid" type="Boolean" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
60 
				</Level>
 70 
				</Level>
61 
			</Hierarchy>
 71 
			</Hierarchy>
62 
		</Dimension>
 72 
		</Dimension>
63 
		<Dimension type="StandardDimension" foreignKey="session_source_id" name="Session Source">
 73 
		<Dimension type="StandardDimension" foreignKey="session_source_id" name="Session Source">
64 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All" primaryKey="id">
 74 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All" primaryKey="id">
65 
				<Table name="source" alias="session_source">
 75 
				<Table name="source" alias="session_source">
66 
				</Table>
 76 
				</Table>
67 
				<Level name="SessionSource" column="url" nameColumn="url" ordinalColumn="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 77 
				<Level name="SessionSource" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 78 
					<KeyExpression>
- 
 
 79 
						<SQL dialect="generic">
- 
 
 80 
							case when url like &#39;saholic.com%&#39; then &#39;Direct&#39; when url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 81 
					</KeyExpression>
- 
 
 82 
					<NameExpression>
- 
 
 83 
						<SQL dialect="generic">
- 
 
 84 
							case when url like &#39;saholic.com%&#39; then &#39;Direct&#39; when url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 85 
					</NameExpression>
- 
 
 86 
				</Level>
- 
 
 87 
				<Level name="Site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
68 
				</Level>
 88 
				</Level>
69 
			</Hierarchy>
 89 
			</Hierarchy>
70 
		</Dimension>
 90 
		</Dimension>
71 
		<Measure name="View" column="view" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 91 
		<Measure name="View" column="view" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
72 
		</Measure>
 92 
		</Measure>