Subversion Repositories SmartDukaan

Rev

Rev 5896 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5896 Rev 5905
Line 1... Line 1...
1 
<Schema name="RepeatSalesSchema">
 1 
<Schema name="RepeatSalesSchema">
2 
	<Cube name="RepeatSalesCube" cache="true" enabled="true">
 2 
	<Cube name="RepeatSalesCube" cache="true" enabled="true">
3 
		<Table name="repeatSales">
 3 
		<Table name="repeatSales">
4 
		</Table>
 4 
		</Table>
- 
 
 5 
		<Dimension type="TimeDimension" foreignKey="date_id1" name="First Order Date">
- 
 
 6 
			<Hierarchy name="FirstOrderDate" 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 approxRowCount="4" 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 approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
- 
 
 16 
				</Level>
- 
 
 17 
			</Hierarchy>
- 
 
 18 
		</Dimension>
- 
 
 19 
		<Dimension type="StandardDimension" name="Order Count">
- 
 
 20 
			<Hierarchy name="Order Count" hasAll="true" allMemberName="All">
- 
 
 21 
				<Level name="orderCount" table="repeatSales" column="orderCount" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 22 
					<KeyExpression>
- 
 
 23 
						<SQL dialect="generic">
- 
 
 24 
							case when orderCount &#60;= 5 then convert(orderCount, char) when orderCount &#62; 5 then &#39;more than 5 orders&#39; end						</SQL>
- 
 
 25 
					</KeyExpression>
- 
 
 26 
					<NameExpression>
- 
 
 27 
						<SQL dialect="generic">
- 
 
 28 
							case when orderCount &#60;= 5 then convert(orderCount, char) when orderCount &#62; 5 then &#39;more than 5 orders&#39; end						</SQL>
- 
 
 29 
					</NameExpression>
- 
 
 30 
				</Level>
- 
 
 31 
			</Hierarchy>
- 
 
 32 
		</Dimension>
- 
 
 33 
		<Dimension type="TimeDimension" foreignKey="date_id2" name="Second Order Date">
- 
 
 34 
			<Hierarchy name="SecondOrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
- 
 
 35 
				<Table name="datedim" alias="datedim2">
- 
 
 36 
				</Table>
- 
 
 37 
				<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
- 
 
 38 
				</Level>
- 
 
 39 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
- 
 
 40 
				</Level>
- 
 
 41 
				<Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
- 
 
 42 
				</Level>
- 
 
 43 
				<Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
- 
 
 44 
				</Level>
- 
 
 45 
			</Hierarchy>
- 
 
 46 
		</Dimension>
5 
		<Dimension type="StandardDimension" foreignKey="grandTotal" name="Grand Total">
 47 
		<Dimension type="StandardDimension" foreignKey="grandTotal" name="Grand Total">
6 
			<Hierarchy name="GrandTotal" hasAll="true" allMemberName="All" primaryKey="id">
 48 
			<Hierarchy name="GrandTotal" hasAll="true" allMemberName="All" primaryKey="id">
7 
				<Table name="pricerange">
 49 
				<Table name="pricerange">
8 
				</Table>
 50 
				</Table>
9 
				<Level name="Price Range 1" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 51 
				<Level name="Price Range 1" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
10 
				</Level>
 52 
				</Level>
11 
			</Hierarchy>
 53 
			</Hierarchy>
12 
		</Dimension>
 54 
		</Dimension>
- 
 
 55 
		<Dimension type="StandardDimension" foreignKey="averageValue" name="Average Value">
- 
 
 56 
			<Hierarchy name="averageValue" hasAll="true" allMemberName="All" primaryKey="id">
- 
 
 57 
				<Table name="pricerange" alias="pricerange5">
- 
 
 58 
				</Table>
- 
 
 59 
				<Level name="Price Range 1" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 60 
				</Level>
- 
 
 61 
			</Hierarchy>
- 
 
 62 
		</Dimension>
- 
 
 63 
		<Dimension type="StandardDimension" foreignKey="daysToSecondPurchase" name="Days To Second Purchase">
- 
 
 64 
			<Hierarchy name="Days To Second Purchase" hasAll="true" allMemberName="All" primaryKey="id">
- 
 
 65 
				<Table name="daystopurchaserange" alias="SecondPurchaseDaysRange">
- 
 
 66 
				</Table>
- 
 
 67 
				<Level name="Days To Second Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 68 
				</Level>
- 
 
 69 
			</Hierarchy>
- 
 
 70 
		</Dimension>
- 
 
 71 
		<Dimension type="StandardDimension" foreignKey="daysToFirstPurchase" name="Days To First Purchase">
- 
 
 72 
			<Hierarchy name="Days To First Purchase" hasAll="true" allMemberName="All" primaryKey="id">
- 
 
 73 
				<Table name="daystopurchaserange" alias="firstPurchaseDaysRange">
- 
 
 74 
				</Table>
- 
 
 75 
				<Level name="Days To First Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 76 
				</Level>
- 
 
 77 
			</Hierarchy>
- 
 
 78 
		</Dimension>
13 
		<Dimension type="StandardDimension" foreignKey="price_range1" name="First Order Value">
 79 
		<Dimension type="StandardDimension" foreignKey="price_range1" name="First Order Value">
