Subversion Repositories SmartDukaan

Rev

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

Rev 3437 Rev 3481
Line 60... Line 60...
60 
				</Level>
 60 
				</Level>
61 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 61 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
62 
				</Level>
 62 
				</Level>
63 
			</Hierarchy>
 63 
			</Hierarchy>
64 
		</Dimension>
 64 
		</Dimension>
65 
		<Dimension type="StandardDimension" name="Price">
 65 
		<Dimension type="StandardDimension" foreignKey="price_range" name="Price">
66 
			<Hierarchy name="Price" hasAll="true" allMemberName="All">
 66 
			<Hierarchy name="Price Range" hasAll="true" allMemberName="All" primaryKey="id">
67 
				<Level name="Price" table="sales" column="unit_price" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 - 
 
68 
					<KeyExpression>
 - 
 
69 
						<SQL dialect="generic">
 - 
 
70 
							case when unit_price&#60;2000 then 0 when unit_price &#60; 5000 then 2000 when unit_price &#60; 10000 then 5000 when unit_price &#60; 15000 then 10000 when unit_price &#60;20000 then 15000 when unit_price &#60; 50000 then 20000 else 50000 end						</SQL>
 67 
				<Table name="pricerange" schema="" alias="">
71 
					</KeyExpression>
 - 
 
72 
					<NameExpression>
 - 
 
73 
						<SQL dialect="generic">
 - 
 
74 
							case when unit_price&#60;2000 then &#39;0 - 2000&#39; when unit_price &#60; 5000 then &#39;2000 - 5000&#39; when unit_price &#60; 10000 then &#39;5000 - 10000&#39; when unit_price &#60; 15000 then &#39;10000 - 15000&#39; when unit_price &#60;20000 then &#39;15000 - 20000&#39; when unit_price &#60; 50000 then &#39;20000 - 50000&#39; else &#39;&#62; 50000&#39; end						</SQL>
 68 
				</Table>
75 
					</NameExpression>
 - 
 
76 
					<OrdinalExpression>
 - 
 
77 
						<SQL dialect="generic">
 - 
 
78 
							case when unit_price&#60;2000 then 0 when unit_price &#60; 5000 then 2000 when unit_price &#60; 10000 then 5000 when unit_price &#60; 15000 then 10000 when unit_price &#60;20000 then 15000 when unit_price &#60; 50000 then 20000 else 50000 end						</SQL>
 69 
				<Level name="Price Range" column="name" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular">
79 
					</OrdinalExpression>
 - 
 
80 
				</Level>
 70 
				</Level>
81 
			</Hierarchy>
 71 
			</Hierarchy>
82 
		</Dimension>
 72 
		</Dimension>
83 
		<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment">
 73 
		<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment">
84 
			<Hierarchy name="Payment" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
 74 
			<Hierarchy name="Payment" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
Line 140... Line 130...
140 
				</Level>
 130 
				</Level>
141 
			</Hierarchy>
 131 
			</Hierarchy>
142 
		</Dimension>
 132 
		</Dimension>
143 
		<Dimension type="StandardDimension" name="Days To Purchase">
 133 
		<Dimension type="StandardDimension" name="Days To Purchase">
144 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All">
 134 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All">
145 
				<Level name="Days To Purchase" table="sales" column="first_source_start_date_id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 - 
 
146 
					<KeyExpression>
 - 
 
147 
						<SQL dialect="generic">
 - 
 
148 
							case when session_start_date_id-first_source_start_date_id&#62;30 then &#39;&#62; month&#39; when session_start_date_id-first_source_start_date_id&#62;15 then &#39;&#62; 15 days&#39; when session_start_date_id-first_source_start_date_id&#62;7 then &#39;&#62; 7 days&#39; when session_start_date_id-first_source_start_date_id&#62;2 then &#39;&#62; 2 days&#39; when session_start_date_id-first_source_start_date_id&#62;1 then &#39;&#62; 1 day&#39; else &#39;same day&#39; end						</SQL>
 135 
				<Level name="Days To Purchase" table="sales" column="days_to_purchase" ordinalColumn="days_to_purchase" type="Numeric" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
149 
					</KeyExpression>
 - 
 
150 
					<NameExpression>
 136 
					<NameExpression>
151 
						<SQL dialect="generic">
 137 
						<SQL dialect="generic">
152 
							case when session_start_date_id-first_source_start_date_id&#62;30 then &#39;&#62; month&#39; when session_start_date_id-first_source_start_date_id&#62;15 then &#39;&#62; 15 days&#39; when session_start_date_id-first_source_start_date_id&#62;7 then &#39;&#62; 7 days&#39; when session_start_date_id-first_source_start_date_id&#62;2 then &#39;&#62; 2 days&#39; when session_start_date_id-first_source_start_date_id&#62;1 then &#39;&#62; 1 day&#39; else &#39;same day&#39; end						</SQL>
 138 
							case when days_to_purchase&#62;30 then &#39;&#62; month&#39; when days_to_purchase&#62;15 then &#39;&#62; 15 days&#39; when days_to_purchase&#62;7 then &#39;&#62; 7 days&#39; when days_to_purchase&#62;2 then &#39;&#62; 2 days&#39; when days_to_purchase&#62;1 then &#39;&#62; 1 day&#39; else &#39;same day&#39; end						</SQL>
153 
					</NameExpression>
 139 
					</NameExpression>
154 
					<OrdinalExpression>
 - 
 
155 
						<SQL dialect="generic">
 - 
 
156 
							session_start_date_id-first_source_start_date_id						</SQL>
 - 
 
157 
					</OrdinalExpression>
 - 
 
158 
				</Level>
 140 
				</Level>
159 
			</Hierarchy>
 141 
			</Hierarchy>
160 
		</Dimension>
 142 
		</Dimension>
161 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 143 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
162 
		</Measure>
 144 
		</Measure>