Subversion Repositories SmartDukaan

Rev

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

Rev 3707 Rev 4029
Line 47... Line 47...
47 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 47 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
48 
				</Level>
 48 
				</Level>
49 
				<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 49 
				<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
50 
				</Level>
 50 
				</Level>
51 
			</Hierarchy>
 51 
			</Hierarchy>
- 
 
 52 
			<Hierarchy name="Product Name" hasAll="true" primaryKey="id">
- 
 
 53 
				<Table name="item">
- 
 
 54 
				</Table>
- 
 
 55 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 56 
				</Level>
- 
 
 57 
				<Level name="Product" column="id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 58 
					<NameExpression>
- 
 
 59 
						<SQL dialect="generic">
- 
 
 60 
							concat(IFNULL(model_name, &#39;&#39;), &#39; &#39;, IFNULL(model_number, &#39;&#39;), &#39;(&#39;, IFNULL(color, &#39;&#39;), &#39;)&#39;)						</SQL>
- 
 
 61 
					</NameExpression>
- 
 
 62 
				</Level>
- 
 
 63 
			</Hierarchy>
52 
		</Dimension>
 64 
		</Dimension>
53 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
 65 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
54 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
 66 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
55 
				<Table name="item">
 67 
				<Table name="item">
56 
				</Table>
 68 
				</Table>
Line 92... Line 104...
92 
		</Dimension>
 104 
		</Dimension>
93 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
 105 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
94 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
 106 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
95 
				<Table name="user">
 107 
				<Table name="user">
96 
				</Table>
 108 
				</Table>
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">
 109 
				<Level name="Source" column="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
108 
					<KeyExpression>
 110 
					<KeyExpression>
109 
						<SQL dialect="generic">
 111 
						<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>
 112 
							case when source_type = &#39;Paid&#39; then &#39;Paid&#39; 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>
 113 
					</KeyExpression>
112 
					<NameExpression>
 114 
					<NameExpression>
113 
						<SQL dialect="generic">
 115 
						<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>
 116 
							case when source_type = &#39;Paid&#39; then &#39;Paid&#39; 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>
 117 
					</NameExpression>
116 
				</Level>
 118 
				</Level>
117 
				<Level name="Site" column="source_url" nameColumn="source_url" ordinalColumn="source_url" 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">
118 
				</Level>
 120 
				</Level>
119 
			</Hierarchy>
 121 
			</Hierarchy>
Line 124... Line 126...
124 
				</Level>
 126 
				</Level>
125 
			</Hierarchy>
 127 
			</Hierarchy>
126 
		</Dimension>
 128 
		</Dimension>
127 
		<Dimension type="StandardDimension" name="Session Source">
 129 
		<Dimension type="StandardDimension" name="Session Source">
128 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
 130 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
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">
 131 
				<Level name="Source" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
140 
					<KeyExpression>
 132 
					<KeyExpression>
141 
						<SQL dialect="generic">
 133 
						<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>
 134 
							case when session_source_type = &#39;Paid&#39; then &#39;Paid&#39; 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>
 135 
					</KeyExpression>
144 
					<NameExpression>
 136 
					<NameExpression>
145 
						<SQL dialect="generic">
 137 
						<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>
 138 
							case when session_source_type = &#39;Paid&#39; then &#39;Paid&#39; 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>
 139 
					</NameExpression>
148 
				</Level>
 140 
				</Level>
149 
				<Level name="Site" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 141 
				<Level name="Site" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
150 
				</Level>
 142 
				</Level>
151 
			</Hierarchy>
 143 
			</Hierarchy>
Line 168... Line 160...
168 
		</Measure>
 160 
		</Measure>
169 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
 161 
		<Measure name="Average Selling Price" column="total_amount" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
170 
		</Measure>
 162 
		</Measure>
171 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
 163 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
172 
		</Measure>
 164 
		</Measure>
173 
		<Measure name="Transfer Price" column="transfer_price" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
 165 
		<Measure name="Transfer Price" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
- 
 
 166 
			<MeasureExpression>
- 
 
 167 
				<SQL dialect="generic">
- 
 
 168 
					transfer_price*quantity				</SQL>
- 
 
 169 
			</MeasureExpression>
174 
		</Measure>
 170 
		</Measure>
175 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[Transfer Price]" dimension="Measures" visible="true">
 171 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[Transfer Price]" dimension="Measures" visible="true">
176 
		</CalculatedMember>
 172 
		</CalculatedMember>
177 
	</Cube>
 173 
	</Cube>
178 
</Schema>
 174 
</Schema>