Subversion Repositories SmartDukaan

Rev

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

Rev 5710 Rev 5799
Line 154... Line 154...
154 
				</Table>
 154 
				</Table>
155 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 155 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
156 
				</Level>
 156 
				</Level>
157 
			</Hierarchy>
 157 
			</Hierarchy>
158 
		</Dimension>
 158 
		</Dimension>
- 
 
 159 
		<Dimension type="StandardDimension" foreignKey="pickupStoreId" name="PickupType">
- 
 
 160 
			<Hierarchy name="PickupType" hasAll="true" allMemberName="All">
- 
 
 161 
				<Level name="PickupType" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 162 
					<KeyExpression>
- 
 
 163 
						<SQL dialect="generic">
- 
 
 164 
							case when pickupStoreId = 0 then &#39;HomeDelivery&#39;  else &#39;Store Pickup&#39; end						</SQL>
- 
 
 165 
					</KeyExpression>
- 
 
 166 
					<NameExpression>
- 
 
 167 
						<SQL dialect="generic">
- 
 
 168 
							case when pickupStoreId = 0 then &#39;HomeDelivery&#39;  else &#39;Store Pickup&#39; end						</SQL>
- 
 
 169 
					</NameExpression>
- 
 
 170 
				</Level>
- 
 
 171 
				<Level name="StoreId" table="sales" column="pickupStoreId" type="Numeric" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 172 
				</Level>
- 
 
 173 
			</Hierarchy>
- 
 
 174 
		</Dimension>
159 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
 175 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
160 
		</Measure>
 176 
		</Measure>
161 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
 177 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
162 
		</Measure>
 178 
		</Measure>
163 
		<Measure name="Transfer Price" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
 179 
		<Measure name="Transfer Price" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
Line 326... Line 342...
326 
				</Table>
 342 
				</Table>
327 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 343 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
328 
				</Level>
 344 
				</Level>
329 
			</Hierarchy>
 345 
			</Hierarchy>
330 
		</Dimension>
 346 
		</Dimension>
- 
 
 347 
		<Dimension type="StandardDimension" foreignKey="pickupStoreId" name="PickupType">
- 
 
 348 
			<Hierarchy name="PickupType" hasAll="true" allMemberName="All">
- 
 
 349 
				<Level name="PickupType" table="sales" column="pickupStoreId" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 350 
					<KeyExpression>
- 
 
 351 
						<SQL dialect="generic">
- 
 
 352 
							case when pickupStoreId = 0 then &#39;HomeDelivery&#39;  else &#39;Store Pickup&#39; end						</SQL>
- 
 
 353 
					</KeyExpression>
- 
 
 354 
					<NameExpression>
- 
 
 355 
						<SQL dialect="generic">
- 
 
 356 
							case when pickupStoreId = 0 then &#39;HomeDelivery&#39;  else &#39;Store Pickup&#39; end						</SQL>
- 
 
 357 
					</NameExpression>
- 
 
 358 
				</Level>
- 
 
 359 
				<Level name="StoreId" table="sales" column="pickupStoreId" type="Numeric" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 360 
				</Level>
- 
 
 361 
			</Hierarchy>
- 
 
 362 
		</Dimension>
331 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
 363 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="###,###" aggregator="sum" visible="true">
332 
		</Measure>
 364 
		</Measure>
333 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
 365 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="###,###,###" aggregator="sum" visible="true">
334 
		</Measure>
 366 
		</Measure>
335 
		<Measure name="Transfer Price" datatype="Numeric" formatString="##,##,##,##,###" aggregator="sum" visible="true">
 367 
		<Measure name="Transfer Price" datatype="Numeric" formatString="##,##,##,##,###" aggregator="sum" visible="true">