Subversion Repositories SmartDukaan

Rev

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

Rev 3542 Rev 3707
Line 89... Line 89...
89 
				<Level name="Hour" column="hour_id" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 89 
				<Level name="Hour" column="hour_id" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
90 
				</Level>
 90 
				</Level>
91 
			</Hierarchy>
 91 
			</Hierarchy>
92 
		</Dimension>
 92 
		</Dimension>
93 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
 93 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
94 
			<Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id">
 94 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
95 
				<Table name="user">
 95 
				<Table name="user">
96 
				</Table>
 96 
				</Table>
97 
				<Level name="Source" column="source_type" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 97 
				<Level name="Paid" column="source_type" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 98 
					<KeyExpression>
- 
 
 99 
						<SQL dialect="generic">
- 
 
 100 
							case when source_type = &#39;Paid&#39; then &#39;Paid&#39; else &#39;Non Paid&#39; end						</SQL>
- 
 
 101 
					</KeyExpression>
- 
 
 102 
					<NameExpression>
- 
 
 103 
						<SQL dialect="generic">
- 
 
 104 
							case when source_type = &#39;Paid&#39; then &#39;Paid&#39; else &#39;Non Paid&#39; end						</SQL>
- 
 
 105 
					</NameExpression>
- 
 
 106 
				</Level>
- 
 
 107 
				<Level name="Source" column="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 108 
					<KeyExpression>
- 
 
 109 
						<SQL dialect="generic">
- 
 
 110 
							case when source_url like &#39;saholic.com%&#39; then &#39;Direct&#39; when source_url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 111 
					</KeyExpression>
- 
 
 112 
					<NameExpression>
- 
 
 113 
						<SQL dialect="generic">
- 
 
 114 
							case when source_url like &#39;saholic.com%&#39; then &#39;Direct&#39; when source_url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 115 
					</NameExpression>
98 
				</Level>
 116 
				</Level>
99 
				<Level name="Site" column="source_url" nameColumn="source_url" ordinalColumn="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 117 
				<Level name="Site" column="source_url" nameColumn="source_url" ordinalColumn="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
100 
				</Level>
 118 
				</Level>
101 
			</Hierarchy>
 119 
			</Hierarchy>
102 
		</Dimension>
 120 
		</Dimension>
Line 106... Line 124...
106 
				</Level>
 124 
				</Level>
107 
			</Hierarchy>
 125 
			</Hierarchy>
108 
		</Dimension>
 126 
		</Dimension>
109 
		<Dimension type="StandardDimension" name="Session Source">
 127 
		<Dimension type="StandardDimension" name="Session Source">
110 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
 128 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
111 
				<Level name="Source" table="sales" column="session_source_type" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 129 
				<Level name="Paid" table="sales" column="session_source_type" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 130 
					<KeyExpression>
- 
 
 131 
						<SQL dialect="generic">
- 
 
 132 
							case when session_source_type = &#39;Paid&#39; then &#39;Paid&#39; else &#39;Non Paid&#39; end						</SQL>
- 
 
 133 
					</KeyExpression>
- 
 
 134 
					<NameExpression>
- 
 
 135 
						<SQL dialect="generic">
- 
 
 136 
							case when session_source_type = &#39;Paid&#39; then &#39;Paid&#39; else &#39;Non Paid&#39; end						</SQL>
- 
 
 137 
					</NameExpression>
- 
 
 138 
				</Level>
- 
 
 139 
				<Level name="Source" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 140 
					<KeyExpression>
- 
 
 141 
						<SQL dialect="generic">
- 
 
 142 
							case when session_source_url like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source_url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 143 
					</KeyExpression>
- 
 
 144 
					<NameExpression>
- 
 
 145 
						<SQL dialect="generic">
- 
 
 146 
							case when session_source_url like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source_url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 147 
					</NameExpression>
112 
				</Level>
 148 
				</Level>
113 
				<Level name="Site" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 149 
				<Level name="Site" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
114 
				</Level>
 150 
				</Level>
115 
			</Hierarchy>
 151 
			</Hierarchy>
116 
		</Dimension>
 152 
		</Dimension>