Subversion Repositories SmartDukaan

Rev

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

Rev 3484 Rev 3542
Line 4... Line 4...
4 
		</Table>
 4 
		</Table>
5 
		<Dimension type="TimeDimension" foreignKey="date_id" name="OrderDate">
 5 
		<Dimension type="TimeDimension" foreignKey="date_id" name="OrderDate">
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 approxRowCount="2" 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="false" levelType="TimeQuarters" hideMemberIf="Never">
 11 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
12 
				</Level>
 12 
				</Level>
13 
				<Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
 13 
				<Level approxRowCount="8" 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="false" levelType="TimeDays" hideMemberIf="Never">
 15 
				<Level approxRowCount="20" 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">
21 
				<Table name="pincodesB">
 21 
				<Table name="pincodesB">
22 
				</Table>
 22 
				</Table>
23 
				<Level name="State" column="state" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 23 
				<Level approxRowCount="25" name="State" column="state" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
24 
				</Level>
 24 
				</Level>
25 
				<Level name="City" column="city" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 25 
				<Level approxRowCount="10" name="City" column="city" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
26 
				</Level>
 26 
				</Level>
27 
				<Level name="Pincode" column="pincode" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 27 
				<Level name="Pincode" column="pincode" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
28 
				</Level>
 28 
				</Level>
29 
			</Hierarchy>
 29 
			</Hierarchy>
30 
		</Dimension>
 30 
		</Dimension>
Line 62... Line 62...
62 
				</Level>
 62 
				</Level>
63 
			</Hierarchy>
 63 
			</Hierarchy>
64 
		</Dimension>
 64 
		</Dimension>
65 
		<Dimension type="StandardDimension" foreignKey="price_range" name="Price">
 65 
		<Dimension type="StandardDimension" foreignKey="price_range" name="Price">
66 
			<Hierarchy name="Price Range" hasAll="true" allMemberName="All" primaryKey="id">
 66 
			<Hierarchy name="Price Range" hasAll="true" allMemberName="All" primaryKey="id">
67 
				<Table name="pricerange" schema="" alias="">
 67 
				<Table name="pricerange">
68 
				</Table>
 68 
				</Table>
69 
				<Level name="Price Range" column="name" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular">
 69 
				<Level name="Price Range" column="name" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
70 
				</Level>
 70 
				</Level>
71 
			</Hierarchy>
 71 
			</Hierarchy>
72 
		</Dimension>
 72 
		</Dimension>
73 
		<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment">
 73 
		<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment">
74 
			<Hierarchy name="Payment" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
 74 
			<Hierarchy name="Payment" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
75 
				<Table name="paymentmethod">
 75 
				<Table name="paymentmethod">
76 
				</Table>
 76 
				</Table>
77 
				<Level name="Gateway" column="gateway" nameColumn="gateway" ordinalColumn="gateway" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 77 
				<Level approxRowCount="6" name="Gateway" column="gateway" nameColumn="gateway" ordinalColumn="gateway" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
78 
				</Level>
 78 
				</Level>
79 
				<Level name="Payment Method" column="paymentmethodname" nameColumn="paymentmethodname" ordinalColumn="paymentmethodname" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 79 
				<Level name="Payment Method" column="paymentmethodname" nameColumn="paymentmethodname" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
80 
				</Level>
 80 
				</Level>
81 
			</Hierarchy>
 81 
			</Hierarchy>
82 
		</Dimension>
 82 
		</Dimension>
83 
		<Dimension type="StandardDimension" name="Order Hour">
 83 
		<Dimension type="StandardDimension" foreignKey="order_hour" name="Order Hour">
84 
			<Hierarchy name="Order Hour" hasAll="true" allMemberName="All">
 84 
			<Hierarchy name="Order Hour" hasAll="true" allMemberName="All" primaryKey="hour_id">
85 
				<Level name="Order Hour Range" table="sales" column="order_hour" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 - 
 
86 
					<KeyExpression>
 - 
 
87 
						<SQL dialect="generic">
 - 
 
88 
							case when order_hour&#60;6 then 0 when order_hour&#60;12 then 6 when order_hour&#60;15 then 12 when order_hour&#60;18 then 15 else 18 end						</SQL>
 - 
 
