| 3543 |
vikas |
1 |
<Schema name="ProductActivitySchema">
|
|
|
2 |
<Cube name="ProductActivityCube" cache="true" enabled="true">
|
|
|
3 |
<Table name="productactivity">
|
|
|
4 |
</Table>
|
|
|
5 |
<Dimension type="TimeDimension" foreignKey="date_id" name="OrderDate">
|
|
|
6 |
<Hierarchy name="OrderDate" 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 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 name="Date" column="dayofmonth" type="Integer" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never">
|
|
|
16 |
</Level>
|
|
|
17 |
</Hierarchy>
|
|
|
18 |
</Dimension>
|
|
|
19 |
<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Category">
|
|
|
20 |
<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
|
|
|
21 |
<Table name="item">
|
|
|
22 |
</Table>
|
|
|
23 |
<Level name="Parent" column="parent_category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
|
|
|
24 |
</Level>
|
|
|
25 |
<Level name="Category" column="category" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
|
|
|
26 |
</Level>
|
|
|
27 |
<Level name="Product Group" column="product_group" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
|
|
|
28 |
</Level>
|
|
|
29 |
</Hierarchy>
|
|
|
30 |
</Dimension>
|
|
|
31 |
<Dimension type="StandardDimension" foreignKey="catalog_item_id" name="Product">
|
|
|
32 |
<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="catalog_item_id">
|
|
|
33 |
<Table name="item">
|
|
|
34 |
</Table>
|
|
|
35 |
<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
36 |
</Level>
|
|
|
37 |
<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
38 |
</Level>
|
|
|
39 |
<Level name="Color" column="color" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
|
|
|
40 |
</Level>
|
|
|
41 |
</Hierarchy>
|
|
|
42 |
</Dimension>
|
|
|
43 |
<Dimension type="StandardDimension" name="Paid First Source">
|
|
|
44 |
<Hierarchy name="Paid First Source" hasAll="true" allMemberName="All">
|
|
|
45 |
<Level name="Paid First Source" table="productactivity" column="is_first_source_paid" type="Boolean" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
|
|
|
46 |
</Level>
|
|
|
47 |
</Hierarchy>
|
|
|
48 |
</Dimension>
|
|
|
49 |
<Dimension type="StandardDimension" foreignKey="first_source_id" name="First Source">
|
|
|
50 |
<Hierarchy name="Source" hasAll="true" allMemberName="All" primaryKey="id">
|
|
|
51 |
<Table name="source">
|
|
|
52 |
</Table>
|
|
|
53 |
<Level name="First Source" column="url" nameColumn="url" ordinalColumn="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
|
|
|
54 |
</Level>
|
|
|
55 |
</Hierarchy>
|
|
|
56 |
</Dimension>
|
|
|
57 |
<Dimension type="StandardDimension" name="Paid Session Source">
|
|
|
58 |
<Hierarchy name="Paid Session Source" hasAll="true" allMemberName="All">
|
|
|
59 |
<Level name="Paid Session Source" table="productactivity" column="is_session_source_paid" type="Boolean" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
|
|
|
60 |
</Level>
|
|
|
61 |
</Hierarchy>
|
|
|
62 |
</Dimension>
|
|
|
63 |
<Dimension type="StandardDimension" foreignKey="session_source_id" name="Session Source">
|
|
|
64 |
<Hierarchy name="Session Source" hasAll="true" allMemberName="All" primaryKey="id">
|
|
|
65 |
<Table name="source" alias="session_source">
|
|
|
66 |
</Table>
|
|
|
67 |
<Level name="SessionSource" column="url" nameColumn="url" ordinalColumn="url" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never">
|
|
|
68 |
</Level>
|
|
|
69 |
</Hierarchy>
|
|
|
70 |
</Dimension>
|
|
|
71 |
<Measure name="View" column="view" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
|
|
|
72 |
</Measure>
|
|
|
73 |
<Measure name="AddToCart" column="add_to_cart" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
|
|
|
74 |
</Measure>
|
|
|
75 |
<Measure name="Shipping" column="shipping_access" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
|
|
|
76 |
</Measure>
|
|
|
77 |
<Measure name="ProceedToPay" column="proceed_to_pay" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
|
|
|
78 |
</Measure>
|
|
|
79 |
<Measure name="Order Creation" column="order_creation" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
|
|
|
80 |
</Measure>
|
|
|
81 |
<Measure name="PaymentFail" column="payment_failure" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
|
|
|
82 |
</Measure>
|
|
|
83 |
<Measure name="PaymentOk" column="payment_success" formatString="##,###" aggregator="sum" visible="true">
|
|
|
84 |
</Measure>
|
|
|
85 |
</Cube>
|
|
|
86 |
</Schema>
|