Subversion Repositories SmartDukaan

Rev

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

Rev 4166 Rev 5157
Line 30... Line 30...
30 
		</Dimension>
 30 
		</Dimension>
31 
		<Dimension type="StandardDimension" foreignKey="status" name="OrderStatus">
 31 
		<Dimension type="StandardDimension" foreignKey="status" name="OrderStatus">
32 
			<Hierarchy name="StatusDim" hasAll="true" allMemberName="All" primaryKey="status">
 32 
			<Hierarchy name="StatusDim" hasAll="true" allMemberName="All" primaryKey="status">
33 
				<Table name="orderstatus">
 33 
				<Table name="orderstatus">
34 
				</Table>
 34 
				</Table>
- 
 
 35 
				<Level name="StatusGroup" column="statusGroup" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 36 
				</Level>
- 
 
 37 
				<Level name="StatusSubGroup" column="statusSubGroup" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 38 
				</Level>
35 
				<Level name="Status" column="description" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 39 
				<Level name="Status" column="statusName" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
36 
				</Level>
 40 
				</Level>
37 
			</Hierarchy>
 41 
			</Hierarchy>
38 
		</Dimension>
 42 
		</Dimension>
39 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Product">
 43 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Product">
40 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="id">
 44 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="id">
Line 86... Line 90...
86 
							case when actual_delivery_days &#60;= 5 then convert(actual_delivery_days, char) when actual_delivery_days &#62; 5 then &#39;more than 5 days&#39; else &#39;-&#39; end						</SQL>
 90 
							case when actual_delivery_days &#60;= 5 then convert(actual_delivery_days, char) when actual_delivery_days &#62; 5 then &#39;more than 5 days&#39; else &#39;-&#39; end						</SQL>
87 
					</NameExpression>
 91 
					</NameExpression>
88 
				</Level>
 92 
				</Level>
89 
			</Hierarchy>
 93 
			</Hierarchy>
90 
		</Dimension>
 94 
		</Dimension>
- 
 
 95 
		<Dimension type="StandardDimension" name="Connected Locally">
- 
 
 96 
			<Hierarchy name="Connected Locally" hasAll="true" allMemberName="All">
- 
 
 97 
				<Level name="Connected Locally" table="orderfulfillment" column="connected_locally" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 98 
					<KeyExpression>
- 
 
 99 
						<SQL dialect="generic">
- 
 
 100 
							case when connected_locally &#60;= 5 then connected_locally when connected_locally &#62; 5 then 6 else 7 end						</SQL>
- 
 
 101 
					</KeyExpression>
- 
 
 102 
					<NameExpression>
- 
 
 103 
						<SQL dialect="generic">
- 
 
 104 
							case when connected_locally &#60;= 5 then convert(connected_locally, char) when connected_locally &#62; 5 then &#39;more than 5 days&#39; else &#39;-&#39; end						</SQL>
- 
 
 105 
					</NameExpression>
- 
 
 106 
				</Level>
- 
 
 107 
			</Hierarchy>
- 
 
 108 
		</Dimension>
- 
 
 109 
		<Dimension type="StandardDimension" name="Reached Destination City">
- 
 
 110 
			<Hierarchy name="Reached Destination City" hasAll="true" allMemberName="All">
- 
 
 111 
				<Level name="Reached Destination City" table="orderfulfillment" column="reached_destination_city" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 112 
					<KeyExpression>
- 
 
 113 
						<SQL dialect="generic">
- 
 
 114 
							case when reached_destination_city &#60;= 5 then reached_destination_city when reached_destination_city &#62; 5 then 6 else 7 end						</SQL>
- 
 
 115 
					</KeyExpression>
- 
 
 116 
					<NameExpression>
- 
 
 117 
						<SQL dialect="generic">
- 
 
 118 
							case when reached_destination_city &#60;= 5 then convert(reached_destination_city, char) when reached_destination_city &#62; 5 then &#39;more than 5 days&#39; else &#39;-&#39; end						</SQL>
- 
 
 119 
					</NameExpression>
- 
 
 120 
				</Level>
- 
 
 121 
			</Hierarchy>
- 
 
 122 
		</Dimension>
- 
 
 123 
		<Dimension type="StandardDimension" name="First Delivery Attempt">
- 
 
 124 
			<Hierarchy name="First Delivery Attempt" hasAll="true" allMemberName="All">
- 
 
 125 
				<Level name="First Delivery Attempt" table="orderfulfillment" column="first_delivery_attempt" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 126 
					<KeyExpression>
- 
 
 127 
						<SQL dialect="generic">
- 
 
 128 
							case when first_delivery_attempt &#60;= 5 then first_delivery_attempt when first_delivery_attempt &#62; 5 then 6 else 7 end						</SQL>
- 
 
 129 
					</KeyExpression>
- 
 
 130 
					<NameExpression>
- 
 
 131 
						<SQL dialect="generic">
- 
 
 132 
							case when first_delivery_attempt &#60;= 5 then convert(first_delivery_attempt, char) when first_delivery_attempt &#62; 5 then &#39;more than 5 days&#39; else &#39;-&#39; end						</SQL>
- 
 
 133 
					</NameExpression>
- 
 
 134 
				</Level>
- 
 
 135 
			</Hierarchy>
- 
 
 136 
		</Dimension>
91 
		<Dimension type="StandardDimension" name="Delivery Difference">
 137 
		<Dimension type="StandardDimension" name="Delivery Difference">
92 
			<Hierarchy name="Delivery Difference" hasAll="true" allMemberName="All">
 138 
			<Hierarchy name="Delivery Difference" hasAll="true" allMemberName="All">
93 
				<Level name="Delivery Difference" table="orderfulfillment" column="actual_estimate_diff" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 139 
				<Level name="Delivery Difference" table="orderfulfillment" column="actual_estimate_diff" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
94 
					<KeyExpression>
 140 
					<KeyExpression>
95 
						<SQL dialect="generic">
 141 
						<SQL dialect="generic">
Line 105... Line 151...
105 
		<Dimension type="StandardDimension" name="Logistics Provider">
 151 
		<Dimension type="StandardDimension" name="Logistics Provider">
106 
			<Hierarchy name="Logistics Provider" hasAll="true" allMemberName="All">
 152 
			<Hierarchy name="Logistics Provider" hasAll="true" allMemberName="All">
107 
				<Level name="Logistics Provider" table="orderfulfillment" column="logistics_provider_id" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 153 
				<Level name="Logistics Provider" table="orderfulfillment" column="logistics_provider_id" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
108 
					<NameExpression>
 154 
					<NameExpression>
109 
						<SQL dialect="generic">
 155 
						<SQL dialect="generic">
110 
							case when logistics_provider_id=1 then &#39;Blue Dart&#39; when logistics_provider_id=2 then &#39;AFL&#39;  else &#39;-&#39; end						</SQL>
 156 
							case when logistics_provider_id=1 then &#39;Blue Dart&#39; when logistics_provider_id=2 then &#39;Aramex&#39;  else &#39;N/A&#39; end						</SQL>
111 
					</NameExpression>
 157 
					</NameExpression>
112 
				</Level>
 158 
				</Level>
113 
			</Hierarchy>
 159 
			</Hierarchy>
114 
		</Dimension>
 160 
		</Dimension>
115 
		<Dimension type="StandardDimension" name="Delay Cause">
 161 
		<Dimension type="StandardDimension" name="Delay Cause">