Subversion Repositories SmartDukaan

Rev

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

Rev 3481 Rev 3484
Line 128... Line 128...
128 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
 128 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
129 
				<Level name="Affiliate" table="sales" column="aff_name" nameColumn="aff_name" ordinalColumn="aff_name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 129 
				<Level name="Affiliate" table="sales" column="aff_name" nameColumn="aff_name" ordinalColumn="aff_name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
130 
				</Level>
 130 
				</Level>
131 
			</Hierarchy>
 131 
			</Hierarchy>
132 
		</Dimension>
 132 
		</Dimension>
133 
		<Dimension type="StandardDimension" name="Days To Purchase">
 133 
		<Dimension type="StandardDimension" foreignKey="days_to_purchase" name="Days To Purchase">
134 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All">
 134 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All" primaryKey="id">
135 
				<Level name="Days To Purchase" table="sales" column="days_to_purchase" ordinalColumn="days_to_purchase" type="Numeric" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 135 
				<Table name="daystopurchaserange" schema="" alias="">
136 
					<NameExpression>
 136 
				</Table>
137 
						<SQL dialect="generic">
 - 
 
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>
 137 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
139 
					</NameExpression>
 - 
 
140 
				</Level>
 138 
				</Level>
141 
			</Hierarchy>
 139 
			</Hierarchy>
142 
		</Dimension>
 140 
		</Dimension>
143 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 141 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
144 
		</Measure>
 142 
		</Measure>