14 
			<Hierarchy name="First Order Value" hasAll="true" allMemberName="All" primaryKey="id">
 80 
			<Hierarchy name="First Order Value" hasAll="true" allMemberName="All" primaryKey="id">
15 
				<Table name="pricerange" alias="firstOrderPrice">
 81 
				<Table name="pricerange" alias="firstOrderPrice">
16 
				</Table>
 82 
				</Table>
17 
				<Level name="Price Range 2" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 83 
				<Level name="Price Range 2" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
Line 92... Line 158...
92 
				</Level>
 158 
				</Level>
93 
				<Level name="Site" table="repeatSales" column="session_source_url2" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 159 
				<Level name="Site" table="repeatSales" column="session_source_url2" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
94 
				</Level>
 160 
				</Level>
95 
			</Hierarchy>
 161 
			</Hierarchy>
96 
		</Dimension>
 162 
		</Dimension>
97 
		<Dimension type="StandardDimension" foreignKey="daysToPurchase" name="Days To First Purchase">
 - 
 
98 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All" primaryKey="id">
 - 
 
99 
				<Table name="daystopurchaserange">
 - 
 
100 
				</Table>
 - 
 
101 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 - 
 
102 
				</Level>
 - 
 
103 
			</Hierarchy>
 - 
 
104 
		</Dimension>
 - 
 
105 
		<Dimension type="StandardDimension" name="First Pay Mode">
 163 
		<Dimension type="StandardDimension" name="First Pay Mode">
106 
			<Hierarchy name="First Pay Mode" hasAll="true" allMemberName="All">
 164 
			<Hierarchy name="First Pay Mode" hasAll="true" allMemberName="All">
107 
				<Level name="paymode1" table="repeatSales" column="paymode1" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 165 
				<Level name="paymode1" table="repeatSales" column="paymode1" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
108 
					<KeyExpression>
 166 
					<KeyExpression>
109 
						<SQL dialect="generic">
 167 
						<SQL dialect="generic">
Line 128... Line 186...
128 
							case when paymode2 = 1 then &#39;COD&#39; when paymode1 = 0 then &#39;Prepaid&#39; end						</SQL>
 186 
							case when paymode2 = 1 then &#39;COD&#39; when paymode1 = 0 then &#39;Prepaid&#39; end						</SQL>
129 
					</NameExpression>
 187 
					</NameExpression>
130 
				</Level>
 188 
				</Level>
131 
			</Hierarchy>
 189 
			</Hierarchy>
132 
		</Dimension>
 190 
		</Dimension>
133 
		<Dimension type="StandardDimension" name="Order Count">
 - 
 
134 
			<Hierarchy name="Order Count" hasAll="true" allMemberName="All">
 - 
 
135 
				<Level name="orderCount" table="repeatSales" column="orderCount" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 - 
 
136 
					<KeyExpression>
 - 
 
137 
						<SQL dialect="generic">
 - 
 
138 
							case when orderCount &#60;= 5 then convert(orderCount, char) when orderCount &#62; 5 then &#39;more than 5 orders&#39; end						</SQL>
 - 
 
139 
					</KeyExpression>
 - 
 
140 
					<NameExpression>
 - 
 
141 
						<SQL dialect="generic">
 - 
 
142 
							case when orderCount &#60;= 5 then convert(orderCount, char) when orderCount &#62; 5 then &#39;more than 5 orders&#39; end						</SQL>
 - 
 
143 
					</NameExpression>
 - 
 
144 
				</Level>
 - 
 
145 
			</Hierarchy>
 - 
 
146 
		</Dimension>
 - 
 
147 
		<Dimension type="TimeDimension" foreignKey="date_id1" name="First Order Date">
 - 
 
148 
			<Hierarchy name="FirstOrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
 - 
 
149 
				<Table name="datedim">
 - 
 
150 
				</Table>
 - 
 
151 
				<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
 - 
 
152 
				</Level>
 - 
 
153 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
 - 
 
154 
				</Level>
 - 
 
155 
				<Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
 - 
 
156 
				</Level>
 - 
 
157 
				<Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
 - 
 
158 
				</Level>
 - 
 
159 
			</Hierarchy>
 - 
 
160 
		</Dimension>
 - 
 
161 
		<Dimension type="TimeDimension" foreignKey="date_id2" name="Second Order Date">
 - 
 
162 
			<Hierarchy name="SecondOrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
 - 
 
163 
				<Table name="datedim" alias="datedim2">
 - 
 
164 
				</Table>
 - 
 
165 
				<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
 - 
 
166 
				</Level>
 - 
 
167 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
 - 
 
168 
				</Level>
 - 
 
169 
				<Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
 - 
 
170 
				</Level>
 - 
 
171 
				<Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
 - 
 
172 
				</Level>
 - 
 
173 
			</Hierarchy>
 - 
 
174 
		</Dimension>
 - 
 
175 
		<Measure name="UserCount" column="customer_id" datatype="Numeric" formatString="###,###,###" aggregator="count" visible="true">
 191 
		<Measure name="UserCount" column="customer_id" datatype="Numeric" formatString="###,###,###" aggregator="count" visible="true">
176 
		</Measure>
 192 
		</Measure>
177 
	</Cube>
 193 
	</Cube>
178 
</Schema>
 194 
</Schema>