Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
3543 vikas 1 
<Schema name="ProductActivitySchema">
2 
	<Cube name="ProductActivityCube" cache="true" enabled="true">
3 
		<Table name="productactivity">
5156 anupam.sin 4 
			<AggName name="agg_dateonly_productactivity" ignorecase="true">
5 
				<AggFactCount column="fact_count">
6 
				</AggFactCount>
7 
				<AggForeignKey factColumn="date_id" aggColumn="date_id">
8 
				</AggForeignKey>
9 
				<AggMeasure column="unique_view" name="[Measures].[View]">
10 
				</AggMeasure>
11 
				<AggMeasure column="unique_add_to_cart" name="[Measures].[AddToCart]">
12 
				</AggMeasure>
13 
				<AggMeasure column="unique_shipping_access" name="[Measures].[Shipping]">
14 
				</AggMeasure>
15 
				<AggMeasure column="unique_payment_success" name="[Measures].[PaymentOk]">
16 
				</AggMeasure>
17 
				<AggMeasure column="unique_order_creation" name="[Measures].[Order Creation]">
18 
				</AggMeasure>
19 
				<AggMeasure column="unique_payment_failure" name="[Measures].[PaymentFail]">
20 
				</AggMeasure>
21 
				<AggMeasure column="unique_proceed_to_pay" name="[Measures].[ProceedToPay]">
22 
				</AggMeasure>
23 
			</AggName>
24 
			<AggName name="agg_lostitem_productactivity" ignorecase="true">
25 
				<AggFactCount column="fact_count">
26 
				</AggFactCount>
27 
				<AggForeignKey factColumn="date_id" aggColumn="date_id">
28 
				</AggForeignKey>
29 
				<AggForeignKey factColumn="session_source_id" aggColumn="session_source_id">
30 
				</AggForeignKey>
31 
				<AggForeignKey factColumn="first_source_id" aggColumn="first_source_id">
32 
				</AggForeignKey>
33 
				<AggMeasure column="unique_view" name="[Measures].[View]">
34 
				</AggMeasure>
35 
				<AggMeasure column="unique_add_to_cart" name="[Measures].[AddToCart]">
36 
				</AggMeasure>
37 
				<AggMeasure column="unique_shipping_access" name="[Measures].[Shipping]">
38 
				</AggMeasure>
39 
				<AggMeasure column="unique_payment_success" name="[Measures].[PaymentOk]">
40 
				</AggMeasure>
41 
				<AggMeasure column="unique_order_creation" name="[Measures].[Order Creation]">
42 
				</AggMeasure>
43 
				<AggMeasure column="unique_payment_failure" name="[Measures].[PaymentFail]">
44 
				</AggMeasure>
45 
				<AggMeasure column="unique_proceed_to_pay" name="[Measures].[ProceedToPay]">
46 
				</AggMeasure>
47 
			</AggName>
48 
			<AggName name="agg_dateitem_productactivity" ignorecase="true">
49 
				<AggFactCount column="fact_count">
50 
				</AggFactCount>
51 
				<AggForeignKey factColumn="date_id" aggColumn="date_id">
52 
				</AggForeignKey>
53 
				<AggForeignKey factColumn="catalog_item_id" aggColumn="catalog_item_id">
54 
				</AggForeignKey>
55 
				<AggMeasure column="unique_view" name="[Measures].[View]">
56 
				</AggMeasure>
57 
				<AggMeasure column="unique_add_to_cart" name="[Measures].[AddToCart]">
58 
				</AggMeasure>
59 
				<AggMeasure column="unique_shipping_access" name="[Measures].[Shipping]">
60 
				</AggMeasure>
61 
				<AggMeasure column="unique_payment_success" name="[Measures].[PaymentOk]">
62 
				</AggMeasure>
63 
				<AggMeasure column="unique_order_creation" name="[Measures].[Order Creation]">
64 
				</AggMeasure>
65 
				<AggMeasure column="unique_payment_failure" name="[Measures].[PaymentFail]">
66 
				</AggMeasure>
67 
				<AggMeasure column="unique_proceed_to_pay" name="[Measures].[ProceedToPay]">
68 
				</AggMeasure>
69 
			</AggName>
3543 vikas 70 
		</Table>
71 
		<Dimension type="TimeDimension" foreignKey="date_id" name="OrderDate">
