Subversion Repositories SmartDukaan

Rev

Rev 6554 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6554 Rev 7203
Line 138... Line 138...
138 
				</Table>
 138 
				</Table>
139 
				<Level name="Repeat type" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 139 
				<Level name="Repeat type" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
140 
				</Level>
 140 
				</Level>
141 
			</Hierarchy>
 141 
			</Hierarchy>
142 
		</Dimension>
 142 
		</Dimension>
- 
 
 143 
		<Dimension type="StandardDimension" name="isRepeat">
- 
 
 144 
			<Hierarchy name="isRepeat" hasAll="true" allMemberName="All">
- 
 
 145 
				<Level name="isRepeat" table="commonorders" column="isRepeatUser" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 146 
					<KeyExpression>
- 
 
 147 
						<SQL dialect="generic">
- 
 
 148 
							case when isRepeatUser = 1 then &#39;Repeat&#39; else &#39;One-Time&#39; end						</SQL>
- 
 
 149 
					</KeyExpression>
- 
 
 150 
					<NameExpression>
- 
 
 151 
						<SQL dialect="generic">
- 
 
 152 
							case when isRepeatUser = 1 then &#39;Repeat&#39; else &#39;One-Time&#39; end						</SQL>
- 
 
 153 
					</NameExpression>
- 
 
 154 
				</Level>
- 
 
 155 
			</Hierarchy>
- 
 
 156 
		</Dimension>
143 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
 157 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
144 
		</Measure>
 158 
		</Measure>
145 
		<Measure name="transactionCount" column="transactionId" datatype="Integer" formatString="###,###.###" aggregator="distinct-count" visible="true">
 159 
		<Measure name="transactionCount" column="transactionId" datatype="Integer" formatString="###,###.###" aggregator="distinct-count" visible="true">
146 
		</Measure>
 160 
		</Measure>
147 
		<Measure name="userCount" column="userId" datatype="Integer" formatString="###,###.###" aggregator="distinct-count" visible="true">
 161 
		<Measure name="userCount" column="userId" datatype="Integer" formatString="###,###.###" aggregator="distinct-count" visible="true">