Subversion Repositories SmartDukaan

Rev

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

Rev 5161 Rev 5200
Line 14... Line 14...
14 
				</Level>
 14 
				</Level>
15 
				<Level approxRowCount="20" 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">
- 
 
 20 
			<Hierarchy name="Territory" hasAll="true" allMemberName="All" primaryKey="pincode">
- 
 
 21 
				<Table name="pincodesB">
- 
 
 22 
				</Table>
- 
 
 23 
				<Level approxRowCount="25" name="State" column="state" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 24 
				</Level>
- 
 
 25 
				<Level approxRowCount="10" 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="StatusGroup" column="statusGroup" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 38 
				</Level>
- 
 
 39 
				<Level name="StatusSubGroup" column="statusSubGroup" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 40 
				</Level>
- 
 
 41 
				<Level name="StatusName" column="statusName" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 42 
				</Level>
- 
 
 43 
			</Hierarchy>
- 
 
 44 
		</Dimension>
- 
 
 45 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Product">
- 
 
 46 
			<Hierarchy name="Product Name" hasAll="true" allMemberName="All" primaryKey="id">
- 
 
 47 
				<Table name="item">
- 
 
 48 
				</Table>
- 
 
 49 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 50 
				</Level>
- 
 
 51 
				<Level name="Product" column="id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 52 
					<NameExpression>
- 
 
 53 
						<SQL dialect="generic">
