Subversion Repositories SmartDukaan

Rev

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

Rev 3706 Rev 3750
Line 116... Line 116...
116 
			<Hierarchy name="Delay Cause" hasAll="true" allMemberName="All">
 116 
			<Hierarchy name="Delay Cause" hasAll="true" allMemberName="All">
117 
				<Level name="Delay Cause" table="orderfulfillment" column="delay_reason" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 117 
				<Level name="Delay Cause" table="orderfulfillment" column="delay_reason" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
118 
				</Level>
 118 
				</Level>
119 
			</Hierarchy>
 119 
			</Hierarchy>
120 
		</Dimension>
 120 
		</Dimension>
- 
 
 121 
		<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment Mode">
- 
 
 122 
			<Hierarchy name="Payment Mode" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
- 
 
 123 
				<Table name="paymentmethod" alias="">
- 
 
 124 
				</Table>
- 
 
 125 
				<Level name="Payment Mode" column="gateway" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 126 
					<KeyExpression>
- 
 
 127 
						<SQL dialect="generic">
- 
 
 128 
							case when gateway in (&#39;ebs&#39;, &#39;hdfc&#39;, &#39;cheque&#39;)  then &#39;prepaid&#39; else gateway end						</SQL>
- 
 
 129 
					</KeyExpression>
- 
 
 130 
					<NameExpression>
- 
 
 131 
						<SQL dialect="generic">
- 
 
 132 
							case when gateway in (&#39;ebs&#39;, &#39;hdfc&#39;, &#39;cheque&#39;)  then &#39;prepaid&#39; else gateway end						</SQL>
- 
 
 133 
					</NameExpression>
- 
 
 134 
				</Level>
- 
 
 135 
			</Hierarchy>
- 
 
 136 
		</Dimension>
121 
		<Measure name="Quantity" column="date_id" datatype="Integer" formatString="##,###" aggregator="count" visible="true">
 137 
		<Measure name="Quantity" column="date_id" datatype="Integer" formatString="##,###" aggregator="count" visible="true">
122 
		</Measure>
 138 
		</Measure>
123 
	</Cube>
 139 
	</Cube>
124 
</Schema>
 140 
</Schema>