89 
					</KeyExpression>
 - 
 
90 
					<NameExpression>
 - 
 
91 
						<SQL dialect="generic">
 85 
				<Table name="orderhour">
92 
							case when order_hour&#60;6 then &#34;0am - 6am&#34; when order_hour&#60;12 then &#34;6am - 12pm&#34; when order_hour&#60;15 then &#34;12pm - 15pm&#34; when order_hour&#60;18 then &#34;15pm - 18pm&#34; else &#34;18pm - 24pm&#34; end						</SQL>
 - 
 
93 
					</NameExpression>
 86 
				</Table>
94 
					<OrdinalExpression>
 - 
 
95 
						<SQL dialect="generic">
 - 
 
96 
							case when order_hour&#60;6 then 0 when order_hour&#60;12 then 6 when order_hour&#60;15 then 12 when order_hour&#60;18 then 15 else 18 end						</SQL>
 87 
				<Level name="Hour Range" column="hour_range" ordinalColumn="hour_id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
97 
					</OrdinalExpression>
 - 
 
98 
				</Level>
 88 
				</Level>
99 
				<Level name="Order Hour" table="sales" column="order_hour" ordinalColumn="order_hour" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 89 
				<Level name="Hour" column="hour_id" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
100 
				</Level>
 90 
				</Level>
101 
			</Hierarchy>
 91 
			</Hierarchy>
102 
		</Dimension>
 92 
		</Dimension>
103 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
 93 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
104 
			<Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id">
 94 
			<Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id">
105 
				<Table name="user">
 95 
				<Table name="user">
106 
				</Table>
 96 
				</Table>
107 
				<Level name="Source" column="source_type" nameColumn="source_type" ordinalColumn="source_type" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 97 
				<Level name="Source" column="source_type" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
108 
				</Level>
 98 
				</Level>
109 
				<Level name="Site" column="source_url" nameColumn="source_url" ordinalColumn="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 99 
				<Level name="Site" column="source_url" nameColumn="source_url" ordinalColumn="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
110 
				</Level>
 100 
				</Level>
111 
			</Hierarchy>
 101 
			</Hierarchy>
112 
		</Dimension>
 102 
		</Dimension>
Line 116... Line 106...
116 
				</Level>
 106 
				</Level>
117 
			</Hierarchy>
 107 
			</Hierarchy>
118 
		</Dimension>
 108 
		</Dimension>
119 
		<Dimension type="StandardDimension" name="Session Source">
 109 
		<Dimension type="StandardDimension" name="Session Source">
120 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
 110 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
121 
				<Level name="Source" table="sales" column="session_source_type" nameColumn="session_source_type" ordinalColumn="session_source_type" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 111 
				<Level name="Source" table="sales" column="session_source_type" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
122 
				</Level>
 112 
				</Level>
123 
				<Level name="Site" table="sales" column="session_source_url" nameColumn="session_source_url" ordinalColumn="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 113 
				<Level name="Site" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
124 
				</Level>
 114 
				</Level>
125 
			</Hierarchy>
 115 
			</Hierarchy>
126 
		</Dimension>
 116 
		</Dimension>
127 
		<Dimension type="StandardDimension" name="Affiliate">
 117 
		<Dimension type="StandardDimension" name="Affiliate">
128 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
 118 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
Line 130... Line 120...
130 
				</Level>
 120 
				</Level>
131 
			</Hierarchy>
 121 
			</Hierarchy>
132 
		</Dimension>
 122 
		</Dimension>
133 
		<Dimension type="StandardDimension" foreignKey="days_to_purchase" name="Days To Purchase">
 123 
		<Dimension type="StandardDimension" foreignKey="days_to_purchase" name="Days To Purchase">
134 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All" primaryKey="id">
 124 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All" primaryKey="id">
135 
				<Table name="daystopurchaserange" schema="" alias="">
 125 
				<Table name="daystopurchaserange">
136 
				</Table>
 126 
				</Table>
137 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 127 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
138 
				</Level>
 128 
				</Level>
139 
			</Hierarchy>
 129 
			</Hierarchy>
140 
		</Dimension>
 130 
		</Dimension>