Subversion Repositories SmartDukaan

Rev

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

Rev 3838 Rev 5156
Line 1... Line 1...
1 
<Schema name="ProductActivitySchema">
 1 
<Schema name="ProductActivitySchema">
2 
	<Cube name="ProductActivityCube" cache="true" enabled="true">
 2 
	<Cube name="ProductActivityCube" cache="true" enabled="true">
3 
		<Table name="productactivity">
 3 
		<Table name="productactivity">
- 
 
 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>
4 
		</Table>
 70 
		</Table>
5 
		<Dimension type="TimeDimension" foreignKey="date_id" name="OrderDate">
 71 
		<Dimension type="TimeDimension" foreignKey="date_id" name="OrderDate">
6 
			<Hierarchy name="OrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
 72 
			<Hierarchy name="OrderDate" hasAll="true" allMemberName="All" primaryKey="date_id">
7 
				<Table name="datedim">
 73 
				<Table name="datedim">
8 
				</Table>
 74 
				</Table>
Line 16... Line 82...
16 
				</Level>
 82 
				</Level>
17 
			</Hierarchy>
 83 
			</Hierarchy>
18 
		</Dimension>
 84 
		</Dimension>
19 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Category">
 85 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Category">
20 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
 86 
			<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
21 
				<Table name="catalog_item">
 87 
				<Table name="item">
22 
				</Table>
 88 
				</Table>
23 
				<Level name="Parent" column="parent_category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 89 
				<Level name="Parent" column="parent_category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
24 
				</Level>
 90 
				</Level>
25 
				<Level name="Category" column="category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 91 
				<Level name="Category" column="category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
26 
				</Level>
 92 
				</Level>
Line 28... Line 94...
28 
				</Level>
 94 
				</Level>
29 
			</Hierarchy>
 95 
			</Hierarchy>
30 
		</Dimension>
 96 
		</Dimension>
31 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Product">
 97 
		<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Product">
32 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
 98 
			<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
33 
				<Table name="catalog_item">
 99 
				<Table name="item">
34 
				</Table>
 100 
				</Table>
35 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 101 
				<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
36 
				</Level>
 102 
				</Level>
37 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
 103 
				<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
38 
				</Level>
 104 
				</Level>
Line 72... Line 138...
72 
				</Level>
 138 
				</Level>
73 
				<Level name="Site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
 139 
				<Level name="Site" column="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
74 
				</Level>
 140 
				</Level>
75 
			</Hierarchy>
 141 
			</Hierarchy>
76 
		</Dimension>
 142 
		</Dimension>
- 
 
 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>
77 
		<Measure name="View" column="unique_view" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 151 
		<Measure name="View" column="unique_view" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
78 
		</Measure>
 152 
		</Measure>
79 
		<Measure name="AddToCart" column="unique_add_to_cart" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 153 
		<Measure name="AddToCart" column="unique_add_to_cart" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
80 
		</Measure>
 154 
		</Measure>
81 
		<Measure name="Shipping" column="unique_shipping_access" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 155 
		<Measure name="Shipping" column="unique_shipping_access" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
82 
		</Measure>
 156 
		</Measure>
83 
		<Measure name="ProceedToPay" column="unique_proceed_to_pay" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 157 
		<Measure name="ProceedToPay" column="unique_proceed_to_pay" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
84 
		</Measure>
 158 
		</Measure>
85 
		<Measure name="Order Creation" column="order_creation" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 159 
		<Measure name="Order Creation" column="unique_order_creation" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
86 
		</Measure>
 160 
		</Measure>
87 
		<Measure name="PaymentFail" column="payment_failure" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
 161 
		<Measure name="PaymentFail" column="unique_payment_failure" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
88 
		</Measure>
 162 
		</Measure>
89 
		<Measure name="PaymentOk" column="payment_success" formatString="##,###" aggregator="sum" visible="true">
 163 
		<Measure name="PaymentOk" column="unique_payment_success" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
90 
		</Measure>
 164 
		</Measure>
91 
	</Cube>
 165 
	</Cube>
92 
</Schema>
 166 
</Schema>