- 
 
 54 
							concat(IFNULL(model_name, &#39;&#39;), &#39; &#39;, IFNULL(model_number, &#39;&#39;), &#39;(&#39;, IFNULL(color, &#39;&#39;), &#39;)&#39;)						</SQL>
- 
 
 55 
					</NameExpression>
- 
 
 56 
				</Level>
- 
 
 57 
			</Hierarchy>
- 
 
 58 
		</Dimension>
- 
 
 59 
		<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
- 
 
 60 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
- 
 
 61 
				<Table name="item">
- 
 
 62 
				</Table>
- 
 
 63 
				<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 64 
				</Level>
- 
 
 65 
				<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 66 
				</Level>
- 
 
 67 
				<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 68 
				</Level>
- 
 
 69 
			</Hierarchy>
- 
 
 70 
		</Dimension>
- 
 
 71 
		<Dimension type="StandardDimension" foreignKey="price_range" name="Price">
- 
 
 72 
			<Hierarchy name="Price Range" hasAll="true" allMemberName="All" primaryKey="id">
- 
 
 73 
				<Table name="pricerange">
- 
 
 74 
				</Table>
- 
 
 75 
				<Level name="Price Range" column="name" nameColumn="name" ordinalColumn="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 76 
				</Level>
- 
 
 77 
			</Hierarchy>
- 
 
 78 
		</Dimension>
- 
 
 79 
		<Dimension type="StandardDimension" foreignKey="payment_method" name="Payment">
- 
 
 80 
			<Hierarchy name="Payment" hasAll="true" allMemberName="All" primaryKey="paymentmethodid">
- 
 
 81 
				<Table name="paymentmethod">
- 
 
 82 
				</Table>
- 
 
 83 
				<Level approxRowCount="6" name="Gateway" column="gateway" nameColumn="gateway" ordinalColumn="gateway" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 84 
				</Level>
- 
 
 85 
				<Level name="Payment Method" column="paymentmethodname" nameColumn="paymentmethodname" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 86 
				</Level>
- 
 
 87 
			</Hierarchy>
- 
 
 88 
		</Dimension>
- 
 
 89 
		<Dimension type="StandardDimension" foreignKey="order_hour" name="Order Hour">
- 
 
 90 
			<Hierarchy name="Order Hour" hasAll="true" allMemberName="All" primaryKey="hour_id">
- 
 
 91 
				<Table name="orderhour">
- 
 
 92 
				</Table>
- 
 
 93 
				<Level name="Hour Range" column="hour_range" ordinalColumn="hour_id" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 94 
				</Level>
- 
 
 95 
				<Level name="Hour" column="hour_id" type="Integer" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 96 
				</Level>
- 
 
 97 
			</Hierarchy>
- 
 
 98 
		</Dimension>
- 
 
 99 
		<Dimension type="StandardDimension" foreignKey="customer_id" name="First Source">
- 
 
 100 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
- 
 
 101 
				<Table name="user">
- 
 
 102 
				</Table>
- 
 
 103 
				<Level name="Source" column="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 104 
					<KeyExpression>
- 
 
 105 
						<SQL dialect="generic">
- 
 
 106 
							case when source_type = &#39;Paid&#39; then &#39;Paid&#39; when source_url like &#39;saholic.com%&#39; then &#39;Direct&#39; when source_url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 107 
					</KeyExpression>
- 
 
 108 
					<NameExpression>
- 
 
 109 
						<SQL dialect="generic">
- 
 
 110 
							case when source_type = &#39;Paid&#39; then &#39;Paid&#39; when source_url like &#39;saholic.com%&#39; then &#39;Direct&#39; when source_url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 111 
					</NameExpression>
- 
 
 112 
				</Level>
- 
 
 113 
				<Level name="Site" column="source_url" nameColumn="source_url" ordinalColumn="source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 114 
				</Level>
- 
 
 115 
			</Hierarchy>
- 
 
 116 
		</Dimension>
- 
 
 117 
		<Dimension type="StandardDimension" name="Promotion">
- 
 
 118 
			<Hierarchy name="Promotion" hasAll="true" allMemberName="All">
- 
 
 119 
				<Level name="CouponCode" table="sales" column="coupon_code" nameColumn="coupon_code" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
- 
 
 120 
				</Level>
- 
 
 121 
			</Hierarchy>
- 
 
 122 
		</Dimension>
- 
 
 123 
		<Dimension type="StandardDimension" name="Session Source">
- 
 
 124 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All">
- 
 
 125 
				<Level name="Source" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 126 
					<KeyExpression>
- 
 
 127 
						<SQL dialect="generic">
- 
 
 128 
							case when session_source_type = &#39;Paid&#39; then &#39;Paid&#39; when session_source_url like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source_url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 129 
					</KeyExpression>
- 
 
 130 
					<NameExpression>
- 
 
 131 
						<SQL dialect="generic">
- 
 
 132 
							case when session_source_type = &#39;Paid&#39; then &#39;Paid&#39; when session_source_url like &#39;saholic.com%&#39; then &#39;Direct&#39; when session_source_url like &#39;google.co%&#39; then &#39;Search&#39; else &#39;Referer&#39; end						</SQL>
- 
 
 133 
					</NameExpression>
- 
 
 134 
				</Level>
- 
 
 135 
				<Level name="Site" table="sales" column="session_source_url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 136 
				</Level>
- 
 
 137 
			</Hierarchy>
- 
 
 138 
		</Dimension>
- 
 
 139 
		<Dimension type="StandardDimension" name="Affiliate">
- 
 
 140 
			<Hierarchy name="Affiliate" hasAll="true" allMemberName="All">
- 
 
 141 
				<Level name="Affiliate" table="sales" column="aff_name" nameColumn="aff_name" ordinalColumn="aff_name" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 142 
				</Level>
- 
 
 143 
			</Hierarchy>
- 
 
 144 
		</Dimension>
- 
 
 145 
		<Dimension type="StandardDimension" foreignKey="days_to_purchase" name="Days To Purchase">
- 
 
 146 
			<Hierarchy name="Days To Purchase" hasAll="true" allMemberName="All" primaryKey="id">
- 
 
 147 
				<Table name="daystopurchaserange">
- 
 
 148 
				</Table>
- 
 
 149 
				<Level name="Days To Purchase" column="id" nameColumn="name" ordinalColumn="id" type="Integer" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
- 
 
 150 
				</Level>
- 
 
 151 
			</Hierarchy>
- 
 
 152 
		</Dimension>
- 
 
 153 
		<Measure name="Quantity" column="quantity" datatype="Numeric" formatString="##,###" aggregator="sum" visible="true">
- 
 
 154 
		</Measure>
- 
 
 155 
		<Measure name="Total Sales" column="total_amount" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
- 
 
 156 
		</Measure>
- 
 
 157 
		<Measure name="Transfer Price" datatype="Numeric" formatString="##,##,###" aggregator="sum" visible="true">
- 
 
 158 
			<MeasureExpression>
- 
 
 159 
				<SQL dialect="generic">
- 
 
 160 
					transfer_price*quantity				</SQL>
- 
 
 161 
			</MeasureExpression>
- 
 
 162 
		</Measure>
- 
 
 163 
		<CalculatedMember name="Profit" caption="Profit" formula="[Measures].[Total Sales]-[Measures].[Transfer Price]" dimension="Measures" visible="true">
- 
 
 164 
		</CalculatedMember>
- 
 
 165 
		<CalculatedMember name="Average Selling Price" caption="Average Selling Price" formula="[Measures].[Total Sales]/[Measures].[Quantity]" dimension="Measures" visible="true">
- 
 
 166 
		</CalculatedMember>
- 
 
 167 
	</Cube>
- 
 
 168 
	<Cube name="SalesBookingCube" cache="true" enabled="true">
- 
 
 169 
		<Table name="sales">
- 
 
 170 
		</Table>
19 
		<Dimension type="TimeDimension" foreignKey="booking_date_id" name="BookingDate">
 171 
		<Dimension type="TimeDimension" foreignKey="booking_date_id" name="BookingDate">
20 
			<Hierarchy name="BookingDate" hasAll="true" allMemberName="All" primaryKey="date_id">
 172 
			<Hierarchy name="BookingDate" hasAll="true" allMemberName="All" primaryKey="date_id">
21 
				<Table name="datedim">
 173 
				<Table name="datedim" alias="bookingdatedim">
22 
				</Table>
 174 
				</Table>
23 
				<Level approxRowCount="3" name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
 175 
				<Level approxRowCount="3" name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
24 
				</Level>
 176 
				</Level>
25 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
 177 
				<Level approxRowCount="4" name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
26 
				</Level>
 178 
				</Level>
27 
				<Level approxRowCount="8" name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
 179 
				<Level approxRowCount="12" name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
28 
				</Level>
 180 
				</Level>
29 
				<Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
 181 
				<Level approxRowCount="20" name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
30 
				</Level>
 182 
				</Level>
31 
			</Hierarchy>
 183 
			</Hierarchy>
32 
		</Dimension>
 184 
		</Dimension>