| 2401 |
ankur.sing |
1 |
<Schema name="SalesSchema">
|
|
|
2 |
<Cube name="SalesCube" cache="true" enabled="true">
|
|
|
3 |
<Table name="salesNew">
|
|
|
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="true" levelType="TimeQuarters" hideMemberIf="Never">
|
|
|
12 |
</Level>
|
|
|
13 |
<Level name="Month" column="monthname" type="String" uniqueMembers="true" levelType="TimeMonths" hideMemberIf="Never">
|
|
|
14 |
</Level>
|
|
|
15 |
<Level name="Date" column="dayofmonth" type="Integer" uniqueMembers="true" levelType="TimeDays" hideMemberIf="Never">
|
|
|
16 |
</Level>
|
|
|
17 |
</Hierarchy>
|
|
|
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 name="State" column="state" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
24 |
</Level>
|
|
|
25 |
<Level 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="Status" column="description" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
38 |
</Level>
|
|
|
39 |
</Hierarchy>
|
|
|
40 |
</Dimension>
|
|
|
41 |
<Dimension type="StandardDimension" foreignKey="item_id" name="Product">
|
|
|
42 |
<Hierarchy name="Product" hasAll="true" allMemberName="All" primaryKey="id">
|
|
|
43 |
<Table name="item">
|
|
|
44 |
</Table>
|
|
|
45 |
<Level name="ProductGroup" column="product_group" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
46 |
</Level>
|
|
|
47 |
<Level name="Brand" column="brand" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
48 |
</Level>
|
|
|
49 |
<Level name="ModelNumber" column="model_number" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
50 |
</Level>
|
|
|
51 |
<Level name="Color" column="color" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
52 |
</Level>
|
|
|
53 |
</Hierarchy>
|
|
|
54 |
</Dimension>
|
| 2532 |
vikas |
55 |
<Dimension type="StandardDimension" foreignKey="item_id" name="Category">
|
|
|
56 |
<Hierarchy name="Category" hasAll="true" allMemberName="All" primaryKey="id">
|
|
|
57 |
<Table name="item" schema="" alias="">
|
|
|
58 |
</Table>
|
|
|
59 |
<Level name="ParentCategory" column="parent_category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
60 |
</Level>
|
|
|
61 |
<Level name="Category" column="category" type="String" uniqueMembers="true" levelType="Regular" hideMemberIf="Never">
|
|
|
62 |
</Level>
|
|
|
63 |
</Hierarchy>
|
|
|
64 |
</Dimension>
|
| 2401 |
ankur.sing |
65 |
<Measure name="TotalSales" column="unit_price" datatype="Numeric" formatString="##,###.00" aggregator="sum" visible="true">
|
|
|
66 |
</Measure>
|
|
|
67 |
<Measure name="Quantity" column="quantity" datatype="Integer" formatString="##,###" aggregator="sum" visible="true">
|
|
|
68 |
</Measure>
|
| 2517 |
vikas |
69 |
<Measure name="Average Selling price" column="unit_price" datatype="Numeric" formatString="##,###" aggregator="avg" visible="true">
|
|
|
70 |
</Measure>
|
| 2401 |
ankur.sing |
71 |
</Cube>
|
|
|
72 |
</Schema>
|