Subversion Repositories SmartDukaan

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2704 vikas 1 
<Schema name="CartSchema">
2 
	<Cube name="CartCube" cache="true" enabled="true">
3 
		<Table name="cart">
4 
		</Table>
5 
		<Dimension type="TimeDimension" foreignKey="created_on" name="CratedDate">
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>
11 
				<Level name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
12 
				</Level>
13 
				<Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
14 
				</Level>
15 
				<Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
16 
				</Level>
17 
			</Hierarchy>
18 
		</Dimension>
19 
		<Dimension type="StandardDimension" foreignKey="pin" 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="item_id" name="Product">
32 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="id">
33 
				<Table name="item">
34 
				</Table>
35 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
36 
				</Level>
37 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
38 
				</Level>
39 
				<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
40 
				</Level>
41 
			</Hierarchy>
42 
		</Dimension>
43 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
44 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
45 
				<Table name="item">
46 
				</Table>
47 
				<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
48 
				</Level>
49 
				<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
50 
				</Level>
51 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
52 
				</Level>
53 
			</Hierarchy>
54 
		</Dimension>
55 
		<Dimension type="StandardDimension" name="Price">
56 
			<Hierarchy name="Price" hasAll="true" allMemberName="All">
57 
				<Level name="Price" table="sales" column="unit_price" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
58 
					<KeyExpression>
59 
						<SQL dialect="generic">
60 
							case when unit_price&#60;2000 then 0 when unit_price &#60; 5000 then 2000 when unit_price &#60; 10000 then 5000 when unit_price &#60; 15000 then 10000 when unit_price &#60;20000 then 15000 when unit_price &#60; 50000 then 20000 else 50000 end						</SQL>
61 
					</KeyExpression>
62 
					<NameExpression>
63 
						<SQL dialect="generic">
64 
							case when unit_price&#60;2000 then &#39;0 - 2000&#39; when unit_price &#60; 5000 then &#39;2000 - 5000&#39; when unit_price &#60; 10000 then &#39;5000 - 10000&#39; when unit_price &#60; 15000 then &#39;10000 - 15000&#39; when unit_price &#60;20000 then &#39;15000 - 20000&#39; when unit_price &#60; 50000 then &#39;20000 - 50000&#39; else &#39;&#62; 50000&#39; end						</SQL>
65 
					</NameExpression>
66 
					<OrdinalExpression>
67 
						<SQL dialect="generic">
68 
							case when unit_price&#60;2000 then 0 when unit_price &#60; 5000 then 2000 when unit_price &#60; 10000 then 5000 when unit_price &#60; 15000 then 10000 when unit_price &#60;20000 then 15000 when unit_price &#60; 50000 then 20000 else 50000 end						</SQL>
69 
					</OrdinalExpression>
70 
				</Level>
71 
			</Hierarchy>
72 
		</Dimension>
73 
		<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
74 
		</Measure>
75 
		<Measure name="Average Selling Price" column="actual_price" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
76 
		</Measure>
77 
		<Measure name="Total Sales" column="actual_price" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
78 
		</Measure>
79 
		<Measure name="Transfer Price" column="discounted_price" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
80 
		</Measure>
81 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[Transfer Price]" dimension="Measures" visible="true">
82 
		</CalculatedMember>
83 
	</Cube>
84 
</Schema>