72 
			<Hierarchy name="OrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
73 
				<Table name="datedim">
74 
				</Table>
75 
				<Level name="Year" column="year" type="Integer" uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never">
76 
				</Level>
77 
				<Level name="Quarter" column="quarter" type="String" uniqueMembers="false" levelType="TimeQuarters" hideMemberIf="Never">
78 
				</Level>
79 
				<Level name="Month" column="monthnumber" nameColumn="monthname" ordinalColumn="monthnumber" type="Integer" uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never">
80 
				</Level>
81 
				<Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
82 
				</Level>
83 
			</Hierarchy>
84 
		</Dimension>
85 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Category">
86 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
5156 anupam.sin 87 
				<Table name="item">
3543 vikas 88 
				</Table>
89 
				<Level name="Parent" column="parent_category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
90 
				</Level>
91 
				<Level name="Category" column="category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
92 
				</Level>
93 
				<Level name="Product Group" column="product_group" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
94 
				</Level>
95 
			</Hierarchy>
96 
		</Dimension>
97 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Product">
98 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
5156 anupam.sin 99 
				<Table name="item">
3543 vikas 100 
				</Table>
101 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
102 
				</Level>
103 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
104 
				</Level>
105 
			</Hierarchy>
106 
		</Dimension>
107 
		<Dimension type="StandardDimension" foreignKey="first_source_id" name="First Source">
3707 vikas 108 
			<Hierarchy name="First Source" hasAll="true" allMemberName="All" primaryKey="id">
3543 vikas 109 
				<Table name="source">
110 
				</Table>
3838 vikas 111 
				<Level name="First Source" column="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
3707 vikas 112 
					<KeyExpression>
113 
						<SQL dialect="generic">
3838 vikas 114 
							case when source.is_paid = 1 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>
3707 vikas 115 
					</KeyExpression>
116 
					<NameExpression>
117 
						<SQL dialect="generic">
3838 vikas 118 
							case when source.is_paid = 1 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>
3707 vikas 119 
					</NameExpression>
3543 vikas 120 
				</Level>
3707 vikas 121 
				<Level name="site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
122 
				</Level>
3543 vikas 123 
			</Hierarchy>
124 
		</Dimension>
125 
		<Dimension type="StandardDimension" foreignKey="session_source_id" name="Session Source">
126 
			<Hierarchy name="Session Source" hasAll="true" allMemberName="All" primaryKey="id">
127 
				<Table name="source" alias="session_source">
128 
				</Table>
3838 vikas 129 
				<Level name="SessionSource" column="id" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
3707 vikas 130 
					<KeyExpression>
131 
						<SQL dialect="generic">
3838 vikas 132 
							case when session_source.is_paid = 1 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>
3707 vikas 133 
					</KeyExpression>
134 
					<NameExpression>
135 
						<SQL dialect="generic">
3838 vikas 136 
							case when session_source.is_paid = 1 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>
3707 vikas 137 
					</NameExpression>
3543 vikas 138 
				</Level>
3707 vikas 139 
				<Level name="Site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
140 
				</Level>
3543 vikas 141 
			</Hierarchy>
142 
		</Dimension>
5156 anupam.sin 143 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Price Range">
144 
			<Hierarchy name="Price Range" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
145 
				<Table name="item">
146 
				</Table>
147 
				<Level name="Price Range" column="price_range" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
148 
				</Level>
149 
			</Hierarchy>
150 
		</Dimension>
3708 vikas 151 
		<Measure name="View" column="unique_view" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 152 
		</Measure>
3708 vikas 153 
		<Measure name="AddToCart" column="unique_add_to_cart" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 154 
		</Measure>
3708 vikas 155 
		<Measure name="Shipping" column="unique_shipping_access" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 156 
		</Measure>
3708 vikas 157 
		<Measure name="ProceedToPay" column="unique_proceed_to_pay" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 158 
		</Measure>
5156 anupam.sin 159 
		<Measure name="Order Creation" column="unique_order_creation" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 160 
		</Measure>
5156 anupam.sin 161 
		<Measure name="PaymentFail" column="unique_payment_failure" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 162 
		</Measure>
5156 anupam.sin 163 
		<Measure name="PaymentOk" column="unique_payment_success" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
3543 vikas 164 
		</Measure>
165 
	</Cube>
166 
</Schema>