Subversion Repositories SmartDukaan

Rev

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

Rev 2532 Rev 2553
Line 6... Line 6...
6 
			<Hierarchy name="OrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
 6 
			<Hierarchy name="OrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
7 
				<Table name="datedim">
 7 
				<Table name="datedim">
8 
				</Table>
 8 
				</Table>
9 
				<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
 9 
				<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
10 
				</Level>
 10 
				</Level>
11 
				<Level name="Quarter" column="quarter" type="String" uniqueMembers="true" levelType="TimeQuarters" hideMemberIf="Never">
 11 
				<Level name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
12 
				</Level>
 12 
				</Level>
13 
				<Level name="Month" column="monthname" type="String" uniqueMembers="true" levelType="TimeMonths" hideMemberIf="Never">
 13 
				<Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
14 
				</Level>
 14 
				</Level>
15 
				<Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="true" levelType="TimeDays" hideMemberIf="Never">
 15 
				<Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
16 
				</Level>
 16 
				</Level>
17 
			</Hierarchy>
 17 
			</Hierarchy>
18 
		</Dimension>
 18 
		</Dimension>
19 
		<Dimension type="StandardDimension" foreignKey="pincode" name="Geography">
 19 
		<Dimension type="StandardDimension" foreignKey="pincode" name="Geography">
20 
			<Hierarchy name="Territory" hasAll="true" allMemberName="All" primaryKey="pincode">
 20 
			<Hierarchy name="Territory" hasAll="true" allMemberName="All" primaryKey="pincode">
Line 40... Line 40...
40 
		</Dimension>
 40 
		</Dimension>
41 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Product">
 41 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Product">
42 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="id">
 42 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="id">
43 
				<Table name="item">
 43 
				<Table name="item">
44 
				</Table>
 44 
				</Table>
45 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 - 
 
46 
				</Level>
 - 
 
47 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 45 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
48 
				</Level>
 46 
				</Level>
49 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 47 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
50 
				</Level>
 48 
				</Level>
51 
				<Level name="Color" column="color" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 49 
				<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
52 
				</Level>
 50 
				</Level>
53 
			</Hierarchy>
 51 
			</Hierarchy>
54 
		</Dimension>
 52 
		</Dimension>
55 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
 53 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
56 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
 54 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
57 
				<Table name="item" schema="" alias="">
 55 
				<Table name="item">
58 
				</Table>
 56 
				</Table>
59 
				<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 57 
				<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
60 
				</Level>
 58 
				</Level>
61 
				<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 59 
				<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
62 
				</Level>
 60 
				</Level>
- 
 
 61 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 62 
				</Level>
- 
 
 63 
			</Hierarchy>
- 
 
 64 
		</Dimension>
- 
 
 65 
		<Dimension type="StandardDimension" name="Price">
- 
 
 66 
			<Hierarchy name="Price" hasAll="true" allMemberName="All">
- 
 
 67 
				<Level name="Price" table="salesNew" column="unit_price" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 68 
					<KeyExpression>
- 
 
 69 
						<SQL dialect="generic">
- 
 
 70 
							cast(unit_price/5000 as unsigned)						</SQL>
- 
 
 71 
					</KeyExpression>
- 
 
 72 
					<NameExpression>
- 
 
 73 
						<SQL dialect="generic">
- 
 
 74 
							concat(cast(cast(unit_price/5000 as unsigned)*5000 as char), &#39; - &#39;, cast(cast(unit_price/5000 + 1 as unsigned)*5000 as char))						</SQL>
- 
 
 75 
					</NameExpression>
- 
 
 76 
					<OrdinalExpression>
- 
 
 77 
						<SQL dialect="generic">
- 
 
 78 
							cast(unit_price/2000 as unsigned)						</SQL>
- 
 
 79 
					</OrdinalExpression>
- 
 
 80 
				</Level>
63 
			</Hierarchy>
 81 
			</Hierarchy>
64 
		</Dimension>
 82 
		</Dimension>
65 
		<Measure name="TotalSales" column="unit_price" datatype="Numeric" formatString="##,###.00" aggregator="sum" visible="true">
 - 
 
66 
		</Measure>
 - 
 
67 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 83 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
68 
		</Measure>
 84 
		</Measure>
69 
		<Measure name="Average Selling price" column="unit_price" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
 85 
		<Measure name="Average Selling Price" column="unit_price" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
70 
		</Measure>
 86 
		</Measure>
- 
 
 87 
		<CalculatedMember name="TotalSales" formatString="##,##,##,###.00" formula="[Measures].[Quantity] * [Measures].[Average Selling Price]" dimension="Measures" visible="true">
- 
 
 88 
		</CalculatedMember>
71 
	</Cube>
 89 
	</Cube>
72 
</Schema>
 90 
</Schema>