Subversion Repositories SmartDukaan

Rev

Rev 2532 | Rev 2554 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
2401 ankur.sing 1 
<Schema name="SalesSchema">
2 
	<Cube name="SalesCube" cache="true" enabled="true">
3 
		<Table name="salesNew">
4 
		</Table>
5 
		<Dimension type="TimeDimension" foreignKey="date_id" name="OrderDate">
6 
			<Hierarchy name="OrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
7 
				<Table name="datedim">
8 
				</Table>
9 
				<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
10 
				</Level>
2553 vikas 11 
				<Level name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
2401 ankur.sing 12 
				</Level>
2553 vikas 13 
				<Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
2401 ankur.sing 14 
				</Level>
2553 vikas 15 
				<Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
2401 ankur.sing 16 
				</Level>
17 
			</Hierarchy>
18 
		</Dimension>
19 
		<Dimension type="StandardDimension" foreignKey="pincode" name="Geography">
20 
			<Hierarchy name="Territory" hasAll="true" allMemberName="All" primaryKey="pincode">
21 
				<Table name="pincodesB">
22 
				</Table>
23 
				<Level name="State" column="state" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
24 
				</Level>
25 
				<Level name="City" column="city" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
26 
				</Level>
27 
				<Level name="Pincode" column="pincode" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
28 
				</Level>
29 
			</Hierarchy>
30 
		</Dimension>
31 
		<Dimension type="StandardDimension" foreignKey="status" name="OrderStatus">
32 
			<Hierarchy name="StatusDim" hasAll="true" allMemberName="All" primaryKey="status">
33 
				<Table name="orderstatus">
34 
				</Table>
35 
				<Level name="IsValid" column="isvalid" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
36 
				</Level>
37 
				<Level name="Status" column="description" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
38 
				</Level>
39 
			</Hierarchy>
40 
		</Dimension>
41 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Product">
42 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="id">
43 
				<Table name="item">
44 
				</Table>
45 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
46 
				</Level>
47 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
48 
				</Level>
2553 vikas 49 
				<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
2401 ankur.sing 50 
				</Level>
51 
			</Hierarchy>
52 
		</Dimension>
2532 vikas 53 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
54 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
2553 vikas 55 
				<Table name="item">
2532 vikas 56 
				</Table>
57 
				<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
58 
				</Level>
59 
				<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
60 
				</Level>
2553 vikas 61 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
62 
				</Level>
2532 vikas 63 
			</Hierarchy>
64 
		</Dimension>
2553 vikas 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>
81 
			</Hierarchy>
82 
		</Dimension>
2401 ankur.sing 83 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
84 
		</Measure>
2553 vikas 85 
		<Measure name="Average Selling Price" column="unit_price" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
2517 vikas 86 
		</Measure>
2553 vikas 87 
		<CalculatedMember name="TotalSales" formatString="##,##,##,###.00" formula="[Measures].[Quantity] * [Measures].[Average Selling Price]" dimension="Measures" visible="true">
88 
		</CalculatedMember>
2401 ankur.sing 89 
	</Cube>
90 
</Schema>